Search Results
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. The slow query log can be used to find queries that take a long time to execute ...
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 force a query to execute on MySQL HeatWave or fail if that is not possible, set the use_secondary_engine variable to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profiling.html
mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME LIKE '%statement/%'; mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME LIKE '%stage/%'; Ensure that ...
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. Verify if the ...
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
The most visible part of an SQL statement is the text of the statement. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. The general query log can be very useful when you ...Each line that shows when a client connects also includes using connection_type to indicate the protocol used to establish the ...
https://dev.mysql.com/doc/refman/8.4/en/entering-queries.html
This section describes the basic principles of entering queries, using several queries you can try out to familiarize yourself with how mysql works. The following queries are equivalent: mysql> SELECT VERSION(), CURRENT_DATE; mysql> select ...At ...
https://dev.mysql.com/doc/refman/8.4/en/parenthesized-query-expressions.html
| TABLE | VALUES order_by_clause: ORDER BY as for SELECT limit_clause: LIMIT as for SELECT into_clause: INTO as for SELECT set_op: UNION | INTERSECT | EXCEPT MySQL 8.4 supports parenthesized query expressions according to the preceding syntax. An ...
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/heatwave-aws/en/heatwave-aws-workspace-running-queries.html
Running Queries 10 Running Queries The Workspace tab in the MySQL HeatWave Console provides a Query Editor for running MySQL and MySQL HeatWave queries. Results from queries with SQL code comments might not be displayed accurately. Select the ...To ...