Search Results
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). ndbinfo Information Database: Added a type column to the transporter_details table in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-mta.html
Transaction Dependency and Writeset Handling Transaction dependencies are detected using analysis of each transaction's writeset, that is, the set of rows (table, key values) written by the transaction. Where a table has secondary unique keys, these ...To use this functionality with NDB Cluster, it is necessary that the replica be configured to use multiple worker ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
When data is loaded into MySQL HeatWave, it is partitioned by the table primary key and sliced horizontally for distribution among MySQL HeatWave nodes by default. Tip For data placement key recommendations, use MySQL HeatWave Autopilot Advisor ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-and-mysql-replication.html
For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica. Cascading actions for InnoDB tables on the source are executed on the replica only if the tables sharing the foreign key relation use ...
https://dev.mysql.com/doc/refman/8.4/en/statement-caching.html
Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate tables, or that analyze, optimize, or repair tables. Table content changes (for example, with INSERT or UPDATE) do not change metadata, nor do ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica-backup-restore.html
MySQL Enterprise Backup does not include temporary tables inside a backup. To avoid the issue, after the hot backup phase of a replica backup in which mysqlbackup copies all the InnoDB tables, it enters into a loop, in which the following happens: ... To backup a replica database, add the --replica-info option to your backup ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
Include a TIMESTAMP column in all tables that you want to be able to update. Include a primary key in each MySQL table you want to use with Access. If you are using Connector/ODBC to link to a table that has a BIGINT column, the results are ... The ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-mecab.html
For InnoDB tables, minimum token size is defined by the innodb_ft_min_token_size configuration option, which has a default value of 3. For MyISAM tables, minimum token size is defined by ft_min_word_len, which has a default value of 4. Creating a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
You can identify the current primary using the MEMBER_ROLE column in the Performance Schema replication_group_members table. In MySQL 8.4, it also waits for the completion of any ongoing DDL statements such as ALTER TABLE. The following function ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-transactions.html
That blocking lock request is for a row or table lock held by another transaction in an incompatible mode. data_lock_waits: This Performance Schema table indicates which transactions are waiting for a given lock, or for which lock a given ...Each ...