Issue Space for databases increasing ????

[boosterfan]

Hey guys,

the used webspace is increasing day by day. Statistics show it is space for the databases. But in this abo we just have one database with soooo much less space needed than shown in the statistics??? More than 57 GB for database, but the database just shows less 3 GB ??

What can this be??

 

[Kaspar]

The database size mentioned in the Statistics is the the actual size being consumed to store the whole database on the disk of your server. If you run the command sudo du -h /var/lib/mysql/<database_name> you'll get the same size as shown in the Statistics.

The smaller size displayed with your database is the size only of the (raw)data stored in it. Add some disk fragmentation and the actual disk size of your database becomes significantly higher.

These are some links on this topic you'll maybe find useful to read:

How to reclaim MySql disk space

I have a table in MySql server and the table contains around 1M rows. Only because of one column table is taking more disk space day by day. The datatype of this column is Mediumblob. Table size is

stackoverflow.com

MySQL: My table size using a query does not match the IBD's file size on disk

I have a table with about 600 million rows. I ran the following commands and noticed select table_schema "DB name (table_schema)", -> sum((data_length+index_length)/1024/1024/1024) AS "DB...

dba.stackexchange.com

Substantial difference between database size under MySQL and actual size on disk

When I check the size of my databases under MySQL I get this: MariaDB [(none)]> SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB", ...

dba.stackexchange.com