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/innodb-check-availability.html
Issue the SHOW ENGINES statement to view the available MySQL storage engines.
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility.html
The easiest way to determine the file format of an existing InnoDB tablespace is to examine the properties of the table it contains, using the SHOW TABLE STATUS command or querying the table INFORMATION_SCHEMA.TABLES. (In MySQL, a “database” is ... 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/innodb-file-per-table-tablespaces.html
File-Per-Table Tablespace Data Files A file-per-table tablespace is created in an .ibd data file in a schema directory under the MySQL data directory. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
table_map_delimiter: The character separating the schema name and the table name when you use the @@ notation in a key name to access a key in a specific table. db_schema The name of the database where the InnoDB table resides. containers Table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this section. Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html
If the problem is with table creation, tablespaces, or data dictionary operations, refer to the InnoDB Information Schema system tables to examine contents of the InnoDB internal data dictionary. The following general guidelines apply to ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-metadata.html
To see whether a keyring plugin is loaded, check the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-plugin-installation.html
Verify plugin installation by examining the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM ... Keyring ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
The password value cannot be displayed at runtime with SHOW VARIABLES or the Performance Schema global_variables table because the display value is obfuscated. These variables are unavailable unless the appropriate keyring plugin is installed (see ...
https://dev.mysql.com/doc/refman/5.7/en/kill.html
Thread processlist identifiers can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW PROCESSLIST output, and the PROCESSLIST_ID column of the Performance Schema threads table. KILL [CONNECTION | ...