PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.3Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
You must create any exceptions table before creating the data table with which it is to be used. Conflict Resolution Exceptions Table To use the NDB$OLD() conflict resolution function, it is also necessary to create an exceptions table corresponding ... Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including circular replication), it is possible that different sources may try to update the same row on the replica with different ...
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 ...altering table The server is in the process of executing an in-place ALTER ... The following list describes thread State values that are associated with ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
Using temporary (JSON property: using_temporary_table) To resolve the query, MySQL needs to create a temporary table to hold the result. EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
InnoDB supports FOR EXPORT for tables that have their own .ibd file file (that is, tables created with the innodb_file_per_table setting enabled). | tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS ...Note It is not possible to issue FLUSH statements within stored functions or ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
The following are known problems with MERGE tables: MERGE child tables are locked through the parent table. If the parent is a temporary table, it is not locked, and thus the child tables are also not locked; this means that parallel use of the ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
Renaming a table requires ALTER and DROP on the old table, CREATE, and INSERT on the new table. CREATE Enables use of statements that create new databases and tables. CREATE TABLESPACE Enables use of statements that create, alter, or drop ... The ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 15.1.20, “CREATE TABLE Statement”), and can also be ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
(NDB 8.0.13) This parameter specifies the directory where all files created for metadata, REDO logs, UNDO logs (for Disk Data tables), and data files are placed. Consider this table definition: CREATE TABLE example ( a INT NOT NULL, b INT NOT NULL, ...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/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/converting-tables-to-innodb.html
Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible with MySQL 8.0. When you convert MyISAM tables that are large, frequently accessed, and hold vital data, investigate and consider the innodb_file_per_table and ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...