PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-bulk-data-loading.html
If you have UNIQUE constraints on secondary keys, you can speed up table imports by temporarily turning off the uniqueness checks during the import session: SET unique_checks=0; ... SET unique_checks=1; For big tables, this saves a lot of disk I/O ... These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-instruments-table.html
This in turn causes those values to be ignored when calculating the sum, minimum, maximum, and average time values in summary tables. The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT ...| statement/sql/load | YES | YES | | statement/sql/grant | YES | YES | | statement/sql/check | YES | YES | | statement/sql/flush | YES | YES | ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlock-detection.html
Resolve these situations by setting the value of the innodb_lock_wait_timeout system variable. A wait-for list that exceeds 200 transactions is treated as a deadlock and the transaction attempting to check the wait-for list is rolled back. The same ... When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls back a transaction or transactions to break the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-visual-studio.html
Query statistics view, displaying information about the executed query such as execution times, processed rows, index and temporary tables usage, and more. The following MySQL for Visual Studio features are available as of version 2.0.2: JavaScript ... This section explains how to use MySQL Shell to script a server using MySQL for Visual ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
Previously, it was sometimes the case that increasing the number of LDM threads could lead to index memory exhaustion while large amounts of DataMemory remained available. A system name based on the time the management server was started is ... New ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
If you do not need the information provided by enabling lower-level settings, disable them and the Performance Schema executes less code on your behalf and you have less information to sift through. The consumer settings in the setup_consumers ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
You may find that there are significant gains for some and not for others, or that the gains decrease over time until you next optimize the table. The primary key value for a row is duplicated in all the secondary index records that point to the ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-crash-recovery.html
If you can be certain that no one can access the tables through mysqld while you run myisamchk, you have only to execute mysqladmin flush-tables before you start checking the tables. If you run myisamchk to check tables that mysqld is updating at ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-failure-conditions.html
The operation takes a long time and concurrent DML modifies the table so much that the size of the temporary online log exceeds the value of the innodb_online_alter_log_max_size configuration option. A timeout occurs while waiting for an exclusive ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage ...
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
Once this limit is exceeded, you must rename or remove the file before it is possible to execute any additional DDL statements. The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table ...