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/optimization.html
Optimizing CPU and memory usage can also improve scalability, allowing the database to handle more load without slowing down. This chapter explains how to optimize MySQL performance and provides examples. Depending on your job role (developer, DBA, ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
This operation can be slow if the table is large or if the indexes being rebuilt do not fit into the buffer pool. The first run after adding a lot of data to a table is often much slower than later runs. Once your data reaches a stable size, or a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
If the server has a mix of InnoDB transactions and non-InnoDB transactions, the compression controlled by this system variable interferes with the work of this process and can slow it significantly. The MySQL Server system variables described in ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-interface.html
These settings help as the number of replicas increases, because contention for locks can slow down performance. When you install the source and replica plugins for semisynchronous replication (see Section 19.4.10.1, “Installing Semisynchronous ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
Assuming the above exceptions do not apply to your database, use the cold backup technique to obtain a reliable binary snapshot of InnoDB tables: do a slow shutdown of the MySQL Server, then copy the data files manually. If the source database ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-troubleshooting.html
After the errors are fixed, perform a slow shutdown (by setting innodb_fast_shutdown=0) before attempting the upgrade again. A schema mismatch in a MySQL 5.7 instance between the .frm file of a table and the InnoDB data dictionary can cause an ...
https://dev.mysql.com/doc/refman/8.0/en/windows-testing.html
In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. (Be sure that an account exists that specifies an IP address or you may not be able ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
Run all the load statements, then run all the queries in the query file with five clients (five times each): mysqlslap --concurrency=5 --iterations=5 --query=query.sql --create=create.sql --delimiter=";" mysqlslap supports the following options, ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
With the optional ALL keyword, duplicate-row removal does not occur and the result includes all matching rows from all queries in the union. Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using ...
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
(For an example, see Section 10.2.2.2, “Optimizing Subqueries with Materialization”.) If merging would result in an outer query block that references more than 61 base tables, the optimizer chooses materialization instead. Even for queries that ...The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...