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-innodb-diskio.html
If you are certain that the zlib version is not subject to change, disable innodb_log_compressed_pages to reduce redo log generation for workloads that modify compressed data. If you follow best practices for database design and tuning techniques ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. InnoDB interprets foreign ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-load-data.html
When binlog_format=STATEMENT is set, note that LOAD DATA does not generate a warning, unlike other unsafe statements. When mysqlbinlog reads log events for LOAD DATA statements logged in statement-based format, a generated local file is created in a ... LOAD DATA is considered unsafe for statement-based logging (see Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-additionalslaves.html
To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at startup). After copying, delete the ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
In the first phase, the clustered index is scanned, and index entries are generated and added to the sort buffer. Sorted Index Builds and Optimizer Statistics Sorted index builds may result in optimizer statistics that differ from those generated by ... InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
You must check the replica's error log for error messages generated by the replication threads, or check that they are running satisfactorily with SHOW SLAVE STATUS. Issuing START SLAVE on a multithreaded replica with gaps in the sequence of ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
overall: Generate an analysis based on the content of the table specified by in_table. Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary ...
https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html
Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement ...A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html
A table can contain a maximum of 1017 columns (raised in MySQL 5.6.9 from the earlier limit of 1000). For example, you might hit this limit with a column prefix index of more than 255 characters on a TEXT or VARCHAR column, assuming a utf8mb3 ...