Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-remarks.html
This section provides general information about the behavior of and current limitations in adding NDB Cluster nodes online. The ability to add new nodes online includes a means to reorganize NDBCLUSTER table data and indexes so that they are ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-ndbd.html
The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data nodes. For detailed descriptions and other additional information about each of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-start-phases.html
This section provides a simplified outline of the steps involved when NDB Cluster data nodes are started. More complete information can be found in NDB Cluster Start Phases, in the NDB Internals Guide. These phases are the same as those reported in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that mysql itself interprets. For a list of these commands, type help or \h at the mysql> prompt: mysql> help List of all MySQL commands: ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
Manual: Prevents MySQL Configurator from attempting to optimize the server installation, and instead, sets the default values to the server variables included in the my.ini configuration file. MySQL Configurator performs the initial configuration, ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. A description of error logging is given ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-myisam-bulk-data-loading.html
These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT Statements”. For a MyISAM table, you can use concurrent inserts to add rows at the same time that SELECT statements are running, ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient way to specify commonly used options so that they need not be entered on the command line each time you run a ...
https://dev.mysql.com/doc/refman/8.4/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...