common_schema is a framework for MySQL server administration.

common_schema provides with server side scripting via QueryScript, analysis & informational views, and a function library, allowing for easier administration and diagnostics for MySQL. It introduces SQL based tools which simplify otherwise complex shell and client scripts, allowing the DBA to be independent of operating system, installed packages and dependencies.

It is a self contained schema, compatible with all MySQL >= 5.1 servers. Installed by importing the schema into the server, there is no need to configure nor compile. No special plugins are required, and no changes to your configuration.

common_schema has a small footprint (well under 1MB).

Please refer to the common_schema documentation for details.

Distributions

common_schema comes in different distributions, fitting and utilizing the different MySQL versions and flavors:

• common_schema_mysql_51: fits all MySQL >= 5.1 distributions
• common_schema_innodb_plugin: fits MySQL >= 5.1, with InnoDB plugin + INFORMATION_SCHEMA tables enabled
• common_schema_percona_server: fits Percona Server >= 5.1

Refer to the documentation for more details.

Risks

Refer to the documentation for more details.