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-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.
https://dev.mysql.com/doc/refman/9.7/en/innodb-recovery.html
The innodb_directories default setting is NULL, but the directories defined by innodb_data_home_dir, innodb_undo_directory, and datadir are always appended to the innodb_directories argument value when InnoDB builds a list of directories to scan at ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-temporary-tablespace.html
row *************************** FILE_NAME: ./ibtmp1 TABLESPACE_NAME: innodb_temporary ENGINE: InnoDB INITIAL_SIZE: 12582912 TotalSizeBytes: 12582912 DATA_FREE: 6291456 MAXIMUM_SIZE: NULL TotalSizeBytes shows the current size of the global temporary ... InnoDB uses session temporary tablespaces and a global temporary ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-transaction-scheduling.html
A transaction that is not waiting for a lock reports a NULL TRX_SCHEDULE_WEIGHT value. InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are waiting for locks. When multiple transactions are ...
https://dev.mysql.com/doc/refman/9.7/en/internal-temporary-tables.html
In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Evaluation of some ...
https://dev.mysql.com/doc/refman/9.7/en/jdv-examples.html
To demonstrate the different DML operations you can execute on JSON duality views, create the customers and orders relational tables. CREATE TABLE customers ( customer_id INT PRIMARY KEY, name VARCHAR(100) ); CREATE TABLE orders ( order_id INT ...
https://dev.mysql.com/doc/refman/9.7/en/kill.html
KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate thread. Thread processlist identifiers can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW PROCESSLIST output, ...
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. This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and debugging instructions in Section ...
https://dev.mysql.com/doc/refman/9.7/en/literals.html
These include strings, numbers, hexadecimal and bit values, boolean values, and NULL. This section describes how to write literal values in MySQL. The section also covers various nuances that you may encounter when dealing with these basic types in ...