The
COMMON_SCHEMA provides a set of thoroughly
documented MySQL views, stored procedures and functions which simplify
otherwise complex shell and client scripting tasks.The
COMMON_SCHEMA is compatible with all MySQL 5.1 servers, and more specialized editions are available for servers running the InnoDB plugin and Percona server.It is like a Information_schema but in Common_schema we can analyze our database index,routines,data and index length,table name,column name,etc... without select the databases.
This common_schema is in sql format so we can import and easily use it.
Download from here, http://common-schema.googlecode.com/files/common_schema-1.3.1.sql
How to use common_schema?
For Example:
1.View how many databases,tables,data_size,index_size,etc.. in one line query.
mysql>select * from common_schema.data_size_per_schema;
2.View auto increment table in your database.
mysql>select * from common_schema.auto_increment_columns ;
3.View the text character tables in your databses.
mysql>select * from common_schema.text_columns;
Likewise we can do a lot with common_schema.I think it will help you without selecting the databases we can get information about the entire databases in your server.
For more information: http://common-schema.googlecode.com/svn/trunk/common_schema/doc/html/introduction.html
