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-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-object-overview.html
This view summarizes the types of objects within each schema. Note For MySQL instances with a large number of objects, this view might take a long time to execute. object_type The object type: BASE TABLE, INDEX (index_type), EVENT, FUNCTION, ...
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 ...