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/innodb-online-ddl-performance.html
Session 1: mysql> CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; mysql> START TRANSACTION; mysql> SELECT * FROM t1; The session 1 SELECT statement takes a shared metadata lock on table t1. Session 2: mysql> ALTER TABLE t1 ADD COLUMN x INT, ...An exclusive ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html
This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. CLUST_INDEX_SIZE The number of pages on disk that store the clustered index, which holds the InnoDB table data in primary key order. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-pool-stats-table.html
DATABASE_PAGES The number of pages in the InnoDB buffer pool containing data. The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much of the same information may also ...Pages made “young” take longer to age out of the buffer pool, while pages made “not young” are moved much closer to the point of ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-purge-configuration.html
Consequently, the InnoDB multi-version concurrency control (MVCC) system must keep a copy of the data in the undo log until all transactions that depend on that data have completed. InnoDB does not physically remove a row from the database ...A row ...This removal operation, which only occurs after the row is no longer required for multi-version concurrency control (MVCC) or rollback, is called a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-midpoint_insertion.html
Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never accessed again. Both innodb_old_blocks_pct and innodb_old_blocks_time can be specified in the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-config-table.html
The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table ...The values for this column might change, depending on the needs for performance tuning and debugging for InnoDB full-text ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-metrics-table.html
The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for InnoDB. Each monitor represents a point within the InnoDB source code that is ...With ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-detection.html
The same error may also occur if the locking thread must look at more than 1,000,000 locks owned by transactions on the wait-for list. When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-tablespace-autoextend-size.html
By default, when a file-per-table or general tablespace requires additional space, the tablespace is extended incrementally according to the following rules: If the tablespace is less than an extent in size, it is extended one page at a time. From ...If the tablespace is greater than 1 extent but smaller than 32 extents in size, it is extended one extent at a ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
This is because MySQL relies on the operating system to perform file system caching for data reads, so you must leave some room for the file system cache. Unless otherwise specified, the default file location is the data directory if the value is a ...Most system variables can be set at server startup using options on the command line or in an option ...