Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
Ndb_conflict_fn_max: Number of times that NDB replication conflict resolution based on "greater timestamp wins" has been applied to update and delete operations. Ndb_conflict_fn_max_del_win: Number of times that NDB replication conflict resolution ...ndb-log-empty-epochs: When enabled, causes epochs in which there were no changes to be written to ndb_apply_status and ndb_binlog_index tables, even when --log-slave-updates is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-migrate-keyring.html
The mysql_migrate_keyring utility migrates keys between one keyring component and another. Invoke mysql_migrate_keyring like this (enter the command on a single line): mysql_migrate_keyring --component-dir=dir_name --source-keyring=name ...For ...
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer joins. Also, the ...Benefits of BKA include improved join performance due to more efficient table ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior of such tables, and could easily lead to corruption or loss of data. Reads from such tables are relatively unaffected; ... This section discusses current restrictions and limitations on MySQL partitioning ...The following constructs are not permitted in ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-descriptions.html
For window function usage information and examples, and definitions of terms such as the OVER clause, window, partition, frame, and peer, see Section 14.20.2, “Window Function Concepts and Syntax”. PERCENT_RANK() Percentage rank value RANK() ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
Can I preserve a results tab rather than have it refresh every time I execute a statement? Yes, you can pin the results tab to force it to remain and be unaffected by UPDATE and other statements. How can I view my MySQL Workbench query history? In ...Is there an easy way to select all data from a table, and then see the results? ... FAQ ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
For DATE and DATETIME columns that are declared as NOT NULL, you can find the special date '0000-00-00' by using a statement like this: SELECT * FROM tbl_name WHERE date_column IS NULL This is needed to get some ODBC applications to work because ...
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
For example, the following option file setting changes the three connection-related character set system variables set to koi8r each time you invoke mysql: [mysql] default-character-set=koi8r If you are using the mysql client with auto-reconnect ...
https://dev.mysql.com/doc/ndbapi/en/preface.html
MySQL NDB Cluster 8.0, 8.4, and 9.0 also provide support for applications written using Node.js. Node.js support is deprecated in NDB 9.0, and is removed altogether as of NDB 9.1. This Guide includes concepts, terminology, class and function ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
For example, in the above scenario of 5 servers where 3 leave at once, if the 3 leaving servers warn the group that they are leaving, one by one, then the membership is able to adjust itself from 5 to 2, and at the same time, securing quorum while ...This is the case for regular transactions but is also required for group membership changes and some internal messaging that keeps the group ...