Answer the question
In order to leave comments, you need to log in
Large amount of database on disk?
I have a mysql database with 300 tables. Actively written and cleared every day via truncate (the next day's data is already irrelevant).
For a day of actual data, it runs up to 3 gigabytes, but on disk they occupy under 50 GB.
Why and what can be done about it?
There are no problems with cleaning, truncate frees up space.
All tables: a pair of ints, a pair of varchar(256) and a timestamp.
Answer the question
In order to leave comments, you need to log in
because the server is greedy and does not give back what it took there is an article on this topic
in the dock
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question