Here are two MySQL commands that will give you more insight regarding the size of your database as well as each individual table:
NOTE: These are SELECT queries, and do not change or modify your data in any way.
Database Size Query:
SELECT table_schema "Database", ROUND(sum( data_length + index_length ) / 1024 / 1024, 3) "Database Size in MB", ROUND(sum( data_free )/ 1024 / 1024, 3) "Free Space in MB" FROM information_schema.TABLES WHERE table_schema = "jamfsoftware";
Table Size Query:
SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME AS 'Table', CONCAT(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2)," MB") AS Size FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA like '%jamfsoftware%';
How do you get to MySQL to run these queries?
From terminal: mysql -u root
Then just enter either of the queries above to get your information.
You could also search for specific tables by doing the following from the terminal (NOT MYSQL):
mysql -u root -e "SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME AS 'Table', CONCAT(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2),' MB') AS Size FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA like '%jamfsoftware%';" | grep plugins
This command will show only lines that contain "plugins" in them.
Hope this helps people with their database maintenance!
-Josh
