I'm trying to find the total size on the hard disk that all of my MySQL Workbench databases are using.
Does anyone know of an easy way to figure this out?
If nothing else, the default location mysql/workbench uses for saving the raw data on a windows machine?
Thanks in advance!
Quintis
Best Answer
I have some queries you can run against the INFORMATION_SCHEMA
Run this to get the Total MySQL Data and Index Usage By Storage Engine
Run this to get the Total MySQL Data and Index Usage By Database
Run this to get the Total MySQL Data and Index Usage By Database and Storage Engine
CAVEAT
In each query, you will see
(SELECT 3 pw)
. The pw stands for the Power Of 1024 to display the results.(SELECT 0 pw)
will Display the Report in Bytes(SELECT 1 pw)
will Display the Report in KiloBytes(SELECT 2 pw)
will Display the Report in MegaBytes(SELECT 3 pw)
will Display the Report in GigaBytes(SELECT 4 pw)
will Display the Report in TeraBytes(SELECT 5 pw)
will Display the Report in PetaBytes (please contact me if you run this one)Here is a report query with a little less formatting:
Give it a Try !!!
UPDATE
I just ran the first query as is on a client's DB
It works as is.
UPDATE 2015-01-16 14:46 EST
Here are Queries to Report Sizes and Computes the Memory Units On-The-Fly
Total MySQL Data and Index Usage By Storage Engine
Total MySQL Data and Index Usage By Database
Total MySQL Data and Index Usage By Database/Storage Engine