IF(ISNULL(B.table_schema)+ISNULL(B.engine)=2, IF(ISNULL(table_schema)=1,'ZZZZZZZZZZZZZZZZ',table_schema) schemaname, SELECT IF(ISNULL(table_schema)=1,10,0) schema_score, Query to Give You Database Size Grouped By Database and Storage Engine in MB SELECT Statistic,DataSize "Data Size", WHERE table_schema NOT IN ('mysql','information_schema','performance_schema')) AAA ![]() SELECT IFNULL(DB,'All Databases') DBName, WHERE table_schema NOT IN ('mysql','information_schema','performance_schema') I still use them for reporting to clients. ![]() ![]() I wrote these about 2 years ago and they work just great. I have a rather wild set of queries that would address this nicely.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |