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/innodb-preload-buffer-pool.html
To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server startup. After restarting a busy server, there is ...The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-save.html
This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. To prevent other simultaneous calls to save the configuration, ...This ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-reload-saved.html
Reloads a Performance Schema configuration saved earlier within the same session using ps_setup_save(). This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
If related data is being updated across multiple tables, queries see either all old values or all new values, not a mix of old and new values. MySQL monitors index searches for InnoDB tables, and if queries could benefit from a hash index, it builds ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
Normal operations can continue while the hash table is emptied, and executing queries that were using the hash table access the index B-trees directly instead. innodb_api_trx_level Command-Line Format --innodb-api-trx-level=# System Variable ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
Assume in addition that IndexStatSaveSize and IndexStatSaveScale are set to their default values (32K and 100, respectively). Read queries which set locks also cause operation records to be created. When queries make use of the unique hash index, ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
The slow query log can be used to find queries that take a long time to execute and are therefore candidates for optimization. By default, administrative statements are not logged, nor are queries that do not use indexes for lookups. This behavior ... The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-configuration.html
For example, a client can disable use of the query cache for its own queries like this: mysql> SET SESSION query_cache_type = OFF; If you set query_cache_type at server startup (rather than at runtime with a SET statement), only the numeric values ... Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache.html
The query cache can be useful in an environment where you have tables that do not change very often and for which the server receives many identical queries. Note The query cache is not supported for partitioned tables, and is automatically disabled ... Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
Incoming queries are compared to those in the query cache before parsing, so the following two queries are regarded as different by the query cache: SELECT * FROM tbl_name Select * from tbl_name Queries must be exactly the same (byte for byte) to be ... Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL ...