PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-space-requirements.html
If the operation takes a long time and concurrent DML modifies the table so much that the size of the temporary log file exceeds the value of innodb_online_alter_log_max_size, the online DDL operation fails with a DB_ONLINE_LOG_TOO_BIG error, and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html
Session 1: mysql> CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; mysql> START TRANSACTION; mysql> SELECT * FROM t1; The session 1 SELECT statement takes a shared metadata lock on table t1. Session 2: mysql> ALTER TABLE t1 ADD COLUMN x INT, ...An exclusive ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool.html
The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. The larger the buffer pool, the more InnoDB acts like an in-memory database, reading data from disk once and then accessing the data from memory ...The buffer pool permits frequently used data to be accessed directly from memory, which speeds up ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-usage.html
Creating a Compressed Table in File-Per-Table Tablespace To create a compressed table in a file-per-table tablespace, innodb_file_per_table must be enabled (the default). The FILE_BLOCK_SIZE value must be a valid compressed page size in relation to ...The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-table.html
The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo tablespaces. Note The INFORMATION_SCHEMA FILES table reports metadata for InnoDB tablespace types including file-per-table tablespaces, general ...The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-preload-buffer-pool.html
By default, tablespace ID and page ID data is saved in a file named ib_buffer_pool, which is saved to the InnoDB data directory. Even though a buffer pool can be many gigabytes in size, the buffer pool data that InnoDB saves to disk is tiny by ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
It specifies the directory in which files named in LOAD DATA LOCAL statements must be located. When --load-data-local-dir applies, the option value designates the directory in which local data files must be located. If the file does not exist or is ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-change-buffer.html
The type of data cached in the change buffer is governed by the innodb_change_buffering variable. You can set the innodb_change_buffering variable in the MySQL option file (my.cnf or my.ini) or change it dynamically with the SET GLOBAL statement, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
In addition, if --ndb-nodeid is used, then either a matching node ID must be found in a [mysqld] or [api] section of config.ini, or there must be an “open” [mysqld] or [api] section in the file (that is, a section without a NodeId or Id ...For ...For general information on using these, and for other options and variables not specific to NDB Cluster, see Section 7.1, “The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. FOR SHARE, or from reading the data in certain transaction isolation levels. These clauses are ...