PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
With statement-based binary logging, having different modes for the source and replicas might lead to replication errors. Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
Modifying AUTO_INCREMENT column values in the middle of a sequence of INSERT statements In MySQL 5.7 and earlier, modifying an AUTO_INCREMENT column value in the middle of a sequence of INSERT statements could lead to “Duplicate entry” errors.
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-example.html
If client A attempts to update a row in Birds at the same time, this will lead to a deadlock: mysql> UPDATE Birds SET value=40 WHERE name='Buzzard'; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction InnoDB rolls ... The following example illustrates how an error can occur when a lock request causes a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-disabling-tablespace-path-validation.html
Manually moved tablespace files will not be detected! Warning Starting the server with tablespace path validation disabled after moving tablespace files can lead to undefined behavior. At startup, InnoDB scans directories defined by the ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/en/innodb-memcached-porting-mysql.html
Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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 ...