PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/optimizing-myisam-bulk-data-loading.html
These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.1, “Optimizing INSERT Statements”. For a MyISAM table, you can use concurrent inserts to add rows at the same time that SELECT statements are running, if ...
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
TRUNCATE PARTITION prunes locks; only the partitions to be emptied are locked. In MySQL 5.7, partition lock pruning eliminates unneeded locks in many cases, and most statements reading from or updating a partitioned MyISAM table cause only the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
It is not possible under normal circumstances in NDB Cluster to create an NDB Cluster table using any partitioning type other than [LINEAR] KEY, and attempting to do so fails with an error. The following limitations apply to the use of storage ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-tables.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. For details, see the description of that variable in Section 5.1.7, “Server System Variables”. The MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html
The Performance Schema maintains tables for collecting current and recent transaction events, and aggregates that information in summary tables. Section 25.12.7, “Performance Schema Transaction Tables” describes the events on which transaction ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
The INFORMATION_SCHEMA has tables that contain system and status variable information (see Section 24.3.11, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”, and Section 24.3.10, “The INFORMATION_SCHEMA GLOBAL_STATUS and ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-checking.html
In complex scenarios where the query uses SQL SECURITY DEFINER views or stored routines, it may be that a user is denied from seeing the trace of its query because it lacks some extra privileges on those objects. In that case, the trace will be ...
https://dev.mysql.com/doc/refman/5.7/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-max-allowed-packet.html
max_allowed_packet sets an upper limit on the size of any single message between the MySQL server and clients, including replicas. If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is ...