PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-fulltext_index-tables.html
This table contains metadata about the FULLTEXT index and related processing: optimize_checkpoint_limit: The number of seconds after which an OPTIMIZE TABLE run stops. INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-metrics-table.html
The TIME_ENABLED and TIME_ELAPSED values indicate when the counter was last enabled and how many seconds have elapsed since that time. The INNODB_METRICS table provides information about InnoDB performance and resource-related counters. SET GLOBAL ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-system-tables.html
The index TYPE value indicates the type of index (1 = Clustered Index, 0 = Secondary index). The CLUST_INDEX_SIZE and OTHER_INDEX_SIZE fields report the number of pages on disk that store clustered and secondary indexes for the table, respectively.
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-understanding-innodb-locking.html
If a second transaction wants to update a row or lock a table already locked by a prior transaction in an incompatible mode, InnoDB adds a lock request for the row to the corresponding queue. When a transaction updates a row in a table, or locks it ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-migration.html
Start a second mysqld server on the backup and let it clean up the .ibd files in the backup. This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-next-key-locking.html
For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, the row is a “phantom” row. The so-called phantom problem occurs within a transaction when the same query produces different ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-compression-oltp.html
The rise of SSD storage devices, which are fast but relatively small and expensive, makes compression attractive also for OLTP workloads: high-traffic, interactive websites can reduce their storage requirements and their I/O operations per second ...
https://dev.mysql.com/doc/refman/9.7/en/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. If column b is also unique, the INSERT is equivalent to this UPDATE statement ...
https://dev.mysql.com/doc/refman/9.7/en/invisible-columns.html
The second SELECT explicitly references col2, so the column appears in the result. An invisible column is normally hidden to queries, but can be accessed if explicitly referenced. As an illustration of when invisible columns may be useful, suppose ...
https://dev.mysql.com/doc/refman/9.7/en/jdv-concurrency.html
If another user updates the underlying data with another REST PUT request between the time of the previous REST GET and REST PUT requests, the second REST PUT request will overwrite the data, making it inconsistent. DML operations for JSON duality ...