PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-pool-stats-table.html
PAGES_CREATE_RATE The number of pages created per second (pages created since the last printout / time elapsed). The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html
Most indexes created implicitly by InnoDB have consistent names but the index names are not necessarily unique. For GEN_CLUST_INDEX indexes, this value is 0 because the index is created using an artificial value rather than a real table column. Any ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-session-temp-tablespaces-table.html
The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. Session temporary tablespaces are recreated each time the server is started. SLAVE indicates that ...The INNODB_SESSION_TEMP_TABLESPACES table has these columns: ID The process or session ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tables-table.html
The number reported includes three hidden columns that are created by InnoDB (DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR). Tables assigned to the system tablespace using CREATE TABLE or ALTER TABLE TABLESPACE=innodb_system have a SPACE_TYPE of General.
https://dev.mysql.com/doc/refman/8.0/en/innodb-analyze-table-complexity.html
To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-example.html
Client A enables innodb_print_all_deadlocks, creates two tables, 'Animals' and 'Birds', and inserts data into each. The following example illustrates how an error can occur when a lock request causes a deadlock. Thererfore, the previous read-only ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locks-set.html
It is important to create good indexes so that your queries do not scan more rows than necessary. A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL statement. It does ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
Creating a New Table and Column Mapping This example shows how to setup your own InnoDB table with the daemon_memcached plugin. mysql> CREATE TABLE city ( city_id VARCHAR(32), name VARCHAR(1024), state VARCHAR(1024), country VARCHAR(1024), flags ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html
Add the directories of file-per-table and general tablespaces created with an absolute path or in a location outside of the data directory to the innodb_directories setting. The innodb_directories variable, which defines directories to scan at ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY TABLE. Secondary indexes are not created as efficiently because keys are inserted in the order they appeared in the primary key. The ...