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/innodb-deadlocks-handling.html
In particular, do not leave an interactive mysql session open for a long time with an uncommitted transaction. With MySQL table-level locks, the timeout method must be used to resolve deadlocks. You can cope with deadlocks and reduce the likelihood ... This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
If there is an error in evaluation on the replica, particularly when executing complex statements, statement-based replication may slowly increase the margin of error across the affected rows over time. As of MySQL 8.0.22, DML operations that read ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE option. To examine the source for the ARCHIVE engine, look in the storage/archive directory of a MySQL source distribution. A bulk ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-new-primary.html
From MySQL 8.0.29, you can specify a timeout for transactions that are running when you use the function. For the timeout to work, all members of the group must be at MySQL 8.0.29 or higher. Before MySQL 8.0.29, the function waits for all active ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-lru-table.html
Querying this table can require MySQL to allocate a large block of contiguous memory, more than 64 bytes times the number of active pages in the buffer pool. ACCESS_TIME An abstract number used to judge the first access time of the page. Querying ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. To update cached values at any time for a given table, use ANALYZE TABLE. The higher the cardinality, the greater the chance that ...If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table statistics ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-in-core-file.html
Note Access to the data present in buffer pool pages at the time the mysqld process died may be beneficial in some debugging scenarios. Because the buffer pool resides in main memory, and the memory image of a running process is dumped to the core ... A core file records the status and memory image of a running ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-close.html
The counter works as follows: The first time a table is updated in MySQL, a counter in the header of the index files is incremented. (The table may still be okay because MySQL always issues writes for everything between each statement.) A table was ...Multiple mysqld servers are using the table and one server performed a REPAIR TABLE or CHECK TABLE on the table while it was in use by another ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table.html
EXTENDED If you use the EXTENDED option, MySQL creates the index row by row instead of creating one index at a time with sorting. See Section B.3.3.3, “What to Do If MySQL Keeps Crashing”, and Section 18.2.4, “MyISAM Table Problems”. This ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-syntax.html
In MySQL 8.0.22 and later, a user variable referenced by a statement in a stored procedure has its type determined the first time the procedure is invoked, and retains this type each time the procedure is invoked thereafter. MySQL supports a very ...