SELECT Statment to Determine Total Amount of Data
Posted on 2012-08-10
Hello everyone -
I used to have a select statement that I would copy and paste into the MySQL command line client that would return the total amount of data contained within the MySQL server databases.
It included the total data stored in addition to the data size of all indexes, etc.
It was excellent for planning how much space I would need during migrations.
However, I have lost access to that statement.
Would anyone be able to help me formulate a new select statement to address the above?
Thank you very much in advance.