PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
The TRIGGERS table has these columns: TRIGGER_CATALOG The name of the catalog to which the trigger belongs. These columns indicate the catalog and schema (database) in which this table occurs, and the table name, respectively. To see information ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
When you design a database with appropriate primary key columns for each table, operations involving those columns are automatically optimized. It is very fast to reference the primary key columns in WHERE clauses, ORDER BY clauses, GROUP BY ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
Change buffering is not supported for a secondary index if the index contains a descending index column or if the primary key includes a descending index column. Configuring Change Buffering When INSERT, UPDATE, and DELETE operations are performed ... The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-metrics-table.html
The INNODB_METRICS table provides information about InnoDB performance and resource-related counters. SET GLOBAL innodb_monitor_disable = [counter-name|module_name|pattern|all]; innodb_monitor_reset: Resets counter values to zero. SET GLOBAL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html
The NAME column displays the system-generated name for the temporary table, which is prefixed with “#sql”. The number of columns (N_COLS) is 4 rather than 1 because InnoDB always creates three hidden table columns (DB_ROW_ID, DB_TRX_ID, and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
InnoDB sets an exclusive lock on the end of the index associated with the AUTO_INCREMENT column while initializing a previously specified AUTO_INCREMENT column on a table. InnoDB fetches the value of a previously initialized AUTO_INCREMENT column ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-developing.html
The data stored through the daemon_memcached plugin goes into VARCHAR, TEXT, or BLOB columns, and must be converted to do numeric operations. Coming from a database background, you might be used to general-purpose SQL tables with many columns. The ... Typically, writing an application for the InnoDB memcached plugin involves some degree of rewriting or adapting existing code that uses MySQL or the memcached ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-intro.html
You can map multiple columns into the “value” part of the key-value store, with column values delimited by a user-specified separator character. The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB ...
https://dev.mysql.com/doc/refman/5.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/5.7/en/innodb-restrictions-limitations.html
You cannot create a table with a column name that matches the name of an internal InnoDB column (including DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR. mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB; ERROR 1166 (42000): Incorrect column name ... This section describes restrictions and limitations of the InnoDB storage ...