Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-consumer-enabled.html
Returns YES or NO to indicate whether a given Performance Schema consumer is enabled, or NULL if the argument is NULL. If the argument is not a valid consumer name, an error occurs. This function accounts for the consumer hierarchy, so a consumer ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-instrument-default-enabled.html
Returns YES or NO to indicate whether a given Performance Schema instrument is enabled by default. Example mysql> SELECT sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf'); ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-instrument-default-timed.html
Returns YES or NO to indicate whether a given Performance Schema instrument is timed by default. Example mysql> SELECT sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf'); ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-consumer.html
Disables Performance Schema consumers with names that contain the argument. Parameters consumer VARCHAR(128): The value used to match consumer names, which are identified by using %consumer% as an operand for a LIKE pattern match. Example Disable ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-instrument.html
Disables Performance Schema instruments with names that contain the argument. Parameters in_pattern VARCHAR(128): The value used to match instrument names, which are identified by using %in_pattern% as an operand for a LIKE pattern match. Example ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-enable-consumer.html
Enables Performance Schema consumers with names that contain the argument. Parameters consumer VARCHAR(128): The value used to match consumer names, which are identified by using %consumer% as an operand for a LIKE pattern match. Example Enable all ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-enable-instrument.html
Enables Performance Schema instruments with names that contain the argument. Parameters in_pattern VARCHAR(128): The value used to match instrument names, which are identified by using %in_pattern% as an operand for a LIKE pattern match. Example ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-statement-digest.html
Traces all Performance Schema instrumentation for a specific statement digest. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...