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-schema-table-statistics-with-buffer.html
The schema_table_statistics_with_buffer and x$schema_table_statistics_with_buffer views have these columns: table_schema The schema that contains the table. These views summarize table statistics, including InnoDB buffer pool statistics. By ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-statistics.html
The schema_table_statistics and x$schema_table_statistics views have these columns: table_schema The schema that contains the table. By default, rows are sorted by descending total wait time (tables with most contention first). total_latency The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-tables-with-full-table-scans.html
The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans views have these columns: object_schema The schema name. These views display which tables are being accessed with full table scans. rows_full_scanned The total number ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-unused-indexes.html
These views display indexes for which there are no events, which indicates that they are not being used. This view is most useful when the server has been up and processing long enough that its workload is representative. Otherwise, presence of an ...
https://dev.mysql.com/doc/refman/5.7/en/sys-session-ssl-status.html
The session_ssl_status view has these columns: thread_id The thread ID for the connection. For each connection, this view displays the SSL version, cipher, and count of reused SSL sessions.
https://dev.mysql.com/doc/refman/5.7/en/sys-session.html
For descriptions of the columns, see Section 26.4.3.22, “The processlist and x$processlist Views”. These views are similar to processlist and x$processlist, but they filter out background processes to display only user sessions.
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-analysis.html
The statement_analysis and x$statement_analysis views have these columns: query The normalized statement string. db The default database for the statement, or NULL if there is none. full_scan The total number of full table scans performed by ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-errors-or-warnings.html
The statements_with_errors_or_warnings and x$statements_with_errors_or_warnings views have these columns: query The normalized statement string. These views display normalized statements that have produced errors or warnings. By default, rows are ...
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 ...