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/optimizing-innodb-storage-layout.html
Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. OPTIMIZE TABLE copies the data part of ...The reorganized tables require less disk I/O to perform full table ...When using COMPACT row format and variable-length character sets, such as utf8mb4 or sjis, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-metrics-table.html
[mysqld] innodb_monitor_enable = log,metadata_table_handles_opened,metadata_table_handles_closed When enabling multiple counters or modules in a configuration file, specify the innodb_monitor_enable variable followed by counter and module names ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-transaction-management.html
InnoDB must flush the log to disk at each transaction commit if that transaction made modifications to the database. To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-logging.html
When InnoDB has written redo log files full, it must write the modified contents of the buffer pool to disk in a checkpoint. From MySQL 8.0.30, the redo log file size is determined by the innodb_redo_log_capacity setting. InnoDB tries to maintain 32 ... Consider the following guidelines for optimizing redo logging: Increase the size of your redo log ...Dedicated log writer threads can improve performance on high-concurrency ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-tuning.html
Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately or sometime later, raw performance is expected to be somewhat slower than using memcached by itself. get key_value Using System Memory For ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
Transaction data for an intention lock appears similar to the following in SHOW ENGINE INNODB STATUS and InnoDB monitor output: TABLE LOCK table `test`.`t` trx id 10080 lock mode IX Record Locks A record lock is a lock on an index record. Shared and ...A shared (S) lock permits the transaction that holds the lock to read a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
By default, the memcached protocol is used to read and write data directly to InnoDB, letting MySQL manage in-memory caching using the InnoDB buffer pool. Advanced users can configure the system as a traditional memcached server, with all data ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-disk-io.html
Before writing pages to a data file, InnoDB first writes them to a storage area called the doublewrite buffer. Only after the write and the flush to the doublewrite buffer has completed does InnoDB write the pages to their proper positions in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-example.html
If client A attempts to update a row in Birds at the same time, this will lead to a deadlock: mysql> UPDATE Birds SET value=40 WHERE name='Buzzard'; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction InnoDB rolls ... The following example illustrates how an error can occur when a lock request causes a ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-configuration-variables.html
Because the InnoDB storage engine performs many of its optimizations automatically, many performance-tuning tasks involve monitoring to ensure that the database is performing well, and changing configuration options when performance drops. The main ...Because the default is to buffer all types of data change operations, only change this setting if you need to reduce the amount of ... Different settings work best for servers ...