PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
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-online-ddl-failure-conditions.html
For example, you might insert duplicate values into a column while a unique index is being created, or you might insert NULL values into a column while creating a primary key index on that column. The failure of an online DDL operation is typically ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-limitations.html
The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY TABLE. Before ...
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, ...