Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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/mysql-em-plugin/en/myoem-config-metric-slowquerylogging-category.html
Table 7.32 Slow Query Logging Configuration Metrics NameDescriptionLog Queries Not Using Indexes Enabled If you are using this option with the slow query log enabled, queries that are expected to retrieve all rows are logged. Log Slow Queries ...
https://dev.mysql.com/doc/refman/8.4/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.4/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/mysql-em-plugin/en/myoem-metric-slowquerylogging-activity-category.html
Table 6.30 Slow Query Logging Activity Metrics NameDescriptionSlow Queries (Delta) The number of queries that have taken more than long_query_time seconds . Lists the Slow Query Logging Activity metrics and provides a brief description of each.
https://dev.mysql.com/doc/refman/8.4/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/heatwave/en/mys-hw-metadata-queries-query-history.html
The rpd_query_stats table stores query compilation and execution statistics (the query history) for the last 1000 successfully executed queries. To view the MySQL HeatWave query history including query start time, end time, and wait time in the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-query-analyzer-queries.html
Figure 32.2 Normalized Queries and Statistics Graphs The statement graph displays the average execution time, number of executions, and the number of rows affected. Click on an individual query to see more detailed information about the individual ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-offload.html
The sys.processlist and sys.x$processlist views in the MySQL sys Schema also include an execution_engine column.