Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-indexing.html
The Collection.createIndex() method fails with an error if an index with the same name already exists or if the index definition is not correctly formed. Important For MySQL 8.0.16 and earlier, fields that are JSON arrays are not supported in the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
The Collection.createIndex() method fails with an error if an index with the same name already exists or if the index definition is not correctly formed. Important For MySQL 8.0.16 and earlier, fields that are JSON arrays are not supported in the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-details.html
FAILED: An error condition prevented the creation or continued operation of the MySQL HeatWave Cluster. Last Updated: The date and time the MySQL HeatWave Cluster was last updated. Created: The date and time the MySQL HeatWave Cluster was created.
https://dev.mysql.com/doc/internals/en/binlog-event-header.html
Binlog::EventHeader: Binlog header Payload 4 timestamp 1 event type 4 server-id 4 event-size if binlog-version > 1: 4 log pos 2 flags Fields timestamp (4) -- seconds since unix epoch event_type (1) -- see Binlog Event Type server_id (4) -- server-id ... The binlog event header starts each event and is either 13 or 19 bytes long, depending on the binlog ...
https://dev.mysql.com/doc/internals/en/start-event-v3.html
create_timestamp (4) -- seconds since Unix epoch when the binlog was created . Payload 2 binlog-version string[50] mysql-server version 4 create timestamp Fields binlog-version (2) -- version of this binlog format. Binlog::START_EVENT_V3: A start ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-tuning-recovery.html
If the connection retry limit is reached without a successful connection, the distributed recovery procedure terminates with an error. The following statement sets the maximum number of attempts to connect to a donor to 5: mysql> SET GLOBAL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
(For manual encoding instructions, see Section 5.8.1.4, “Encoding String Columns”.) mysql> CALL sys.heatwave_advisor(JSON_OBJECT('auto_enc',JSON_OBJECT('mode','recommend','fixed_enc', JSON_OBJECT('tpch.CUSTOMER.C_ADDRESS','varlen')))); Advisor ...Using the right string column encodings can reduce the amount of memory required on MySQL HeatWave nodes and improve query ...
https://dev.mysql.com/doc/internals/en/rnd-init.html
Unlike index_init(), rnd_init() can be called two times without rnd_end() in between (it only makes sense if scan=1). then the second call should prepare for the new table scan (e.g if rnd_init allocates the cursor, second call should position it to ...Synopsis virtual int rnd_init (scan); bool scan ; Description This is the rnd_init ...
https://dev.mysql.com/doc/x-devapi-userguide/en/fetching-all-data-items-at-once.html
If, for example, an application calls fetchOne() to fetch the first data item of a data set, then a subsequent call to fetchAll() returns the second to last data item. Similarly, when calling fetchAll() again for a data set after calling it ... In ...
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. The optimizer uses semijoin strategies to improve subquery execution, ...But for some questions, the only information that matters is whether there is a match, not the number of ...