Search Results
https://dev.mysql.com/doc/refman/8.4/en/error-log-components.html
Provides a parser for reading error log files created by previous server instances. Provides a parser for reading error log files created by previous server instances. Does not provide a parser for reading error log files created by previous server ... This section describes the characteristics of individual error log ...
https://dev.mysql.com/doc/refman/8.4/en/example-storage-engine.html
The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from ...
https://dev.mysql.com/doc/refman/8.4/en/fractional-seconds.html
For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6)); The fsp value, if given, must be in the range 0 to 6. MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
The minimum and maximum word length full-text parameters apply to FULLTEXT indexes created using the built-in FULLTEXT parser and MeCab parser plugin. Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/en/innodb-locking.html
For such cases, InnoDB creates a hidden clustered index and uses this index for record locking. Client A creates a table containing two index records (90 and 102) and then starts a transaction that places an exclusive lock on index records with an ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
To move databases in a binary format from Unix to Windows or from Windows to Unix, create all databases and tables using lowercase names. In addition, MySQL Enterprise Backup can create compressed backup files, and back up subsets of tables. This ...
https://dev.mysql.com/doc/refman/8.4/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 ...