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/myisam-table-formats.html
When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT columns, you can force the table format to FIXED or DYNAMIC with the ROW_FORMAT table option. The third, compressed format, can be created only with the myisampack utility ...Two of them, fixed and dynamic format, are chosen automatically depending on the type of columns you are ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
(Selecting from the view selects, in effect, using the SELECT statement.) The select_statement can select from base tables or from other views. The view definition is “frozen” at creation time and is not affected by subsequent changes to the ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
When modifying an existing table that is not partitioned to accommodate partitioning, or, when modifying the partitioning of an already partitioned table, you may consider altering the table's primary key (see Section 22.6.1, “Partitioning Keys, ...REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-lock-waits-table.html
The INNODB_LOCK_WAITS table contains one or more rows for each blocked InnoDB transaction, indicating the lock it has requested and any locks that are blocking that request. Note This table is deprecated as of MySQL 5.7.14 and is removed in MySQL ...REQUESTED_LOCK_ID The ID of the lock for which a transaction is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-cols-table.html
The INNODB_SYS_FOREIGN_COLS table provides status information about the columns of InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN_COLS table in the InnoDB data dictionary. For related usage information and examples, see ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-table.html
The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB ...TYPE A ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-status-table.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. Note Information available from the tables described here is also available from the Performance Schema. The ...For ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG The name of the catalog to which the trigger belongs. This is the type of operation on the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-variables-table.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. Note Information available from the tables described here is also available from the Performance Schema. The ...For ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-mutex-instances-table.html
The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. The mutex_instances table has these columns: NAME The instrument name associated with the mutex. The setup_instruments table lists the name of ...A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common ...