PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-errors.html
SHOW ERRORS [LIMIT [offset,] row_count] SHOW COUNT(*) ERRORS SHOW ERRORS is a diagnostic statement that is similar to SHOW WARNINGS, except that it displays information only for errors, rather than for errors, warnings, and notes. The LIMIT clause ...You can also retrieve this number from the error_count variable: SHOW COUNT(*) ERRORS; SELECT @@error_count; SHOW ERRORS and error_count apply only to errors, not warnings or ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-file-io-type.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. total The total number of occurrences of the file I/O event for the host.
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-stages.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. total The total number of occurrences of the stage event for the host. By ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-lock-waits.html
These views summarize the InnoDB locks that transactions are waiting for. wait_age How long the lock has been waited for, as a TIME value. wait_age_secs How long the lock has been waited for, in seconds. For more information, see Identifying a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). Tables in these schemas are excluded ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-progress-reporting.html
The following sys schema views provide progress reporting for long-running transactions: processlist session x$processlist x$session Assuming that the required instruments and consumers are enabled, the progress column of these views shows the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-lock-waits.html
For additional information, see the description of the Performance Schema metadata_locks table at Section 25.12.12.1, “The metadata_locks Table”. waiting_thread_id The thread ID of the thread that is waiting for the lock. waiting_pid The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-session-ssl-status.html
For each connection, this view displays the SSL version, cipher, and count of reused SSL sessions. The session_ssl_status view has these columns: thread_id The thread ID for the connection.
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-elements.html
To identify them, use this query: SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE '%thread_pool%'; For more information, see Chapter 25, MySQL Performance Schema. MySQL Enterprise Thread Pool comprises these elements: A plugin ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on ...For ...