PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-full-table-scans.html
The statements_with_full_table_scans and x$statements_with_full_table_scans views have these columns: query The normalized statement string. These views display normalized statements that have done full table scans. By default, rows are sorted by ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-runtimes-in-95th-percentile.html
The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile views have these columns: query The normalized statement string. These views list statements with runtimes in the 95th percentile. db The default ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-sorting.html
The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. db The default database for the statement, or NULL if there is none. total_latency The total wait time of timed occurrences of ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-temp-tables.html
The statements_with_temp_tables and x$statements_with_temp_tables views have these columns: query The normalized statement string. These views list normalized statements that have used temporary tables. By default, rows are sorted by descending ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-memory-usage.html
Each stored trace is a string, which is extended (using realloc()) as optimization progresses by appending more data to it. The optimizer_trace_max_mem_size server system variable sets a limit on the total amount of memory used by all traces ...
https://dev.mysql.com/doc/refman/5.7/en/verifying-md5-checksum.html
Linux and Microsoft Windows examples: $> md5sum mysql-standard-5.7.44-linux-i686.tar.gz aaab65abbec64d5e907dcd41b8699945 mysql-standard-5.7.44-linux-i686.tar.gz $> md5.exe mysql-installer-community-5.7.44.msi aaab65abbec64d5e907dcd41b8699945 ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. For example, this occurs when the statement creating a view uses the UUID() function. When running in MIXED logging format, the server ...
https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. MySQL provides ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
You can retrieve the most recent automatically generated AUTO_INCREMENT value with the LAST_INSERT_ID() SQL function or the mysql_insert_id() C API function. These functions are connection-specific, so their return values are not affected by another ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
If the value is func, the value used is the result of some function. To see which function, use SHOW WARNINGS following EXPLAIN to see the extended EXPLAIN output. The function might actually be an operator such as an arithmetic operator. The ...