PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-lock-waits.html
These views summarize the InnoDB locks that transactions are waiting for. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been waited for, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-dml.html
In the following SQL examples, t1 refers to the table used for memcached operations, based on the configuration in the innodb_memcache.containers table. Benchmarks suggest that the daemon_memcached plugin speeds up DML operations (inserts, updates, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-failure-conditions.html
The tmpdir or innodb_tmpdir file system runs out of disk space, while MySQL writes temporary sort files on disk during index creation. The operation takes a long time and concurrent DML modifies the table so much that the size of the temporary ...
https://dev.mysql.com/doc/refman/5.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/5.7/en/innodb-online-ddl-space-requirements.html
The temporary log file is extended as required by the value of innodb_sort_buffer_size up to a maximum specified by innodb_online_alter_log_max_size. If the operation takes a long time and concurrent DML modifies the table so much that the size of ... Online DDL operations have the following space requirements: Temporary log files: A temporary log file records concurrent DML when an online DDL operation creates an index or alters a ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
By default, tables are created in the default database, using the InnoDB storage engine. Only the InnoDB and MyISAM storage engines support indexing on BLOB and TEXT columns. In MySQL 5.7, only the InnoDB, MyISAM, and MEMORY storage engines support ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
These InnoDB enhancements were added: VARCHAR column size can be increased using an in-place ALTER TABLE, as in this example: ALTER TABLE t1 ALGORITHM=INPLACE, CHANGE COLUMN c1 c1 VARCHAR(255); This is true as long as the number of length bytes ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
Innodb_available_undo_logs Note The Innodb_available_undo_logs status variable is deprecated as of MySQL 5.7.19; expect it to be removed in a future release. Supplements the innodb_rollback_segments system variable, which defines the number of ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
For example: If t1 is currently not an InnoDB table, this statement changes its storage engine to InnoDB: ALTER TABLE t1 ENGINE = InnoDB; See Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB” for considerations when switching tables to ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-mysql-memory-use.html
Memory instruments have names in the form of memory/code_area/instrument_name, where code_area is a value such as sql or innodb, and instrument_name is the instrument detail. For example, you can limit results to InnoDB memory instruments by ... The ...