PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-id.html
This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Returns the Performance Schema thread ID assigned to a given connection ID, or the thread ID for the ...
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
The schema_table_lock_waits and x$schema_table_lock_waits views have these columns: object_schema The schema containing the object to be locked. These views display which sessions are blocked waiting on metadata locks, and what is blocking them.
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io-type.html
The user_summary_by_file_io_type and x$user_summary_by_file_io_type views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and ... These views summarize file I/O, grouped by user and event ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io.html
The user_summary_by_file_io and x$user_summary_by_file_io views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are ...By ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-stages.html
The user_summary_by_stages and x$user_summary_by_stages views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported ...By default, rows are sorted by user and descending total stage ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-latency.html
The user_summary_by_statement_latency and x$user_summary_by_statement_latency views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-type.html
The user_summary_by_statement_type and x$user_summary_by_statement_type views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads ... These views summarize informaion about statements executed, grouped by user and statement ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary.html
The user_summary and x$user_summary views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of ... These views summarize statement activity, file I/O, and connections, grouped by ...
https://dev.mysql.com/doc/refman/5.7/en/system-schema.html
Grant System Tables These system tables contain grant information about user accounts and the privileges held by them: user: User accounts, global privileges, and other nonprivilege columns. It contains tables that store information required by the ...