PDF (US Ltr)
- 43.1Mb
PDF (A4)
- 43.2Mb
Man Pages (TGZ)
- 295.4Kb
Man Pages (Zip)
- 400.6Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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. This behavior can be changed using log_slow_admin_statements and log_queries_not_using_indexes, as described later. To ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
This prevents most The table tbl_name is full errors for SELECT operations that require a large temporary table, but also slows down queries for which in-memory tables would suffice. log_queries_not_using_indexes Command-Line Format ...If any user ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are enabled. Possible destinations for log entries are log files or the general_log and slow_log tables in ...Log Control at Server Startup Log Control at Runtime Log Table Benefits and Characteristics Log Control at Server Startup The log_output system variable specifies the destination for log ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). Normally, mysqldumpslow groups queries that are similar except for the particular values of number and ...It ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Records a broader range of queries than the slow query log. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
When the slow query log is enabled, log_slow_replica_statements enables logging for queries that have taken more than long_query_time seconds to execute on the replica. Queries are only added to the replica's slow query log when they are logged in ...If you use statement-based or mixed binary logging format, do not use cross-database queries, and do not specify database names in ... This section explains the server options and system variables that apply to replica servers and contains the following: Startup ...
https://dev.mysql.com/doc/refman/8.0/en/query-log.html
To specify the log destination, use the log_output system variable (as described in Section 7.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”). However, further logging of queries to the file does not occur unless the ... The general query log is a general record of what mysqld is ...
https://dev.mysql.com/doc/refman/8.0/en/log-file-maintenance.html
If general query logging or slow query logging to a log file is enabled, the server closes and reopens the log file. As of MySQL 8.0.19, SIGUSR1 causes the server to flush the error log, general query log, and slow query log. As mentioned ... As ...
https://dev.mysql.com/doc/refman/8.0/en/query-attributes.html
Examples of the ways query attributes may be used: A web application produces pages that generate database queries, and for each query must track the URL of the page that generated it. The most visible part of an SQL statement is the text of the ...
https://dev.mysql.com/doc/refman/8.0/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 ...