information_schema

warning: Creating default object from empty value in /var/www/www.jonno.org/htdocs/drupal/modules/taxonomy/taxonomy.pages.inc on line 33.

MySQL: count tables by Schema and Storage Engine

select table_schema, engine, count(*) from information_schema.tables where table_schema not in ('mysql', 'information_schema', 'test') group by table_schema, engine;

+--------------+--------+----------+
| table_schema | engine | count(*) |
+--------------+--------+----------+
| gallery2     | InnoDB |       56 | 
| gallery2     | MyISAM |        2 | 
| foo          | NULL   |        1 | 
| foo          | InnoDB |        3 | 
| foo          | MyISAM |        1 | 
+--------------+--------+----------+
Syndicate content