Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. See also the notes about spatial indexes under Section 13.4.10, “Creating Spatial Indexes”. Use the CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-indexes-create.html
If a collection is large and queries on a specific field are common, then consider creating an index on a specific field inside a document. For example, the following query performs better with an index on the Population field: mysql-js> ... Indexes ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-select.html
ROW format: The statement is logged as a CREATE TABLE statement followed by a series of insert-row events. SELECT statement to make any changes in tables other than the table that is created by the statement. SELECT always performs an implicit ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-routing-guidelines-creating-activating.html
Create Routing Guidelines using the following command: object.create_routing_guideline(name[, json[, options]]) object: the Cluster, ClusterSet, or Replicaset to which the routing guideline is associated. If a JSON document is not provided, a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
The CREATE INDEX statement only finishes after all transactions that are accessing the table are completed, so that the initial state of the index reflects the most recent contents of the table. Online DDL support for adding secondary indexes means ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-user-accounts.html
It demonstrates configuring global password policies, using security-related CREATE USER options, granting user privileges, and verifying user privileges and authentication. $> cd /usr/local/mysql $> bin/mysql -u root -p Enter password: (enter root ...The user1 account is defined with an SSL/TLS option that requires an encrypted ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Trying either to create a temporary table that uses the NDB storage engine or to alter an existing temporary table to use NDB fails with the error Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY'. Attempting to create ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing statements. mysqlslap runs in three stages: Create schema, table, and optionally ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.incremental.html
To create a differential backup, simply follow the instructions below for performing incremental backups, and make sure you specify a full backup as the base of your incremental backup; you should also ignore any instructions that only apply to the ...In order to that, after making first a full backup that contains all data, you can do one of the following: Performing a series of differential ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-create-table-select.html
(R-log-create-select-statement-format) If logging in statement format (that is, one of the following holds: (1) @@SESSION.binlog_format=STATEMENT; (2) @@SESSION.binlog_format=MIXED and statement is safe): If there is an error, do not write anything.