PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-file-summary-tables.html
The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations. Each file I/O summary table has one or more grouping columns to indicate how the table aggregates events. Event names refer to names of event ...Example file I/O event summary information: mysql> SELECT * FROM performance_schema.file_summary_by_event_name\G ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-performance-timers-table.html
Note As of MySQL 5.7.21, the Performance Schema setup_timers table is deprecated and is removed in MySQL 8.0, as is the TICKS row in the performance_timers table. The performance_timers table has these columns: TIMER_NAME The name by which to refer ...The rows that do not contain NULL indicate which timers you can use in ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-coordinator-table.html
For a multithreaded replica, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the coordinator thread. For a multithreaded replica, the replication_applier_status_by_worker table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-repair-table.html
When used on a corrupted or otherwise damaged table, it is possible for the REPAIR TABLE statement to delete rows that cannot be recovered. However, any such modifications of table data performed by this statement are not replicated, which can ...
https://dev.mysql.com/doc/refman/5.7/en/table-corruption.html
If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or 'crashed'. If this happens, MySQL writes an entry in the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-connection-control-failed-login-attempts-table.html
This table provides information about the current number of consecutive failed connection attempts per account (user/host combination). Notes The CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS plugin must be activated for this table to be available, and ...CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS has these columns: USERHOST The user/host combination indicating an account that has failed connection attempts, in 'user_name'@'host_name' ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-connection-control-table-reference.html
Table 24.9 INFORMATION_SCHEMA Connection-Control Tables Table Name Description Introduced CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Current number of consecutive failed connection attempts per account 5.7.17 .
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 23.4, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs. Times in ...EVENT_SCHEMA The name of the schema (database) to which the event ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-firewall-table-reference.html
Table 24.10 INFORMATION_SCHEMA Firewall Tables Table Name Description MYSQL_FIREWALL_USERS Firewall in-memory data for account profiles MYSQL_FIREWALL_WHITELIST Firewall in-memory data for account profile allowlists .
https://dev.mysql.com/doc/refman/5.7/en/information-schema-thread-pool-table-reference.html
Table 24.7 INFORMATION_SCHEMA Thread Pool Tables Table Name Description TP_THREAD_GROUP_STATE Thread pool thread group states TP_THREAD_GROUP_STATS Thread pool thread group statistics TP_THREAD_STATE Thread pool thread information .