Search Results
https://dev.mysql.com/doc/refman/8.4/en/working-with-null.html
A common error when working with NULL is to assume that it is not possible to insert a zero or an empty string into a column defined as NOT NULL, but this is not the case. The NULL value can be surprising until you get used to it. Conceptually, ...
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
(Bug #35854919) Executing mysqldump on a replica would insert the FLUSH TABLES operation, an operation that writes to the binary log. Now FLUSH LOCAL TABLES is inserted instead to prevent GTID related issues during replication due to these binary ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #35037114) InnoDB: Common prefix compression for redo log inserts (MLOG_REC_INSERT) was disabled but is now enabled when the versions match. (Bug #33327093) InnoDB: It was possible for ALTER TABLE, which rebuilds InnoDB tables using the INPLACE ... Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database cache was not flushed properly following execution of DROP ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-history-table-update.html
Rename the original mysql.backup_history table to mysql.backup_history_old, and the mysql.backup_history_new table to mysql.backup_history. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are granted ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-table-update.html
Rename the original mysql.backup_progress table to mysql.backup_progress_old, and the mysql.backup_progress_new table to mysql.backup_progress. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-sbt-history-table-update.html
Rename the original mysql.backup_sbt_history table to mysql.backup_sbt_history_old, and the mysql.backup_sbt_history_new table to mysql.backup_sbt_history. Note If you are working with a multiprimary Group Replication setting, make sure these ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
InsertRecoveryWork: Percentage of RecoveryWork used for inserted rows; has no effect unless partial local checkpoints are in use. RestartOnErrorInsert: Control type of restart caused by inserting error (when StopOnError is enabled).
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-client-commands.html
Multiple values should be separated by commas only; do not insert spaces before or after any of the commas. These commands are issued to the management agent using the mysql client program included with the MySQL NDB Cluster distribution (for ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-function-reference.html
The following table summarizes the functions available in the C API basic interface. For greater detail, see the descriptions in Section 5.4, “C API Basic Function Descriptions”.