Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-summary-tables.html
For summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, or users with no connections, and resets the summary columns to zero or NULL for the remaining rows. In addition, each error summary table that is ... The Performance Schema maintains summary tables for aggregating statistical information about server errors (and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-processlist-table.html
This is the same value displayed in the Id column of the SHOW PROCESSLIST statement, displayed in the PROCESSLIST_ID column of the Performance Schema threads table, and returned by the CONNECTION_ID() function within the thread. unauthenticated user ... The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-summary-tables.html
For summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, or users with no connections, and resets the summary columns to zero for the remaining rows. In addition, each stage summary table that is ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
For other summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, or users with no connections, and resets the summary columns to zero for the remaining rows. In addition, each statement summary table that ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-state-table.html
The tp_thread_state table has one row per thread created by the thread pool to handle connections. The value shown in this column is one of CONNECTION_HANDLER_WORKER_THREAD, LISTENER_WORKER_THREAD, QUERY_WORKER_THREAD, or TIMER_WORKER_THREAD. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-summary-tables.html
For summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, or users with no connections, and resets the summary columns to zero for the remaining rows. In addition, each transaction summary table that is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
Statements that work with nontransactional engines have no effect on the transaction state of the connection. The cost of transaction instrumentation can be reduced various ways, such as enabling or disabling transaction instrumentation according to ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
Examples: SET PERSIST max_connections = 1000; SET @@PERSIST.max_connections = 1000; SET PERSIST_ONLY back_log = 100; SET @@PERSIST_ONLY.back_log = 100; MySQL also provides a RESET PERSIST statement for removing persisted system variables from ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
Static global privileges and passwords are unaffected for a connected client. Any user can connect and perform any operation, which is insecure. If the mysqld server is started without the --skip-grant-tables option, it reads all grant table ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-scope.html
Data in motion in the replication event stream, which is sent to MySQL clients including mysqlbinlog, is decrypted for transmission, and should therefore be protected in transit by the use of connection encryption (see Section 8.3, “Using ...