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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
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/grant-tables.html
After an account's password has been expired, all operations performed by the account in subsequent connections to the server result in an error until the user issues an ALTER USER statement to establish a new account password. The mysql system ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
When altering the storage engine of a table, table options that are not applicable to the new storage engine are retained in the table definition to enable reverting the table with its previously defined options to the original storage engine, if ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
ALTER Enables use of the ALTER TABLE statement to change the structure of tables. Renaming a table requires ALTER and DROP on the old table, CREATE, and INSERT on the new table. CREATE TABLESPACE Enables use of statements that create, alter, or drop ...Privileges for database objects such as tables, indexes, views, and stored routines can be granted for specific objects within a database, for all objects of a given type within a database (for example, all tables in a database), or globally for all objects of a given type in all ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
Converting an Existing Table To convert a non-InnoDB table to use InnoDB use ALTER TABLE: ALTER TABLE table_name ENGINE=InnoDB; Warning Do not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables. Cloning the Structure of a ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
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/innodb-file-per-table-tablespaces.html
Warning Disabling innodb_file_per_table prevents table-copying ALTER TABLE operations from implicitly moving a table that resides in the system tablespace to a file-per-table tablespace. A table-copying ALTER TABLE operation recreates the table ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
In this case, OPTIMIZE TABLE is just mapped to ALTER TABLE. InnoDB Details For InnoDB tables, OPTIMIZE TABLE is mapped to ALTER TABLE ... OPTIMIZE TABLE rebuilds the table using the table copy method under the following conditions: When the ...