Search Results
Displaying 281 to 290
of 292 total results
- « Previous
- 27
- 28
- 29
- 30
- Next »
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-failure-conditions.html
The operation takes a long time and concurrent DML modifies the table so much that the size of the temporary online log exceeds the value of the innodb_online_alter_log_max_size configuration option. The changes made by the concurrent DML take ...A ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-compression.html
Table compression is enabled using the ROW_FORMAT=COMPRESSED attribute with CREATE TABLE or ALTER TABLE. This section describes InnoDB table compression, which is supported with InnoDB tables that reside in file_per_table tablespaces or general ...
https://dev.mysql.com/doc/refman/8.4/en/out-of-range-and-overflow.html
In strict mode, these statements fail, and some or all the values are not inserted or changed, depending on whether the table is a transactional table and other factors. If no restrictive modes are enabled, MySQL clips the value to the appropriate ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-storage-engines.html
You can manually convert tables to InnoDB using the following ALTER TABLE statement: mysql> ALTER TABLE table_name ENGINE=InnoDB; The recommended method for migrating data is to use the MySQL Shell client. MySQL Shell dump utilities provide a ocimds ... MySQL Storage Engines 3.1.2.5 MySQL Storage Engines MySQL HeatWave on AWS supports only the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-exclusive-to-cluster.html
NDB Cluster has the following limitations or restrictions with regard to binary logging: NDB Cluster cannot produce a binary log for tables having BLOB columns but no primary key. The following are limitations specific to the NDB storage engine: ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-slowquerylogging-category.html
Log Slow Admin Statements Enabled Log slow administrative statements such as OPTIMIZE TABLE, ANALYZE TABLE, and ALTER TABLE to the slow query log. Table 7.32 Slow Query Logging Configuration Metrics NameDescriptionLog Queries Not Using Indexes ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-concurrent-ddl.html
DDL operations that are not permitted during a cloning operation regardless of the clone_block_ddl setting include: ALTER TABLE tbl_name DISCARD TABLESPACE; ALTER TABLE tbl_name IMPORT TABLESPACE; ALTER INSTANCE DISABLE INNODB REDO_LOG; . In MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-example.html
You may also specify these parameters on the command line when invoking the executables. You may also use a separate [mysql_cluster] section in the cluster my.cnf file for settings to be read and used by all executables: # cluster-specific settings ... To support NDB Cluster, you should update my.cnf as shown in the following ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-configuration.html
Important Once you have started a mysqld process with the ndbcluster and ndb-connectstring parameters in the [mysqld] and [mysql_cluster] sections of the my.cnf file as shown previously, you cannot execute any CREATE TABLE or ALTER TABLE statements ... In this section, we discuss manual configuration of an installed NDB Cluster by creating and editing configuration ...
https://dev.mysql.com/doc/mysqld-version-reference/en/optvar-changes-5-7.html
The following list details the changes to specific options and variables within MySQL 5.7.
Displaying 281 to 290
of 292 total results
- « Previous
- 27
- 28
- 29
- 30
- Next »