N
N
nioterzor2018-04-17 19:59:28
MySQL
nioterzor, 2018-04-17 19:59:28

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

1 answer(s)
L
Lazy @BojackHorseman MySQL, 2018-04-17
Tag

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 question

Ask a Question

731 491 924 answers to any question