Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profiling.html
The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE statements. Values are also truncated to 6 decimal ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
To verify successful initialization, use this statement: mysql> SHOW VARIABLES LIKE 'performance_schema'; +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | performance_schema | ON | ... This section briefly ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-positions.html
As an example, suppose that around 20:06:00 on March 11, 2020, an SQL statement was executed that deleted a table. Because the output of mysqlbinlog includes SET TIMESTAMP statements before each SQL statement recorded, the recovered data and related ... The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
Execution of any statement requiring a write lock on either or both of the slave_master_info and slave_relay_log_info tables is disallowed while replication is ongoing (although statements that perform only reads are permitted at any time). You can ... A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-variables.html
However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the full mode value, including NO_DIR_IN_CREATE, is passed to the receiving server. For this reason, replication of such a statement may not be safe when STATEMENT mode is in use.
https://dev.mysql.com/doc/refman/8.4/en/replication-rules.html
If a replication source server does not write a statement to its binary log, the statement is not replicated. If the server does log the statement, the statement is sent to all replicas and each replica determines whether to execute it or ignore it. On the replica side, decisions about whether to execute or ignore statements received from the source are made according to the --replicate-* options that the replica was started ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
pattern The template that indicates the pattern for statements that the rule matches. pattern_database The database used to match unqualified table names in statements. Qualified table names in statements match qualified names in the pattern if ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects.html
Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL statement. The following sections provide additional information about SQL syntax for statements related to these ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
Only statements that modify databases or tables count against the update limit. To establish resource limits for an account at account-creation time, use the CREATE USER statement. To modify limits for an existing account, use an ALTER USER ... One ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). In sandbox mode, no statements other than ALTER USER are permitted. When ...