Search Results
https://dev.mysql.com/doc/internals/en/load-data-infile-events.html
1) In MySQL 3.23, there was only one event: Load_log_event (type code LOAD_EVENT = 6). 2) In MySQL 4.0.0, the file contents were included in the binary log. Lost in the mysteries of time is the knowledge of whether there was ever a server version ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-mynode.html
To create an instance, use the Node.js require() function with the driver name, like this: var nosql = require("mysql-js"); ConnectionProperties can be used to retrieve or set the connection properties for a given session. ndb_connect_retries: ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-data-split.html
As of MySQL 9.4.1, you can automatically create training and testing datasets with the TRAIN_TEST_SPLIT routine. The following data types for this column are supported: DATETIME TIMESTAMP DATE TIME YEAR semisupervised: If running an anomaly ...
https://dev.mysql.com/doc/refman/8.4/en/creating-database.html
To make menagerie the current database, use this statement: mysql> USE menagerie Database changed Your database needs to be created only once, but you must select it for use each time you begin a mysql session. Otherwise, you need to create it ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
Group Replication cannot be started following a MySQL Server upgrade that uses the MINIMAL option (--upgrade=MINIMAL), which does not upgrade system tables on which the replication internals depend. Group Replication in MySQL 8.4 supports checksums, ... Limit on Group Size Limits on Transaction Size The following known limitations exist for Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrading-member.html
If the primary is upgraded before a secondary, a new primary using the older MySQL version is chosen, but there is no need for this step. Important If an upgraded member has group_replication_start_on_boot=1 then it could rejoin the group before you ... This section explains the steps required for upgrading a member of a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before halting. This repository is created by default as an InnoDB table named ...This section describes the impact of an unexpected halt of a replica during replication, and how to configure a replica for the best chance of recovery to continue ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
The first time MySQL needs the subquery result, it materializes that result into a temporary table. Any subsequent time the result is needed, MySQL refers again to the temporary table. If materialization is not used, the optimizer sometimes rewrites ... The optimizer uses materialization to enable more efficient subquery ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-restrictions.html
In MySQL, it can produce nondeterministic results because f() might be executed a different number of times for different executions of a given query depending on how the optimizer chooses to handle it. FROM t...) AS dt ...); Here the result from ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
The DEFINER clause specifies the MySQL account to be used when checking access privileges at trigger activation time. MySQL takes the DEFINER user into account when checking trigger privileges as follows: At CREATE TRIGGER time, the user who issues ... CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | PRECEDES } other_trigger_name This statement creates a new ...