PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-file-per-table-tablespaces.html
With file-per-table tablespaces, each table may have unused space that can only be utilized by rows of the same table, which can lead to wasted space if not properly managed. A file-per-table tablespace contains data and indexes for a single InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-index-types.html
How the Clustered Index Speeds Up Queries Accessing a row through the clustered index is fast because the index search leads directly to the page that contains the row data. Each InnoDB table has a special index called the clustered index that ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-performance.html
Reduced locking and waiting for MySQL server resources leads to greater scalability, even for operations that are not involved in the DDL operation. Online DDL improves several aspects of MySQL operation: Applications that access the table are more ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-page-compression.html
For example, a maximum InnoDB page size of 64KB with a 4KB file system block size may improve compression but may also increase demand on the buffer pool, leading to increased I/O and potential write amplification. InnoDB supports page-level ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-optimizer-statistics.html
As a result, different estimates could be produced when recomputing statistics, leading to different choices in execution plans and variations in query performance. This section describes how to configure persistent and non-persistent optimizer ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-statistics-estimation.html
The default number of sampled pages is 8, which could be insufficient to produce an accurate estimate, leading to poor index choices by the query optimizer. Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-transaction-scheduling.html
A single attempt may lead to zero or more record locks being released, as there may be zero or more record locks in a single structure. InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-undo-tablespaces.html
An undo tablespace not found before recovery cannot be used, which can lead to database inconsistencies. Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a ...
https://dev.mysql.com/doc/refman/9.7/en/insert-select.html
This means that, when using replication, there is no guarantee that such a SELECT returns rows in the same order on the source and the replica, which can lead to inconsistencies between them. INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] ...
https://dev.mysql.com/doc/refman/9.7/en/insert.html
If the string value has no leading numeric part, the column is set to 0. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} ...