PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/query-cache-in-select.html
Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. Two query cache-related options may be specified in SELECT statements: SQL_CACHE The query result is cached if it is cacheable and the value of the query_cache_type ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, the Rewriter plugin is enabled when you install it (see Section 5.5.4.1, “Installing or Uninstalling the Rewriter Query Rewrite Plugin”). To ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-installation.html
Note If installed, the Rewriter plugin involves some overhead even when disabled. To avoid this overhead, do not install the plugin unless you plan to use it. To install or uninstall the Rewriter query rewrite plugin, choose the appropriate script ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html
MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL distributions include a postparse query rewrite plugin named Rewriter and scripts for installing ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-queries.html
By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE clauses that restrict what event information to select from the events available after pre-filtering has been applied. Pre-filtering ...
https://dev.mysql.com/doc/refman/5.7/en/query-issues.html
...
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/mysql-cluster-backup-concepts.html
A sequential record telling how and when data was stored in the database Each of these parts is saved on all nodes participating in the backup. During backup, each node saves these three parts into three files on disk: BACKUP-backup_id.node_id.ctl A ... A backup is a snapshot of the database at a given ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
Parameters in_action ENUM('snapshot', 'overall', 'delta', 'create_tmp', 'create_table', 'save', 'cleanup'): The action to take. Otherwise, it must be the name of an existing view that queries the Performance Schema ... Creates a report of the ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
The InnoDB buffer pool caches both table data and index data, speeding up lookups for queries and keeping query results in memory for reuse. The preceding tips save memory and disk space that can be wasted during too-long transactions. autocommit=1 ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...