Search Results
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-json-mysqlsh.html
With the mysqlsh command interface, you invoke the JSON import utility as follows: mysqlsh user@host:port/mydb -- util importJson <path> [options] or mysqlsh user@host:port/mydb -- util import-json <path> [options] For information on this syntax, ...port The port number for MySQL Shell's connection to the MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-operations.html
Renaming an index ALTER TABLE tbl_name RENAME INDEX old_index_name TO new_index_name, ALGORITHM=INPLACE, LOCK=NONE; Adding a FULLTEXT index CREATE FULLTEXT INDEX name ON table(column); Adding the first FULLTEXT index rebuilds the table if there is ...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 ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-set.html
Setting Up Encryption NDB Cluster 8.0.31 and later supports transparent data encryption (TDE) for user data stored in NDB tables (see File System Encryption for NDB Cluster); this is also supported by MySQL Cluster Manager 8.0.31 and later. Using a ...Attributes can be set on either the process level or instance ...
https://dev.mysql.com/doc/refman/9.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-frequently-asked-questions.html
What is the group_replication_bootstrap_group option used for? The bootstrap flag instructs a member to create a group and act as the initial seed server. When the group is originally created, or when shutting down and restarting the entire group.
https://dev.mysql.com/doc/refman/9.7/en/thread-pool-operation.html
For example, if parallel transactions affect index creation or an online buffer pool resizing operation, you can configure a transaction delay to reduce resource contention while those operations are running. Otherwise, the thread pool considers the ... The thread pool consists of a number of thread groups, each of which manages a set of client ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-table-export.html
You can also set field- and line-handling options as for the SELECT...INTO OUTFILE statement to create data files in arbitrary formats. One file is always created per table by this utility, regardless of release version. If you create the table ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/9.7/en/news-9-2-0.html
(Bug #36237561) Bugs Fixed Microsoft Windows: Successive iterations of the sequence ndb_sign_keys --create-key followed by ndb_sign_keys --promote were unsuccessful on Windows. This fix also adds a warning to inform API users that deleting ... MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/9.7/en/show-engine.html
For rwlocks, the Name field reports the source file where the rwlock is implemented, and the line number in the file where the rwlock is created. The remaining rows from the output of SHOW ENGINE NDB STATUS which are most likely to prove useful in ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...