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/performance-schema-atom-molecule-events.html
For a table I/O event, there are usually two rows in events_waits_current, not one. For example, a row fetch might result in rows like this: Row# EVENT_NAME TIMER_START TIMER_END ---- ---------- ----------- --------- 1 wait/io/file/myisam/dfile ...
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/performance-schema-setup-tables.html
The setup tables provide information about the current instrumentation and enable the monitoring configuration to be changed. The use of tables rather than individual variables for setup information provides a high degree of flexibility in ...For ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-timers-table.html
To avoid unpredictable results after you make timer changes, use TRUNCATE TABLE to reset Performance Schema statistics. The setup_timers table has these columns: NAME The type of instrument the timer is used for. The setup_timers.TIMER_NAME value ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features.html
The following sections provide information about what is supported and what is not in MySQL replication, and about specific issues and situations that may occur when replicating certain statements. If you are planning to use statement-based ...
https://dev.mysql.com/doc/refman/5.7/en/show-errors.html
SHOW ERRORS [LIMIT [offset,] row_count] SHOW COUNT(*) ERRORS SHOW ERRORS is a diagnostic statement that is similar to SHOW WARNINGS, except that it displays information only for errors, rather than for errors, warnings, and notes. The LIMIT clause ...You can also retrieve this number from the error_count variable: SHOW COUNT(*) ERRORS; SELECT @@error_count; SHOW ERRORS and error_count apply only to errors, not warnings or ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-file-io-type.html
Rows for which the HOST 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. total The total number of occurrences of the file I/O event for the host.
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-stages.html
Rows for which the HOST 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. total The total number of occurrences of the stage event for the host. By ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-lock-waits.html
These views summarize the InnoDB locks that transactions are waiting for. wait_age How long the lock has been waited for, as a TIME value. wait_age_secs How long the lock has been waited for, in seconds. For more information, see Identifying a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). Tables in these schemas are excluded ...