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/performance-schema-log-status-table.html
binary_log_position The current binary log position at the time the log_status table was accessed. gtid_executed The current value of the global server variable gtid_executed at the time the log_status table was accessed. relay_log_pos The current ... The log_status table provides information that enables an online backup tool to copy the required log files without locking those resources for the duration of the copy ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-rwlock-instances-table.html
An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access to some common resource following certain rules. The access is either shared (many threads can have a read lock at the same time), ...
https://dev.mysql.com/doc/refman/8.0/en/statement-caching.html
For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal structure and caches that structure to be used during execution. Conversion and caching occurs for these ...Caching ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-errors-or-warnings.html
last_seen The time at which the statement was most recently seen. These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The ...
https://dev.mysql.com/doc/refman/8.0/en/concurrent-inserts.html
Use of the CONCURRENT option affects the performance of LOAD DATA a bit, even if no other session is using the table at the same time. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
In this case, you may have to run OPTIMIZE TABLE or myisamchk -r from time to time to improve performance. Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-json.html
It is permitted to name log_sink_json multiple times in the log_error_services value. If log_sink_json is named multiple times in the log_error_services value, they all write to the console, which is likely not useful. This section describes how to ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache-increase.html
In this situation, consider increasing the group_replication_message_cache_size limit with reference to the expected volume of messages in the time period specified by the group_replication_member_expel_timeout system variable plus the 5-second ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html
If deadlock detection is disabled using the innodb_deadlock_detect variable, InnoDB relies on the innodb_lock_wait_timeout setting to roll back transactions in case of a deadlock. If frequent deadlocks highlight a problem with transaction structure ... A deadlock is a situation in which multiple transactions are unable to proceed because each transaction holds a lock that is needed by another ...
https://dev.mysql.com/doc/refman/8.0/en/midpoint-insertion.html
If the block stays at the beginning of the sublist for a long enough time, it is demoted to the warm sublist. This time is determined by the value of the key_cache_age_threshold component of the key cache. By default, the key cache management ...