Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-columns-table.html
POS The ordinal position of the column within the table, starting from 0 and incrementing sequentially. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-fields-table.html
POS The ordinal position of the key field within the index, starting from 0 and incrementing sequentially. The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. For related usage information and examples, see ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tables-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_TABLES table has these columns: TABLE_ID An identifier for the InnoDB table. NAME The name of the table, preceded by ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
A number of counter values have now incremented including COUNT, MAX_COUNT, AVG_COUNT, and COUNT_RESET. The INNODB_METRICS table provides information about InnoDB performance and resource-related counters. SET GLOBAL innodb_monitor_disable = ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
The AUTOINC value is the next number to be issued for any autoincrement-based operation. There are no autoincrement columns defined on table t1, so the value is 0. row *************************** TABLE_ID: 71 NAME: test/t1 STATS_INITIALIZED: ... You ...
https://dev.mysql.com/doc/refman/8.4/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. The ...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.4/en/known-issues.html
SELECT statements that insert zero or NULL values into an AUTO_INCREMENT column. SELECT with no ORDER BY, the SELECT may return rows in a different order (which results in a row having different ranks, hence getting a different number in the ...For ... This section lists known issues in recent versions of ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
By contrast, nonrestrictive data interpretation uses these rules: If an input line has too many fields, the extra fields are ignored and the number of warnings is incremented. The file can be read from the server host or the client host, depending ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
Subsequent locks for the name increment a counter in the lock but do not acquire additional metadata locks. While held by one session, other sessions cannot obtain a lock of the same name. Returns 1 if the lock was obtained successfully, 0 if the ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
If an internal in-memory temporary table becomes too large (as determined by tmp_table_size and max_heap_table_size), MySQL automatically converts the table from in-memory to on-disk format, which uses the InnoDB storage engine. The Performance ...