Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-indexing.html
For a text field, you must specify a prefix length for the index, as required by MySQL Server: myCollection.createIndex("zip", {fields: [{field: "$.zip", type: "TEXT(10)"}]}) See Defining an Index for information on the format of IndexDefinition and ...Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that extract data from the documents in the ... To make large collections ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
For a text field, you must specify a prefix length for the index, as required by MySQL Server: myCollection.createIndex("zip", {fields: [{field: "$.zip", type: "TEXT(10)"}]}) See Defining an Index for information on the format of IndexDefinition and ...Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that extract data from the documents in the ... To make large collections ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Note In previous versions of MySQL, when evaluating an expression containing LEAST() or GREATEST(), the server attempted to guess the context in which the function was used, and to coerce the function's arguments to the data type of the expression ...For additional examples of row comparisons in the context of row subqueries, see Section 15.2.15.5, “Row ... Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
If it is very likely that a long string column has a unique prefix on the first number of characters, it is better to index only this prefix, using MySQL's support for creating an index on the leftmost part of the column (see Section 15.1.15, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-tcp-definition-direct.html
In the following example, we envision a cluster with at least four hosts, one each for a management server, an SQL node, and two data nodes. Setting up a cluster using direct connections between data nodes requires specifying explicitly the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-gr-memory-monitoring-ps-instruments-enable.html
For more information, see Section 29.3, “Performance Schema Startup Configuration” and Section 29.4, “Performance Schema Runtime Configuration”.
https://dev.mysql.com/doc/refman/8.4/en/recovery-from-backups.html
To not lose them, we would have needed to have the MySQL server store its MySQL binary logs into a safe location (RAID disks, SAN, ...) different from the place where it stores its data files, so that these logs were not on the destroyed disk. The ... Now, suppose that we have a catastrophic unexpected exit on Wednesday at 8 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features.html
In other words, successful statement-based replication requires that any SQL features used be supported by both the source and the replica servers. If you use a feature on the source server that is available only in the current version of MySQL, you ... The following sections provide information about what is supported and what is not in MySQL replication, and about specific issues and situations that may occur when replicating certain ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects.html
This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution. Event: An object created with CREATE EVENT and invoked by the server according to schedule. The following ...