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-information-schema-fulltext_index-tables.html
INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are removed from ...INNODB_FT_INDEX_CACHE: Provides token information about newly inserted rows in a FULLTEXT ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. CREATE INDEX cannot be used to create a PRIMARY KEY; use ALTER TABLE instead. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description of your table. If you start the MySQL server with external locking ...The output from these commands is explained later in this ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... To execute RENAME TABLE, there must be no active ...InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
ANALYZE TABLE is supported for partitioned tables, and you can use ALTER TABLE ... ANALYZE PARTITION to analyze one or more partitions; for more information, see Section 13.1.8, “ALTER TABLE Statement”, and Section 22.3.4, “Maintenance of ...
https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html
Methods for rebuilding a table include: Dump and Reload Method ALTER TABLE Method REPAIR TABLE Method Dump and Reload Method If you are rebuilding tables because a different version of MySQL cannot handle them after a binary (in-place) upgrade or ...
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
CREATE TABLE, ALTER TABLE, and DROP TABLE are valid operations on a log table. For ALTER TABLE and DROP TABLE, the log table cannot be in use and must be disabled, as described later. The log tables can be altered to use the MyISAM storage engine.
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Evaluation of some ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
| Connections | 30023 | | Created_tmp_disk_tables | 0 | | Created_tmp_files | 3 | | Created_tmp_tables | 2 | ... For additional connection-related information, check the Connection_errors_xxx status variables and the host_cache table. The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
TABLESPACE [=] tablespace_name or ALTER TABLE tbl_name TABLESPACE [=] tablespace_name to add tables to the tablespace. Additional data files may be added to the tablespace by using the ALTER TABLESPACE statement (see Section 13.1.9, “ALTER ...In ...The precise syntax and semantics depend on the storage engine ...