Search Results
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/8.4/en/start-group-replication.html
You cannot specify an empty or null string, or omit the USER option if PASSWORD is specified. START GROUP_REPLICATION [USER='user_name'] [, PASSWORD='user_pass'] [, DEFAULT_AUTH='plugin_name'] Starts group replication. This statement requires the ...
https://dev.mysql.com/doc/refman/8.4/en/start-replica.html
The option cannot be set to an empty or null string. START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
oe [NOT] IN (SELECT ie ...) The predicate is IN or NOT IN and a result of UNKNOWN (NULL) has the same meaning as a result of FALSE. The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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 8.4 Reference Manual :: 30.4.3.4 The host_summary_by_stages and x$host_summary_by_stages Views
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/sys-host-summary-by-statement-latency.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. The host_summary_by_statement_latency and x$host_summary_by_statement_latency ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-statement-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 information about statements executed, grouped by host ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary.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 statement activity, file I/O, and connections, grouped ...