status

NAME

status: General metadata/status of common_schema

TYPE

View

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

MySQL 5.1 or newer.

SEE ALSO

help()

AUTHOR

Shlomi Noach
 
common_schema documentation