Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-tables.html
Then the Performance Schema increments by one the CURRENT_CONNECTIONS and TOTAL_CONNECTIONS columns in that row. When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
The value is unique for the server instance because these IDs are generated using a global counter that is incremented atomically. The table stores one row per thread showing the current status of the thread's most recent monitored statement event, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-model.html
Data collected by the Performance Schema for this buffer is lost, and any corresponding “lost instance” counters are incremented. Memory used depends on the load actually seen, not the load estimated or explicitly configured for. As the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
If the statement cannot be instrumented, Performance_schema_prepared_statements_lost status variable is incremented. The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary protocol.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-configuration-version-table.html
Whenever a member action is enabled or disabled using the group_replication_enable_member_action() and group_replication_disable_member_action() functions, the version number is incremented. This table displays the version of the member actions ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-rwlock-instances-table.html
READ_LOCKED_BY_COUNT When a thread currently has an rwlock locked in shared (read) mode, READ_LOCKED_BY_COUNT is incremented by 1. The rwlock_instances table lists all the rwlock (read write lock) instances seen by the Performance Schema while the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-startup-configuration.html
The Performance Schema autoscales many parameters to use memory only as required; see Section 29.17, “The Performance Schema Memory-Allocation Model”. For example, put the following lines in a my.cnf file to change the sizes of the history ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variables.html
For a given connection, if the client sends connection attribute key-value pairs for which the aggregate size is larger than the reserved storage permitted by the value of the performance_schema_session_connect_attrs_size system variable, the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-stats-table.html
This number is incremented when a statement starts executing, not when it finishes. The tp_thread_group_stats table has these columns: TP_GROUP_ID The thread group ID. QUERIES_QUEUED The number of statements received that were queued for execution.
https://dev.mysql.com/doc/refman/8.4/en/replace.html
There are no user-visible effects other than a possible difference in how the storage engine increments Handler_xxx status variables. REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, ...