Friday, June 14, 2013

KNOW ABOUT COMMON_SCHEMA in MySQL


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




No comments:

Post a Comment