Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-events.html
SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.5, “Using the Event Scheduler”. It requires the EVENT privilege for the ...
https://dev.mysql.com/doc/refman/9.7/en/show-procedure-status.html
Stored routine information is also available from the INFORMATION_SCHEMA PARAMETERS and ROUTINES tables. See Section 28.3.25, “The INFORMATION_SCHEMA PARAMETERS Table”, and Section 28.3.36, “The INFORMATION_SCHEMA ROUTINES Table”. SHOW ...
https://dev.mysql.com/doc/refman/9.7/en/show-status.html
Status variable information is also available from these sources: Performance Schema tables. Each invocation of the SHOW STATUS statement uses an internal temporary table and increments the global Created_tmp_tables value. mysql> SHOW STATUS; ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-using.html
You can also can access session data such as temporary tables, session variables, and transaction state. Session variables declared outside stored procedures can be accessed inside stored procedures; the same is true with respect to temporary tables. This section discusses the use of the API in executing and in obtaining and processing results from both simple SQL statements and prepared ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-schema.html
getTables(): Returns a list of tables (Table objects) existing within this Schema. You can obtain an instance of Schema by calling the Session object's getSchema() method; you can also obtain a list of all available databases by calling getSchemas(). Schema supports the methods listed here: existsInDatabase(): Returns true if the schema exists, otherwise ...
https://dev.mysql.com/doc/refman/9.7/en/sys-innodb-buffer-stats-by-schema.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production system ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-save.html
It is intended you call ps_setup_reload_saved() later within the same session as ps_setup_save() because the configuration is saved in TEMPORARY tables. If you end your session without invoking ps_setup_save(), the tables and lock disappear ...This ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-trace-statement-digest.html
If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and indicate the polling duration and interval. in_start_fresh BOOLEAN: Whether to ...
https://dev.mysql.com/doc/refman/9.7/en/sys-statement-analysis.html
full_scan The total number of full table scans performed by occurrences of the statement. tmp_tables The total number of internal in-memory temporary tables created by occurrences of the statement. tmp_disk_tables The total number of internal ...The ...