Search Results
https://dev.mysql.com/doc/refman/8.4/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). The following discussion uses ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
For Windows, the tee option can be used instead to save query output, although it is not as convenient as pager for browsing output in some situations. If you are running with --safe-updates enabled, status also prints the values for the mysql ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-heatwave.html
Any changes made to the data in the DB System are automatically propagated to MySQL HeatWave Cluster, ensuring that queries always access the most up-to-date information. Figure 1.2 MySQL HeatWave Massively Parallel Architecture Push-Based ... MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-silos.html
Real-time Analytics Without ETL Analytics queries always access the latest data, as updates from transactions in MySQL automatically replicate in real time to MySQL HeatWave. This data is then loaded into the memory of the MySQL HeatWave Cluster, ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
For example, instead of these queries: SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name WHERE id > 100 LIMIT 10; SELECT FOUND_ROWS(); Use these queries instead: SELECT * FROM tbl_name WHERE id > 100 LIMIT 10; SELECT COUNT(*) FROM tbl_name WHERE id > 100; ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
Use this option if you want to increase the time allowed for queries from mysqldump before they are logged to the slow query log file. mysqldump performs a full table scan, which means its queries can often exceed a global long_query_time setting ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
The initiate and registration steps must be performed in a single connection, as the challenge received by the client during the initiate step is saved to the client connection handler. mysql supports the following options, which can be specified ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
The desired result is that both queries return the same result (the input time, converted to the equivalent value in the 'US/Central' time zone). This section describes the time zone settings maintained by MySQL, how to load the system tables ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
In such cases, all index-using queries of the form shown match at most one index entry. It remains true that index-using queries match the converted search value to a single value in the UTC index entries, rather than matching multiple UTC values ...
https://dev.mysql.com/doc/internals/en/prepared-stored.html
Conventional statements, that is, SQL queries sent in COM_QUERY protocol packet, are the only statements present in MySQL server prior to version 4.1. A physical table is represented by a heir of class handler that corresponds to the storage engine ... Let us start with a general description of the MySQL statement processing workflow in order to provide the reader with understanding of the problem of reexecution and vocabulary for the following ...