Search Results
https://dev.mysql.com/doc/refman/9.7/en/sys-execute-prepared-stmt.html
Configuration Options execute_prepared_stmt() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 30.4.2.1, “The sys_config Table”): debug, @sys.debug If this option is ... Given an SQL statement as a string, executes it as a prepared ...
https://dev.mysql.com/doc/refman/9.7/en/sys-host-summary-by-file-io-type.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. These views summarize file I/O, grouped by host and event type. By default, ...
https://dev.mysql.com/doc/refman/9.7/en/sys-host-summary-by-file-io.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. By default, rows are sorted by descending total file I/O latency. The ...
MySQL 9.7 Reference Manual :: 30.4.3.4 The host_summary_by_stages and x$host_summary_by_stages Views
https://dev.mysql.com/doc/refman/9.7/en/sys-host-summary-by-stages.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. By default, rows are sorted by host and descending total latency. The ...
https://dev.mysql.com/doc/refman/9.7/en/sys-memory-by-host-by-current-bytes.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. By default, rows are sorted by descending amount of memory used. The ...
https://dev.mysql.com/doc/refman/9.7/en/sys-memory-by-user-by-current-bytes.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. By default, rows are sorted by descending amount of memory used. The ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-is-thread-instrumented.html
This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Returns YES or NO to indicate whether Performance Schema instrumentation for a given connection ID ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-disable-thread.html
This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Given a connection ID, disables Performance Schema instrumentation for the thread. Example Disable a ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-enable-thread.html
This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Given a connection ID, enables Performance Schema instrumentation for the thread. Example Enable a ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-show-enabled.html
Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...