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-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/channels-naming-conventions.html
Because channel names are used in replication metadata repositories, the character set used for these is always UTF-8. Although you are generally free to use any name for channels, the following names are reserved: group_replication_applier ... This ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler-thread-states.html
Waiting for scheduler to stop The thread issued SET GLOBAL event_scheduler=OFF and is waiting for the scheduler to stop. These states occur for the Event Scheduler thread, threads that are created to execute scheduled events, or threads that ...