PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-disabling-tablespace-path-validation.html
The innodb_validate_tablespace_paths variable, introduced in MySQL 8.0.21, permits disabling tablespace path validation. Disabling path validation improves startup time on systems with a large number of tablespace files. At startup, InnoDB scans ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-memcached.html
Changes to the innodb_memcache.containers table take effect the next time the innodb_memcache.containers table is queried. This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multi-versioning.html
This removal operation is called a purge, and it is quite fast, usually taking the same order of time as the SQL statement that did the deletion. However, if the index condition pushdown (ICP) optimization is enabled, and parts of the WHERE ...It ...
https://dev.mysql.com/doc/refman/8.0/en/key-cache-restructuring.html
A key cache can be restructured at any time by updating its parameter values. For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value ...
https://dev.mysql.com/doc/refman/8.0/en/monitoring-performance-schema.html
You can query the tables in the performance_schema database to see real-time information about the performance characteristics of your server and the applications it is running.
https://dev.mysql.com/doc/refman/8.0/en/myisam-key-cache.html
To make this choice easier, the key cache module maintains all used blocks in a special list (LRU chain) ordered by time of use. To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems.
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 ...