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/query-log.html
However, further logging of queries to the file does not occur unless the FILE log destination is selected. If the destination is NONE, the server writes no queries even if the general log is enabled. The general query log is a general record of ...
https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html
At this point, it is more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. This section describes the basic principles of entering queries, using ... Make sure that you are connected to the server, as discussed in the previous ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-status-and-maintenance.html
However, if two or more queries use the same table, only one table block needs to be allocated. It counts the number of queries that have been removed from the cache to free up memory for caching new queries. The query cache uses a least recently ...
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
However, further logging of queries to the file does not occur unless the FILE log destination is selected. This enables the use of queries that select only those log entries that satisfy specific criteria. For example, to select log contents ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-thread-states.html
These thread states are associated with the query cache (see Section 8.10.3, “The MySQL Query Cache”). checking privileges on cached query The server is checking whether the user has privileges to access a cached query result. checking query ...
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
For join queries, the number of possible plans investigated by the MySQL optimizer grows exponentially with the number of tables referenced in a query. However, when larger queries are submitted, the time spent in query optimization may easily ...
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 ...