Total MySQL disk usage

[AlexCl]

Hi guys,

I'm looking at migrating to a new server with SSD's for the OS and MySQL and wanted to find out how much space MySQL is currently using. I've looked around Google but haven't been able to find a solution.

Is there any option in WHM to see total MySQL disk usage ? Or any other option?

Thanks!

 

[kdean]

For raw file usage, go to shell

du -ksh /var/lib/mysql/

or for individual databaseses

du -ksh /var/lib/mysql/*

or to see what MYSQL reports as the size (which depending on your database type may report less than the actual file size), go to PHPMyAdmin from WHM, select SQL at the top and paste and run:

SELECT table_schema "Data Base Name", 
sum( data_length + index_length ) / 1024 / 
1024 "Data Base Size in MB", 
sum( data_free )/ 1024 / 1024 "Free Space in MB" 
FROM information_schema.TABLES 
GROUP BY table_schema ;

 

[AlexCl]

Hi kdean,

Thank you very much for that, exactly what I needed.

Cheers!