Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-histogram-summary-tables.html
Example statement histogram information: mysql> SELECT * FROM performance_schema.events_statements_histogram_by_digest WHERE SCHEMA_NAME = 'mydb' AND DIGEST = 'bb3f69453119b2d7b3ae40673a9d4c7c' AND COUNT_BUCKET > 0 ORDER BY BUCKET_NUMBER\G ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-filtering.html
The order in which matching occurs matters because different matching setup_actors rows can have different USER and HOST values. The threads table contains a row for each server thread. Each row contains information about a thread and indicates ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
You should be aware that there is no guarantee that multiple statements affecting privileges originating from different SQL nodes are executed on all SQL nodes in the same order. The privileges granted to a MySQL account determine which operations ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-alias.html
An alias can be used in a query select list to give a column a different name. This restriction is imposed because when the WHERE clause is evaluated, the column value may not yet have been determined. In the select list of a query, a quoted column ...
https://dev.mysql.com/doc/refman/8.4/en/regexp.html
This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression operations. MySQL implements regular ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. You can rename tables locked with a LOCK TABLES statement, ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-optimizer.html
(In general, this is not a good practice, even outside of replication.) Examples of nondeterministic statements include DELETE or UPDATE statements that use LIMIT with no ORDER BY clause; see Section 19.5.1.18, “Replication and LIMIT”, for a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-row-searches.html
If there are suitable indexes, one index is selected from the candidates, in the following priority order: A primary key. When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-auto-positioning.html
The source must have GTID_MODE=ON set in order for the connection to succeed. GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and replica. When GTIDs ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-slavebaseconfig.html
Updates received from A must be logged by B to its binary log, in order to be passed on to C. Each replica must have a unique server ID, as specified by the server_id system variable. If you are setting up multiple replicas, each one must have a ...