PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/resource-groups.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. Group attributes enable control over ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, whether to enable log file compression and encryption, and space management. For ...
https://dev.mysql.com/doc/refman/8.0/en/events-metadata.html
To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA database. Event Scheduler Time Representation Each session in MySQL has a session time zone (STZ). This is the session time_zone value that is initialized from the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT columns. To use the AUTO_INCREMENT mechanism with an InnoDB table, an ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. The OBJECT_TYPE column indicates the type of object to which a row applies. TABLE filtering affects table I/O events ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. The slow query log can be used to find queries that take a long time to execute ...
https://dev.mysql.com/doc/refman/8.0/en/sys-io-global-by-wait-by-latency.html
These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. The io_global_by_wait_by_latency and x$io_global_by_wait_by_latency views have these columns: event_name The I/O event name, with the ...