sys Schema Stored Procedures Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name (such as  info  rather than  INFORMATION_SCHEMA ). Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin  system variable. That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables. See Section 5.1.9.1, “System Variable Privileges” . Data collected for  diagnostics()  includes this information: 28.4.4.2 The diagnostics() Procedure Example Parameters • in_db_name VARCHAR(64) : The name of the schema for which to create the synonym. • in_synonym VARCHAR(64) : The name to use for the synonym schema. This schema must not already exist. •Information from the  metrics  view (see Section 28.4.3.21, “The metrics View” ) 5183 mysql>  SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | | world | +--------------------+ +---------------------------------------+ | summary | +---------------------------------------+ | Created 63 views in the info database | +---------------------------------------+ +--------------------+ | Database | +--------------------+ | information_schema | | info | | mysql | | performance_schema | | sys | | world | +--------------------+ +---------------------------------------+------------+ | Tables_in_info | Table_type | +---------------------------------------+------------+ | character_sets | VIEW | | collation_character_set_applicability | VIEW | | collations | VIEW | | column_privileges | VIEW | | columns | VIEW | ... mysql>  CALL sys.create_synonym_db(’INFORMATION_SCHEMA’, ’info’); mysql>  SHOW DATABASES; mysql>  SHOW FULL TABLES FROM info;