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-standard-monitor.html
You can calculate from these numbers how many data file I/O operations your queries currently are doing. Standard Monitor output is limited to 1MB when produced using the SHOW ENGINE INNODB STATUS statement. The number of seconds is the elapsed time ... The Lock Monitor is the same as the Standard Monitor except that it includes additional lock ...SEMAPHORES This section reports threads waiting for a semaphore and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-best-practices.html
Enable the innodb_file_per_table variable or use general tablespaces to put the data and indexes for tables into separate files instead of the system tablespace. Evaluate whether your data and access patterns benefit from the InnoDB table or page ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting.html
The following general guidelines apply to troubleshooting InnoDB problems: When an operation fails or you suspect a bug, look at the MySQL server error log (see Section 7.4.2, “The Error Log”). Server Error Message Reference provides ...Enable ...When troubleshooting, it is usually best to run the MySQL server from the command prompt, rather than through mysqld_safe or as a Windows ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-fulltext_index-tables.html
Before querying any of them, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). Example 17.5 InnoDB FULLTEXT Index ...For ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-engines.html
The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-ro-txn.html
In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) causes an error, and the transaction continues in read-only state: ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction. Note ... InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be ...You can still make changes to session-specific temporary tables ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
--log-bin -–innodb_api_enable_binlog=1 Configure the source and replica server, as described in Section 19.1.2, “Setting Up Binary Log File Position Based Replication”. 2013-09-24T13:04:38.639684Z 49 [Note] Replication I/O thread: connected to ...It is assumed that you have completed the setup described in Section 17.20.3, “Setting Up the InnoDB memcached ... Because the daemon_memcached plugin supports the MySQL binary log, source server ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-innodb-change-buffer.html
The innodb_io_capacity parameter sets an upper limit on the I/O activity performed by InnoDB background tasks such as merging data from the change buffer. When should the change buffer not be used? You might consider disabling the change buffer if ...How much space does InnoDB use for the change buffer? ...How do ...What types of ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. The tables that contain ...As ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-physical-structure.html
With the exception of spatial indexes, InnoDB indexes are B-tree data structures. Index records are stored in the leaf pages of their B-tree or R-tree data structure. The page size is determined by the innodb_page_size setting when the MySQL ...