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/rewriter-query-rewrite-plugin-reference.html
Rewriter_number_rewritten_queries The number of queries rewritten by the Rewriter query rewrite plugin since it was loaded. Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-query-expansion.html
Full-text search supports query expansion (and in particular, its variant “blind query expansion”). This is generally useful when a search phrase is too short, which often means that the user is relying on implied knowledge that the full-text ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-queries.html
To tune queries for InnoDB tables, create an appropriate set of indexes on each table. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. This is a good way to make queries faster if you have a ...This updates a value for each index part that indicates the average number of rows that have the same ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-query-profiling.html
The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE statements. The setup_actors table can be used to ...
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 ...