PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-index-statistics.html
The schema_index_statistics and x$schema_index_statistics views have these columns: table_schema The schema that contains the table. select_latency The total wait time of timed reads using the index. insert_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics.html
By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these columns: table_schema The schema that contains the table. total_latency The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-full-table-scans.html
By default, rows are sorted by descending percentage of time a full scan was done and descending total latency. rows_examined The total number of rows read from the storage engine for the table. rows_examined_avg The average number of rows read from ... These views display normalized statements that have done full table ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-runtimes-in-95th-percentile.html
rows_sent The total number of rows returned by occurrences of the statement. rows_sent_avg The average number of rows returned per occurrence of the statement. rows_examined The total number of rows read from storage engines by occurrences of the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-config.html
This table contains sys schema configuration options, one row per option. set_time The timestamp of the most recent modification to the row. set_by The account that made the most recent modification to the row. The value is NULL if the row has not ...Configuration changes made by updating this table persist across client sessions and server ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-statement-latency.html
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 background. rows_sent The total number of rows returned by statements for the user. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-statement-type.html
By default, rows are sorted by user and descending total latency. 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 background. rows_sent ... These views summarize information about statements executed, grouped by user and statement ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
row *************************** CATALOG_NAME: def SCHEMA_NAME: mysql DEFAULT_CHARACTER_SET_NAME: utf8mb4 DEFAULT_COLLATION_NAME: utf8mb4_0900_ai_ci SQL_PATH: NULL DEFAULT_ENCRYPTION: NO *************************** 2. row *************************** ...It contains tables that store information required by the MySQL server as it ...
https://dev.mysql.com/doc/refman/8.0/en/user-resources.html
An “account” in this context corresponds to a row in the mysql.user system table. That is, a connection is assessed against the User and Host values in the user table row that applies to the connection. For example, an account ... One means of ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
When a client connects successfully, the server authenticates the client to a particular row in this table. The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which ...