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-deadlock-detection.html
InnoDB tries to pick small transactions to roll back, where the size of a transaction is determined by the number of rows inserted, updated, or deleted. InnoDB is aware of table locks if innodb_table_locks = 1 (the default) and autocommit = 0, and ... When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls back a transaction or transactions to break the ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html
Without ORDER BY, all rows are peers and have value N/N = 1, where N is the partition size. This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. PERCENT_RANK() ...Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
However, if logging occurs at the statement level, there are certain binary logging issues with respect to stored programs (stored procedures and functions, triggers, and events): In some cases, a statement might affect different sets of rows on ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html
If innodb_redo_log_capacity is not defined, and if neither innodb_log_file_size or innodb_log_files_in_group are defined, then the default innodb_redo_log_capacity value is used. If innodb_redo_log_capacity is not defined, and if ... The redo log is ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-configuring.html
The component's system variable enterprise_encryption.maximum_rsa_key_size specifies the maximum key size, and it defaults to 4096 bits. If the maximum values are too high, you can specify a lower maximum key length using the following system ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance.html
Group Replication also has built-in mechanisms and settings to help the group adapt to and manage variations in workload and message size, and stay within the limitations of the underlying system and networking resources. If you find that group ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-spin_lock_polling.html
However, too-frequent polling of a shared object such as a mutex or rw-lock by multiple threads can cause “cache ping pong”, which results in processors invalidating portions of each other's cache. InnoDB mutexes and rw-locks are typically ...
https://dev.mysql.com/doc/refman/8.0/en/log-file-maintenance.html
However, you must clean up these files regularly to ensure that the logs do not take up too much disk space. In addition, the server flushes the binary log automatically when current binary log file size reaches the value of the max_binlog_size ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-startup-configuration.html
The other variables indicate table sizes (number of rows) or memory allocation values. Note With the Performance Schema enabled, the number of Performance Schema instances affects the server memory footprint, perhaps to a large extent. For example, ... To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log-buffer.html
Thus, if you have transactions that update, insert, or delete many rows, increasing the size of the log buffer saves disk I/O. A large log buffer enables large transactions to run without the need to write redo log data to disk before the ... The ...