PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-temp-table-info-table.html
The INNODB_TEMP_TABLE_INFO table provides information about user-created InnoDB temporary tables that are active in an InnoDB instance. The INNODB_TEMP_TABLE_INFO table is created when first queried, exists only in memory, and is not persisted to ...It does not provide information about internal InnoDB temporary tables used by the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility.html
In general, a newer version of InnoDB may create a table or index that cannot safely be read or written with an older version of InnoDB without risk of crashes, hangs, wrong results or corruptions. This mechanism lets you take advantage of some new ... InnoDB incorporates several checks to guard against the possible crashes and data corruptions that might occur if you run an old release of the MySQL server on InnoDB data files that use a newer file ...
https://dev.mysql.com/doc/refman/5.7/en/replication-channels.html
This channel is always present; it cannot be created or destroyed by the user. The maximum number of channels that can be created on one replica in a multi-source replication topology is 256. To provide compatibility with previous versions, the ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... index_hint: { USE {INDEX|KEY} ...
https://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. A group of MySQL servers can be configured ...Backups are also essential as a safeguard before upgrading a MySQL installation, and they can be used to transfer a MySQL installation to another system or to set up replica ...
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. An event can be dropped by any user having the EVENT privilege for the database on which the event is defined. The ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
If so, create an appropriate index and check the query with EXPLAIN again. Plan isn't ready yet (JSON property: none) This value occurs with EXPLAIN FOR CONNECTION when the optimizer has not finished creating the execution plan for the statement ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
Names of databases and user tables are in the same case as they were originally defined, possibly influenced by the lower_case_table_names setting. The number reported includes three hidden columns that are created by InnoDB (DB_ROW_ID, DB_TRX_ID, ... The INNODB_SYS_TABLES table provides metadata about InnoDB tables, equivalent to the information from the SYS_TABLES table in the InnoDB data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. For the nonunique indexes, the primary key columns (a,b) are counted in addition to the user defined columns. ANALYZE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. It is important to create good ...