PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
The TIMER_START and TIMER_END values indicate when event timing started and ended. If an event has not finished, TIMER_END is the current timer value and TIMER_WAIT is the time elapsed so far (TIMER_END − TIMER_START). If an event is produced from ...The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-thread_concurrency.html
In situations where it is helpful to minimize context switching between threads, InnoDB can use a number of techniques to limit the number of concurrently executing operating system threads (and thus the number of requests that are processed at any ... InnoDB uses operating system threads to process requests from user ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-summary-tables.html
Example error event summary information: mysql> SELECT * FROM performance_schema.events_errors_summary_global_by_error WHERE SUM_ERROR_RAISED <> 0\G *************************** 1. Each error summary table has these summary columns containing ... The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-timeout.html
The global value of the system variable replica_transaction_retries (from MySQL 8.0.26) or slave_transaction_retries (before MySQL 8.0.26) sets the maximum number of times for applier threads on a single-threaded or multithreaded replica to ...If a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-auto-positioning.html
To start a replica using GTID-based replication, you need to enable the SOURCE_AUTO_POSITION | MASTER_AUTO_POSITION option in the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23). This ...
https://dev.mysql.com/doc/refman/8.0/en/events-metadata.html
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 server's global time_zone value when the session begins but may be changed during the session.
https://dev.mysql.com/doc/refman/8.0/en/data-types.html
MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. fsp applies to the TIME, DATETIME, and TIMESTAMP types and represents fractional ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
MySQL Group Replication provides distributed state machine replication with strong coordination between servers. The group can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. There ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-error-handling.html
InnoDB sometimes rolls back only the statement that failed, other times it rolls back the entire transaction. If you run out of file space in a tablespace, a MySQL Table is full error occurs and InnoDB rolls back the SQL statement. A lock wait ...A ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-space-requirements.html
If the operation takes a long time and concurrent DML modifies the table so much that the size of the temporary log file exceeds the value of innodb_online_alter_log_max_size, the online DDL operation fails with a DB_ONLINE_LOG_TOO_BIG error, and ...