common_schema

status

NAME

TYPE

DESCRIPTION

status provides with metadata/status information on common_schema internals.

The metadata provided by the status view can be essential for:

• Integrity/versioning: by knowing the exact version/revision of common_schema
• Diagnostics: as an essential information in a bug report
• More diagnostics: knowing the envorinment in which common_schema runs

STRUCTURE

mysql> desc common_schema.status;
+-------------------------------------+----------+------+-----+---------+-------+
| Field                               | Type     | Null | Key | Default | Extra |
+-------------------------------------+----------+------+-----+---------+-------+
| project_name                        | longtext | YES  |     | NULL    |       |
| version                             | longtext | YES  |     | NULL    |       |
| revision                            | longtext | YES  |     | NULL    |       |
| install_time                        | longtext | YES  |     | NULL    |       |
| install_success                     | longtext | YES  |     | NULL    |       |
| base_components_installed           | longtext | YES  |     | NULL    |       |
| innodb_plugin_components_installed  | longtext | YES  |     | NULL    |       |
| percona_server_components_installed | longtext | YES  |     | NULL    |       |
| install_mysql_version               | longtext | YES  |     | NULL    |       |
| install_sql_mode                    | longtext | YES  |     | NULL    |       |
+-------------------------------------+----------+------+-----+---------+-------+

SYNOPSIS

Columns of this view:

• project_name: this is the text "common_schema"
• version: external version number
• revision: internal revision number (more granular than version)
• install_time: TIMESTAMP at which common_schema as installed
• install_success: boolean, installation result. "1" indicates success
• base_components_installed: boolean. "1" indicates that base components were installed.
• innodb_plugin_components_installed: boolean. "1" indicates InnoDB Plugin components were installed.
• percona_server_components_installed: boolean. "1" indicates Percona Server components were installed.
• install_mysql_version: version of MySQL at the time of common_schema installation.
• install_sql_mode: the sql_mode used when creation common_schema. This applies to stored routines even though the DBA may change the global sql_mode, as MySQL's stored routines retain the snapshot of sql_mode by which they were created.

EXAMPLES

mysql> SELECT * FROM status \G
*************************** 1. row ***************************
                       project_name: common_schema
                            version: 1.1
                           revision: 243
                       install_time: 2012-07-04 08:35:13
                    install_success: 1
          base_components_installed: 1
 innodb_plugin_components_installed: 1
percona_server_components_installed: 0
              install_mysql_version: 5.1.51-log
                   install_sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER

ENVIRONMENT

SEE ALSO

AUTHOR