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/show-engine.html
The statement has these variants: SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX SHOW ENGINE PERFORMANCE_SCHEMA STATUS SHOW ENGINE INNODB STATUS displays extensive information from the standard InnoDB Monitor about the state of the InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. With support for both file formats, general tablespaces have no dependence on innodb_file_format or innodb_file_per_table settings, nor do these ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
InnoDB tables require a FULLTEXT index on all columns of the MATCH() expression to perform boolean queries. The stopword list applies, controlled by innodb_ft_enable_stopword, innodb_ft_server_stopword_table, and innodb_ft_user_stopword_table for ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
See Chapter 14, The InnoDB Storage Engine, and Chapter 15, Alternative Storage Engines. InnoDB table format is either Redundant or Compact when using the Antelope file format, or Compressed or Dynamic when using the Barracuda file format. For other ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
Configuration Changes System Table Changes Server Changes InnoDB Changes SQL Changes Configuration Changes Incompatible change: In MySQL 5.7.11, the default --early-plugin-load value is the name of the keyring_file plugin library file, causing that ... Before upgrading to MySQL 5.7, review the changes described in this section to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
See Chapter 14, The InnoDB Storage Engine, and Chapter 15, Alternative Storage Engines. InnoDB table format is either Redundant or Compact when using the Antelope file format, or Compressed or Dynamic when using the Barracuda file format. For other ...The TABLES table has these columns: TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
InnoDB is the default and most general-purpose storage engine, and Oracle recommends using it for tables except for specialized use cases. (The CREATE TABLE statement in MySQL 5.7 creates InnoDB tables by default.) MySQL Server uses a pluggable ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
TABLESPACE options extend the Transportable Tablespace feature to individual InnoDB table partitions. Each InnoDB table partition has its own tablespace file (.ibd file). The Transportable Tablespace feature also supports copying or restoring ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
Use OPTIMIZE TABLE in these cases, depending on the type of table: After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. After ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...