PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ... lock_type: { READ [LOCAL] | [LOW_PRIORITY] WRITE } UNLOCK {TABLE | TABLES} MySQL enables client sessions to acquire table locks explicitly for the purpose ...One session cannot acquire locks for another session or release locks held by another ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
The TABLES table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema (database) to which the table belongs. TABLE_TYPE BASE TABLE for a table, VIEW for a view, or SYSTEM VIEW for ...See Chapter 14, The InnoDB Storage Engine, and Chapter 15, Alternative Storage ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
(Some valid select or union statement) CREATE TABLE creates a table with the given name. By default, tables are created in the default database, using the InnoDB storage engine. An error occurs if the table exists, if there is no default database, ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-wait-summary-tables.html
The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per table table_lock_waits_summary_by_table: Table lock ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
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} ...| ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
If related data is being updated across multiple tables, queries see either all old values or all new values, not a mix of old and new values. adaptive flushing An algorithm for InnoDB tables that smooths out the I/O overhead introduced by ... These ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different phases of ALTER TABLE. Each stage event reports a running total of WORK_COMPLETED and WORK_ESTIMATED for the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table tablespaces. There are many reasons why you ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-handles-table.html
The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This information shows which table handles the server has open, how they are locked, and ...The value is one of READ, READ WITH SHARED LOCKS, READ HIGH PRIORITY, READ NO INSERT, WRITE ALLOW WRITE, WRITE CONCURRENT INSERT, WRITE LOW PRIORITY, or ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
The INNODB_SYS_TABLES table provides metadata about InnoDB tables, equivalent to the information from the SYS_TABLES table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB INFORMATION_SCHEMA ...The number reported includes three hidden columns that are created by InnoDB (DB_ROW_ID, DB_TRX_ID, and ...