Search Results
https://dev.mysql.com/doc/refman/9.7/en/diagnostics-area.html
How the Diagnostics Area is Cleared and Populated Nondiagnostic SQL statements populate the diagnostics area automatically, and its contents can be set explicitly with the SIGNAL and RESIGNAL statements. If the sql_notes system variable is set to 0, ... SQL statements produce diagnostic information that populates the diagnostics ...
https://dev.mysql.com/doc/refman/9.7/en/forcing-innodb-recovery.html
When forcing InnoDB recovery, you should always start with innodb_force_recovery=1 and only increase the value incrementally, as necessary. To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/hash-joins.html
Join buffers for hash joins are allocated incrementally; thus, you can set join_buffer_size higher without small queries allocating very large amounts of RAM, but outer joins allocate the entire buffer. It is possible to control whether hash joins ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...