Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-characteristics.html
Privileges are as for other databases and tables: To retrieve from performance_schema tables, you must have the SELECT privilege. The name of the performance_schema database is lowercase, as are the names of tables within it. Many tables in the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-state-table.html
This is the same as MAX(TP_THREAD_NUMBER) for the threads when selected from the tp_thread_state table. That is, these two queries are equivalent: SELECT TP_GROUP_ID, MAX_THREAD_IDS_IN_GROUP FROM tp_thread_group_state; SELECT TP_GROUP_ID, ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
To selectively examine transaction history, use the attribute columns in the transaction event tables: ACCESS_MODE, ISOLATION_LEVEL, and AUTOCOMMIT. Within the event hierarchy, wait events nest within stage events, which nest within statement ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-variables-info-table.html
The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of values. VARIABLE_SOURCE The source from which the variable was most recently set: COMMAND_LINE The variable was set on the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-tables.html
The Performance Schema instruments waits, which are events that take time. Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. These tables store wait events: ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
This can happen, for example, when the parameter is a top-level node in a SELECT list, or when it is part of a comparison operator. If a parameter is an immediate member of a SELECT list that is not part of an INSERT statement, the derived type of ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
Check this by executing mysql -u root mysql and issuing this SQL statement: SELECT * FROM user; The result should include a row with the Host and User columns matching your client's host name and your MySQL user name. After trying to connect from ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
In addition, the query log may contain statements that only select data while such statements are never written to the binary log. To specify the log destination, use the log_output system variable (as described in Section 7.4.1, “Selecting ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
The list of potential source servers is stored on the replica, and in the event of a connection failure, a new source is selected from the list based on a weighted priority that you set. You can use the asynchronous connection failover mechanism to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-if-not-exists.html
Similarly, every CREATE TABLE IF NOT EXISTS statement without a SELECT is replicated, whether or not the table already exists on the source. SELECT follows somewhat different rules; see Section 19.5.1.7, “Replication of CREATE TABLE ... IF NOT ...