DBA's framework for MySQL
Switch branches/tags
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
_scrap refactored all content to top directory May 27, 2014
build_data
common_schema refactored all content to top directory May 27, 2014
doc
routines overcoming MySQL stored routines bug with local variables Apr 1, 2016
scripts
tables
tests
views refactored all content to top directory May 27, 2014
CHANGELOG
LICENSE Update LICENSE Jul 30, 2016
README.md Update README.md Jul 30, 2016
build.xml overcoming MySQL stored routines bug with local variables Apr 1, 2016

README.md

common_schema

DBA's framework for MySQL

common_schema Documentation

common_schema is a framework for MySQL server administration. It provides with:

  • A function library (text functions, security routines, execution and flow control, more...)
  • A set of informational and analysis views (security, schema design, processes, transactions, more...)
    • QueryScript interpreter, allowing for server side scripting.
    • rdebug: a debugger and debugging API for MySQL stored routines (alpha)

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 (under 1MB).

The common_schema is to MySQL as jQuery is to javaScript

Baron Schwartz, High Performance MySQL, 3rd Edition

Documentation

A thorough guide to routines, views, the QueryScript language

Bug reports

Migrated from google code, please now refer to Issues

Requirements

common_schema supports MySQL 5.1, 5.5, 5.6. It supports Percona Server & MariaDB.

common_schema enables features, upon installation, according to available server features.

On some versions you may need to set stack_size = 256K in your MySQL configuration file (256K is the default value as of MySQL 5.5)

License

As of July 2016, common_schema is licensed under the MIT license (Previously GPL and the New BSD License).