Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/replication-options-replica.html
log_slow_replica_statements Command-Line Format --log-slow-replica-statements[={OFF|ON}] System Variable log_slow_replica_statements Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF When the slow query log is enabled, ...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.4/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. SIGUSR1 causes the server to flush the error log, general query log, and slow query log. As mentioned previously, flushing the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
Auto Query Time Estimation provides: Runtimes for successfully executed queries Runtime estimates for EXPLAIN queries. Runtime estimates for queries that fail due to an out-of-memory error. Auto Query Time Estimation can provide runtime data for up ...Runtime data can be used for query optimization, troubleshooting, or to estimate the cost of running a particular query or workload on MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
This topic describes how to debug queries that fail to offload to MySQL HeatWave for execution. Setting Secondary Engine Definition By default, SELECT queries are offloaded to MySQL HeatWave for execution and fall back to the DB System if that is ...To learn how to download the sample database, see AirportDB Analytics ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 1670; Symbol: ER_BINLOG_UNSAFE_SYSTEM_TABLE; SQLSTATE: HY000 Message: The statement is unsafe because it uses the general log, slow query log, or performance_schema table(s). Error number: 3550; Symbol: ER_IS_QUERY_INVALID_CLAUSE; ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym ...| table_synonym WITH READ LOCK | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-cli.html
slow-query-log N/A enable-slow-log bool true, false false configure, reconfigure N/A Whether the slow query log is enabled. slow-query-log-file N/A slow-log-file, slowlogname File name N/A {host_name}-slow.log configure, reconfigure ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/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 ...