PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-failover.html
This means that the ndb_apply_status table contains information for the replica on this host as well as for any other host which acts as a replica of the replication source server running on this host. Using the information obtained from the query ... In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication ...
https://dev.mysql.com/doc/refman/8.0/en/no-login-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”). For alternative methods of protecting proxied accounts against direct use, ... The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses ...
https://dev.mysql.com/doc/refman/8.0/en/no-matching-rows.html
If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously wrong. Remove ...
https://dev.mysql.com/doc/refman/8.0/en/parenthesized-query-expressions.html
| TABLE | VALUES order_by_clause: ORDER BY as for SELECT limit_clause: LIMIT as for SELECT into_clause: INTO as for SELECT set_op: UNION | INTERSECT | EXCEPT MySQL 8.0.22 and higher supports parenthesized query expressions according to the preceding ... parenthesized_query_expression: ( query_expression [order_by_clause] [limit_clause] ) [order_by_clause] [limit_clause] [into_clause] query_expression: query_block [set_op query_block [set_op query_block ...]] [order_by_clause] [limit_clause] [into_clause] query_block: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-examples.html
The following example provides one methodology that you can use to analyze a repeatable problem, such as investigating a performance bottleneck. To begin, you should have a repeatable use case where performance is deemed “too slow” and needs ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-startup-configuration.html
Consumer names in the setup_consumers table use underscores, but for consumers set at startup, dashes and underscores within the name are equivalent. The other variables indicate table sizes (number of rows) or memory allocation values. For example, ... To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to ...
https://dev.mysql.com/doc/refman/8.0/en/primary-key-optimization.html
The primary key for a table represents the column or set of columns that you use in your most vital queries. With the InnoDB storage engine, the table data is physically organized to do ultra-fast lookups and sorts based on the primary key column ...Query performance benefits from the NOT NULL optimization, because it cannot include any NULL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-skip.html
Details of the error and the last successfully applied transaction are recorded in the Performance Schema table replication_applier_status_by_worker. Alternatively, you can issue SHOW RELAYLOG EVENTS on the replica or SHOW BINLOG EVENTS on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html
The replication_applier_configuration Performance Schema table contains the DESIRED_DELAY column which shows the delay configured using the SOURCE_DELAY | MASTER_DELAY option. The replication_applier_status Performance Schema table contains the ...