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/replica-logs-status.html
When you back up the replica's data or transfer a snapshot of its data to create a new replica, ensure that you include the mysql.slave_master_info and mysql.slave_relay_log_info tables containing the replication metadata repositories, or the ...By ... A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-list.html
In MySQL 5.7, all rows relating to employees working at stores in that region can be deleted with the query ALTER TABLE employees TRUNCATE PARTITION pWest, which can be executed much more efficiently than the equivalent DELETE statement DELETE FROM ...For more detailed syntactical information, see Section 13.1.18, “CREATE TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility.html
(In many cases, the ALTER TABLE statement recreates a table and thus changes its properties. These checks take place when the server is started, and when you first access a table. In general, a newer version of InnoDB may create a table or index ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used in creating a partitioned table. Using the SHOW TABLE STATUS statement to determine whether a table is ... This ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA The name of the schema (database) to which the table containing the column belongs. Unlike SHOW COLUMNS, SELECT ...ORDINAL_POSITION is necessary because you might want to say ORDER BY ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-locks-table.html
The INNODB_LOCKS table provides information about each lock that an InnoDB transaction has requested but not yet acquired, and each lock that a transaction holds that is blocking another transaction. Note This table is deprecated as of MySQL 5.7.14 ...Although LOCK_ID currently contains TRX_ID, the format of the data in LOCK_ID is subject to change at any ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-columns-table.html
The INNODB_SYS_COLUMNS table provides metadata about InnoDB table columns, equivalent to the information from the SYS_COLUMNS table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB ...When a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-datafiles-table.html
The INNODB_SYS_DATAFILES table provides data file path information for InnoDB file-per-table and general tablespaces, equivalent to the information in the SYS_DATAFILES table in the InnoDB data dictionary. For related usage information and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-long-table.html
The events_stages_history_long table contains the N most recent stage events that have ended globally, across all threads. Stage events are not added to the table until they have ended. When the table becomes full, the oldest row is discarded when ...The Performance Schema autosizes the value of N during server ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-long-table.html
The events_statements_history_long table contains the N most recent statement events that have ended globally, across all threads. Statement events are not added to the table until they have ended. When the table becomes full, the oldest row is ...