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/general-thread-states.html
altering table The server is in the process of executing an in-place ALTER TABLE. committing alter table to storage engine The server has finished an in-place ALTER TABLE and is committing the result. copy to tmp table The thread is processing an ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
A table in a foreign key relationship cannot be altered to use another storage engine. When you add a foreign key constraint to a table using ALTER TABLE, remember to first create an index on the column(s) referenced by the foreign key. Dropping ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
To fix this disparity between column lengths, use ALTER TABLE to lengthen ActualPC from 10 characters to 15 characters: mysql> ALTER TABLE tt MODIFY ActualPC VARCHAR(15); Now tt.ActualPC and et.EMPLOYID are both VARCHAR(15). EXPLAIN returns a row of ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
Partitioning and repartitioning operations (such as ALTER TABLE with PARTITION BY ..., REORGANIZE PARTITION, or REMOVE PARTITIONING) depend on file system operations for their implementation. This means that you need many more file descriptors to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
(Bug #81689, Bug #23518923) --ndb-allow-copying-alter-table=[ON|OFF] Command-Line Format --ndb-allow-copying-alter-table[={OFF|ON}] Introduced 5.7.10-ndb-7.5.0 System Variable ndb_allow_copying_alter_table Scope Global, Session Dynamic Yes Type ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
Orphan Intermediate Tables If MySQL exits in the middle of an in-place ALTER TABLE operation (ALGORITHM=INPLACE), you may be left with an orphan intermediate table that takes up space on your system. Note If an unexpected exit occurs during an ...If ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
If you use ALTER TABLE to change a MERGE table to another storage engine, the mapping to the underlying tables is lost. Instead, the rows from the underlying MyISAM tables are copied into the altered table, which then uses the specified storage ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
Note When performing schema changes on NDB tables, applications should wait until the ALTER TABLE statement has returned in the MySQL client connection that issued the statement before attempting to use the updated definition of the table. If you ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
Only statements involving tables are affected, not statements such as CREATE DATABASE, DROP DATABASE, and ALTER DATABASE. If the table name pattern is %, it matches any table name and the option also applies to database-level statements (CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
When setting MaxNoOfAttributes, it is important to prepare in advance for any ALTER TABLE statements that you might want to perform in the future. This is due to the fact, during the execution of ALTER TABLE on a Cluster table, 3 times the number of ...Information about configuration parameters specific to NDB Cluster Disk Data tables can be found later in this section (see Disk Data Configuration ...