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/replication-features-optimizer.html
It is possible for the data on the source and replica to become different if a statement is written in such a way that the data modification is nondeterministic; that is, left up the query optimizer. (In general, this is not a good practice, even ...
https://dev.mysql.com/doc/refman/8.0/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...
https://dev.mysql.com/doc/refman/8.0/en/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
Normal operations can continue while the hash table is emptied, and executing queries that were using the hash table access the index B-trees directly instead. innodb_api_trx_level Command-Line Format --innodb-api-trx-level=# Deprecated 8.0.22 ...
https://dev.mysql.com/doc/refman/8.0/en/show-profile.html
For example, the following queries are equivalent: SHOW PROFILE FOR QUERY 2; SELECT STATE, FORMAT(DURATION, 6) AS DURATION FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = 2 ORDER BY SEQ; . Note The SHOW PROFILE and SHOW PROFILES statements are ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html
Run the server with change buffering disabled (innodb_change_buffering=0) and do a slow shutdown. You might use this technique to avoid bottlenecks that can occur with a heavily loaded MySQL instance, or you might use different configuration options ... You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-workflow.html
This includes defining custom file paths for the error log, general log, slow query log (including the configuration of seconds it requires to execute a query), and the binary log. The Logging Options step enables you to define custom file paths for ... MySQL Installer provides a wizard-like tool to install and configure new MySQL products for ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-format.html
This ID indicates which part of the server produced the message, and is consistent with general query log and slow query log messages, which include the connection thread ID. If no fatal error occurs but startup is excessively slow prior to ... Each ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-overview-requirements.html
NDB Cluster requires communication between data nodes and API nodes (including SQL nodes), as well as between data nodes and other data nodes, to execute queries and updates. Communication latency between these processes can directly affect the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync.html
Compared to fully synchronous replication, semisynchronous replication is faster, because it can be configured to balance your requirements for data integrity (the number of replicas acknowledging receipt of the transaction) with the speed of ... In ...