PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
After create This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. This state is used even if the table could not be created due to some error. This state occurs after ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
The ndb_binlog_index and ndb_apply_status tables are created in the mysql database. User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as expected. This creates a set of challenges that raise ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
SEQ_IN_INDEX The column sequence number in the index, starting with 1. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types ...
https://dev.mysql.com/doc/refman/8.0/en/lock-instance-for-backup.html
LOCK INSTANCE FOR BACKUP prevents files from being created, renamed, or removed. LOCK INSTANCE FOR BACKUP permits DDL operations that only affect user-created temporary tables. In effect, files that belong to user-created temporary tables can be ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
(myisampack creates an intermediate file named tbl_name.TMD in the database directory while it compresses the table. --tmpdir=dir_name, -T dir_name Command-Line Format --tmpdir=dir_name Type Directory name Use the named directory as the location ...
https://dev.mysql.com/doc/refman/8.0/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. To ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-diskio.html
For example, creating a new MySQL instance and its associated data files could cause large surges of disk write activity, impeding the performance of other MySQL instances that use the same storage devices. For more information, refer to the ... If ...
https://dev.mysql.com/doc/refman/8.0/en/show-index.html
Seq_in_index The column sequence number in the index, starting with 1. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html
If not, the server creates them in the data directory, populates them with metadata, and then proceeds with its normal startup sequence. Important If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 ... This section describes how to upgrade MySQL binary and package-based installations on ...