PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-maintenance.html
myisamchk operations that affect indexes can cause MyISAM FULLTEXT indexes to be rebuilt with full-text parameters that are incompatible with the values used by the MySQL server. These statements can be used directly or by means of the mysqlcheck ...
https://dev.mysql.com/doc/refman/8.0/en/optimization.html
This chapter explains how to optimize MySQL performance and provides examples. Sometimes you can be proactive and plan in advance for performance, while other times you might troubleshoot a configuration or code issue after a problem occurs.
https://dev.mysql.com/doc/refman/8.0/en/optimize-character.html
When MySQL retrieves any value from a row, it reads a data block containing all the columns of that row (and possibly other adjacent rows). When you use a randomly generated value as a primary key in an InnoDB table, prefix it with an ascending ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-queries.html
Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns for each table, columns that are used in the most important and time-critical queries. To ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns.html
Columns using other data types relating to dates or times are not supported as partitioning columns. The discussions of RANGE COLUMNS and LIST COLUMNS partitioning in the next two sections assume that you are already familiar with partitioning based ... The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
By limiting the search, it is possible to expend much less time and effort in finding matching rows than by scanning all partitions in the table. Pruning can also be applied for tables partitioned on a DATE or DATETIME column when the partitioning ... The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-runtime-configuration.html
Specific Performance Schema features can be enabled at runtime to control which types of event collection occur. If there are Performance Schema configuration changes that must be made at runtime using SQL statements and you would like these ...If ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-consumers-table.html
If you disable a consumer, the server does not spend time adding event information to it. For detailed information about the effect of enabling different consumers, see Section 29.4.7, “Pre-Filtering by Consumer”. The setup_consumers table has ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-relaylog.html
Relay log files have the same format as binary log files and can be read using mysqlbinlog (see Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”). If binary log transaction compression (available as of MySQL 8.0.20) is in ... The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log ...
https://dev.mysql.com/doc/refman/8.0/en/request-access.html
A '%' or blank Host value means “any host.” A '%' or blank Db value means “any database.” The server reads the db table into memory and sorts it at the same time that it reads the user table. For example, if you want to execute mysqladmin ...