Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_digest_lost The number of digest instances ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-stats-table.html
The tp_thread_group_stats table has these columns: TP_GROUP_ID The thread group ID. This number is incremented when a statement starts executing, not when it finishes. QUERIES_QUEUED The number of statements received that were queued for execution.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. It is ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement later. The prepared statement is executed with EXECUTE and released with DEALLOCATE PREPARE.
https://dev.mysql.com/doc/refman/8.4/en/processlist-access.html
The following discussion enumerates the sources of process information, the privileges required to see process information, and describes the content of process list entries. The other sources have negative performance consequences because they ...
https://dev.mysql.com/doc/refman/8.4/en/program-options.html
There are several ways to specify options for MySQL programs: List the options on the command line following the program name. This is common for options that apply to a specific invocation of the program. List the options in an option file that ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
Later sections provide a more detailed description of each one, with the exception of NDB Cluster programs. Each program's description indicates its invocation syntax and the options that it supports. Section 25.5, “NDB Cluster Programs”, ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. The general query log can be very useful when you ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-skip.html
If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the replica. Before skipping a transaction, ensure that the replication I/O (receiver) thread is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-status.html
The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the source. The SHOW REPLICA STATUS statement, which you must execute on each replica, ...