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/partitioning-selection.html
MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for rows matching a given WHERE condition. Partition selection is similar to partition pruning, in that only specific ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
If you use InnoDB tables, you can use the mysqlbackup command from the MySQL Enterprise Backup component to produce a consistent snapshot. Assuming the above exceptions do not apply to your database, use the cold backup technique to obtain a ... If ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-progress-reporting.html
The following sys schema views provide progress reporting for long-running transactions: processlist session x$processlist x$session Assuming that the required instruments and consumers are enabled, the progress column of these views shows the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-statistics-with-buffer.html
These views summarize table statistics, including InnoDB buffer pool statistics. innodb_buffer_allocated The total number of InnoDB buffer bytes allocated for the table. innodb_buffer_data The total number of InnoDB data bytes allocated for the ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
See Chapter 14, The InnoDB Storage Engine, and Chapter 15, Alternative Storage Engines. Row Format InnoDB tables are created using the DYNAMIC row format by default. To use a row format other than DYNAMIC, configure innodb_default_row_format, or ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
The default minimum length of words that are found by full-text searches is three characters for InnoDB search indexes, or four characters for MyISAM. You can control the cutoff by setting a configuration option before creating the index: ... By ...
https://dev.mysql.com/doc/refman/5.7/en/index-page-merge-threshold.html
If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index page. When the ...The ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
In practice, the advanced InnoDB performance features mean that InnoDB tables often outperform the simpler MyISAM tables, especially for a busy database. Compression is available for all kinds of workloads with InnoDB tables, and for read-only ...
https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html
If you need to rebuild an InnoDB table because a CHECK TABLE operation indicates that a table upgrade is required, use mysqldump to create a dump file and mysql to reload the file. If the CHECK TABLE operation indicates that there is a corruption or ... This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character ...