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/create-tablespace.html
In standard MySQL 5.7 releases, this is always an InnoDB tablespace. MySQL NDB Cluster 7.5 also supports tablespaces using the NDB storage engine in addition to those using InnoDB. Considerations for InnoDB Considerations for NDB Cluster Options ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
For additional information specific to InnoDB, see InnoDB Notes, later in this section; for additional information specific to NDB Cluster, see NDB Notes. The FILES table has these columns: FILE_ID For InnoDB: The tablespace ID, also referred to as ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated CHARACTER_SETS Available character ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
Options specific to particular storage engines: See Section 14.15, “InnoDB Startup Options and System Variables” and Section 15.2.1, “MyISAM Startup Options”. InnoDB tablespace encryption relies on the MySQL Keyring for encryption key ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
For example, InnoDB has a limit of 1017 columns per table. The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
innodb_adaptive_hash_index_parts: Partitions adaptive hash index search system into n partitions, with each partition protected by separate latch. innodb_background_drop_list_empty: Delays table creation until background drop list is empty (debug).
https://dev.mysql.com/doc/refman/5.7/en/backup-strategy-example.html
Assume that data is stored in the InnoDB storage engine, which has support for transactions and automatic crash recovery. The InnoDB data files might not contain consistent data due to the crash, but InnoDB reads its logs and finds in them the list ...You should include such options as necessary to enable client programs to connect to the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
If the CONSTRAINT symbol clause is not defined, or a symbol is not included following the CONSTRAINT keyword: For InnoDB tables, a constraint name is generated automatically. InnoDB permits a foreign key to reference any index column or group of ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
Before running CHECK TABLE on InnoDB tables, see CHECK TABLE Usage Notes for InnoDB Tables. CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
Section 14.15, “InnoDB Startup Options and System Variables”, lists InnoDB system variables. default_storage_engine Command-Line Format --default-storage-engine=name System Variable default_storage_engine Scope Global, Session Dynamic Yes Type ... The MySQL server maintains many system variables that affect its ...