MySQL Forums
Forum List  »  Performance

Re: MySQL 5.5.31 cripplingly slow
Posted by: Rick James
Date: January 17, 2014 05:13PM

Here's the data, via SQL. I'll leave it up to you as far as how to turn that into a usable monitoring.
SELECT  ENGINE,
        ROUND(SUM(data_length) /1024/1024, 1) AS "Data MB",
        ROUND(SUM(index_length)/1024/1024, 1) AS "Index MB",
        ROUND(SUM(data_length + index_length)/1024/1024, 1) AS "Total MB",
        COUNT(*) "Num Tables"
    FROM  INFORMATION_SCHEMA.TABLES
    WHERE  table_schema not in ("information_schema", "performance_schema")
    GROUP BY  ENGINE;
It could take minute(s) to run if you have a lot of tables.

Options: ReplyQuote


Subject
Views
Written By
Posted
2676
January 15, 2014 07:16AM
1123
January 15, 2014 11:44AM
1185
January 15, 2014 02:12PM
3438
January 17, 2014 05:52AM
1450
January 17, 2014 07:56AM
1215
January 17, 2014 11:23AM
1247
January 17, 2014 11:29AM
1316
January 17, 2014 02:03PM
1092
January 17, 2014 02:43PM
Re: MySQL 5.5.31 cripplingly slow
1241
January 17, 2014 05:13PM
1485
January 18, 2014 09:53AM
1164
January 18, 2014 04:00PM
1142
January 18, 2014 08:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.