PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-temp-tables.html
total_latency The total wait time of timed occurrences of the statement. last_seen The time at which the statement was most recently seen. These views list normalized statements that have used temporary tables. By default, rows are sorted by ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current timestamp). For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, ...An auto-updated column remains unchanged if all other columns are set to their current ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples-compression-sect.html
Compressing or uncompressing pages has consumed less than a second since the time the statistics were reset, because the columns COMPRESS_TIME and UNCOMPRESS_TIME are zero. This copying of SUM(PAGE_SIZE*RELOCATION_OPS) bytes has consumed less than a ... Example 17.1 Using the Compression Information Schema Tables The following is sample output from a database that contains compressed tables (see Section 17.9, “InnoDB Table and Page Compression”, INNODB_CMP, INNODB_CMP_PER_INDEX, and ...
https://dev.mysql.com/doc/refman/8.0/en/query-log.html
The general query log is a general record of what mysqld is doing. The general query log can be very useful when you suspect an error in a client and want to know exactly what the client sent to mysqld. mysqld writes statements to the query log in ...The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from ...
https://dev.mysql.com/doc/refman/8.0/en/replication-bugs.html
When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug report. Please spend some time and effort in preparing a good bug report. $> mysqlbinlog ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-file-io-type.html
total_latency The total wait time of timed occurrences of the file I/O event for the host. max_latency The maximum single wait time of timed occurrences of the file I/O event for the host. These views summarize file I/O, grouped by host and event ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-stages.html
total_latency The total wait time of timed occurrences of the stage event for the host. avg_latency The average wait time per timed occurrence of the stage event for the host. By default, rows are sorted by host and descending total latency. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-file-io-type.html
latency The total wait time of timed occurrences of the file I/O event for the user. max_latency The maximum single wait time of timed occurrences of the file I/O event for the user. These views summarize file I/O, grouped by user and event type.
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-stages.html
total_latency The total wait time of timed occurrences of the stage event for the user. avg_latency The average wait time per timed occurrence of the stage event for the user. By default, rows are sorted by user and descending total stage latency.
https://dev.mysql.com/doc/refman/8.0/en/innodb-next-key-locking.html
The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different times. For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, ...