Forums

Shrinking MySQL database

Hello.

I have django project and MySQL database. Shoud I worry about shrinking database, or is it automatic?

eveningwatch | 3 posts | Nov. 21, 2021, 5:32 p.m. | permalink

You should not worry about your MySQL database management.

Staff fjl | 4352 posts | PythonAnywhere staff | Nov. 21, 2021, 5:44 p.m. | permalink

Ok. Let's say my DB size is 100 Mb. If I delete from it 70 Mb, what will happen? Will DB size become 30 Mb?

eveningwatch | 3 posts | Jan. 4, 2023, 2:42 p.m. | permalink

It may. It depends on your indexes and other things that are database dependant.

Staff glenn | 9498 posts | PythonAnywhere staff | Jan. 5, 2023, 11:12 a.m. | permalink