Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-instance.html
For additional ALTER INSTANCE ROTATE INNODB MASTER KEY usage information, see Section 17.13, “InnoDB Data-at-Rest Encryption”. For additional ALTER INSTANCE ROTATE BINLOG MASTER KEY usage information, including what to do if the process does not ... ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY | ROTATE BINLOG MASTER KEY | RELOAD TLS [FOR CHANNEL {mysql_main | mysql_admin}] [NO ROLLBACK ON ERROR] | RELOAD KEYRING } ALTER INSTANCE defines actions applicable to a MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-monitoring.html
Clone memory usage instruments include: memory/innodb/clone: Tracks memory allocated by InnoDB for the dynamic snapshot. For information about monitoring memory usage using Performance Schema, see Section 29.12.20.10, “Memory Summary Tables”.
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
Defining Primary Keys The PRIMARY KEY clause is a critical factor affecting the performance of MySQL queries and the space usage for tables and indexes. If you have MyISAM tables that you want to convert to InnoDB for better reliability and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
This section describes the AUTO_INCREMENT lock modes, usage implications of different AUTO_INCREMENT lock mode settings, and how InnoDB initializes the AUTO_INCREMENT counter. InnoDB AUTO_INCREMENT Lock Modes InnoDB AUTO_INCREMENT Lock Mode Usage ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
Use the max attribute only in cases where constraining disk usage is of critical importance. Warning On 32-bit GNU/Linux x86, if memory usage is set too high, glibc may permit the process heap to grow over the thread stacks, causing a server failure. A formula similar to the following that calculates global and per-thread memory allocation for MySQL can be used to estimate MySQL memory ... The first decisions to make about InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-cluster-log.html
The following table lists the most common NDB cluster log messages. For information about the cluster log, log events, and event types, see Section 25.6.3, “Event Reports Generated in NDB Cluster”. These log messages also correspond to log ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-delete-all.html
Usage ndb_delete_all -c connection_string tbl_name -d db_name This deletes all rows from the table named tbl_name in the database named db_name. --usage Command-Line Format --usage Display help text and exit; same as --help. In some cases, this can ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
Usage ndb_desc -c connection_string tbl_name -d db_name [options] ndb_desc -c connection_string index_name -d db_name -t tbl_name Additional options that can be used with ndb_desc are listed later in this section. --usage Command-Line Format --usage ... ndb_desc provides a detailed description of one or more NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-index.html
Usage ndb_drop_index -c connection_string table_name index -d db_name The statement shown above drops the index named index from the table in the database. --usage Command-Line Format --usage Display help text and exit; same as --help. It is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-table.html
Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ndb_drop_table are shown in the following table. --usage Command-Line Format --usage Display help text and exit; same as --help. --connect-retries ...