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-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 ...
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-benchmarking.html
If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB defined on the command line or with ...Since changing ...Alternatively, to run test queries and other statements without disturbing the original table, make a copy: CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-restrictions-limitations.html
mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB; ERROR 1166 (42000): Incorrect column name 'db_row_id' SHOW TABLE STATUS does not provide accurate statistics for InnoDB tables except for the physical size reserved by the table. A MySQL ... This section describes restrictions and limitations of the InnoDB storage ...For ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html
For example, if innodb_page_size=16K and the file system block size is 4K, page data must compress to less than or equal to 12K to make hole punching possible. Therefore, page compression only works if page data can be compressed to a size that is ...For example, for page compression to work on Windows, you could build the file system with a cluster size of 512 Bytes (which has a compression unit of 8KB) and initialize InnoDB with an innodb_page_size value of 16K or ...
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/innodb-information-schema-temp-table-info.html
Create a simple InnoDB temporary table: mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; Query INNODB_TEMP_TABLE_INFO to view the temporary table metadata. mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO\G An empty ... INNODB_TEMP_TABLE_INFO provides information about user-created InnoDB temporary tables that are active in the InnoDB ...row ...
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 ...