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/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/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/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/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-nutshell.html
ALTER TABLE now supports a RENAME INDEX clause that renames an index. These InnoDB enhancements were added: VARCHAR column size can be increased using an in-place ALTER TABLE, as in this example: ALTER TABLE t1 ALGORITHM=INPLACE, CHANGE COLUMN c1 c1 ...The server now requires account rows in the mysql.user system table to have a nonempty plugin column value and disables accounts with an empty ...
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/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 ...