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/sys-waits-by-host-by-latency.html
max_latency The maximum single wait time of timed occurrences of the event for the host. total_latency The total wait time of timed occurrences of the event for the host. avg_latency The average wait time per timed occurrence of the event for the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-waits-by-user-by-latency.html
max_latency The maximum single wait time of timed occurrences of the event for the user. total_latency The total wait time of timed occurrences of the event for the user. avg_latency The average wait time per timed occurrence of the event for the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-waits-global-by-latency.html
max_latency The maximum single wait time of timed occurrences of the event. total_latency The total wait time of timed occurrences of the event. avg_latency The average wait time per timed occurrence of the event. The waits_global_by_latency and ...
https://dev.mysql.com/doc/refman/5.7/en/cursor-restrictions.html
For example, if a client executes a query but is only interested in the first row, the remaining rows are not transferred. Initially, this is a MEMORY table, but is converted to a MyISAM table when its size exceeds the minimum value of the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-concepts.html
A backup is a snapshot of the database at a given time. The data actually stored in the database tables at the time that the backup was made Transaction log. A sequential record telling how and when data was stored in the database Each of these ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-multiple-nodes.html
The following are issues relating to the use of multiple MySQL servers as NDB Cluster SQL nodes, and are specific to the NDBCLUSTER storage engine: Stored programs not distributed. Stored procedures, stored functions, triggers, and scheduled events ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. For example, INT(4) specifies an INT with a display width of four digits. This optional display ...
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: city ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the database.