PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
Important In MySQL 5.7.11, the default --early-plugin-load value is the name of the keyring_file plugin library file, causing that plugin to be loaded by default. Important If you upgrade to MySQL 5.7.2 or later from a version older than 5.7.2, a ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
When you selectively enable or disable the effect of a group option, order is important because options are processed first to last. It remains stripped even when importing back into MySQL 5.7, which means that stored routines could behave ... The ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These software constructs result in CPU and I/O operations at the hardware level, which you must minimize and make as ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
If it is important to be able to do this, consider using the table in ways that avoid deleting rows. An update of the following form is very fast: UPDATE tbl_name SET count_col=count_col+1 WHERE key_col=constant; This is very important when you use ... Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
It is very important to remember that, when you drop a partition, you also delete all the data that was stored in that partition. However, there is one important difference in the effect this has on your use of the table afterward: You can no longer ... Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
Important Invalid DATE and DATETIME values referenced in the WHERE condition of a statement against a partitioned table are treated as NULL. Important This optimization is used only if the range size is smaller than the number of partitions. The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
To time wait events, the most important criterion is to reduce overhead, at the possible expense of the timer accuracy, so using the CYCLE timer is the best. To time statements, the most important criterion is to have an accurate measure, which is ... Events are collected by means of instrumentation added to the server source ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
mysqlimport A client that imports text files into their respective tables using LOAD DATA. Later sections provide a more detailed description of each one, with the exception of NDB Cluster programs. Each program's description indicates its ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
Important Make a backup of a table before performing a table repair operation; under some circumstances the operation might cause data loss. Telling the server to ignore the .MYI file makes important table metadata stored in the .MYI unavailable to ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-auto-increment.html
If it is important to have the same order on the source and replica, the rows must be ordered before assigning an AUTO_INCREMENT number. Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is done correctly, ...