Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
OPTIMIZE TABLE can be used to defragment a table's variable-sized pages; this moves row variable-sized parts between pages so that some whole pages can be freed for re-use. memory_per_fragment Table: Notes memory_per_fragment Table: Examples The ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-online-operations.html
This does not perform any defragmentation, which requires an OPTIMIZE TABLE or null ALTER TABLE statement. MySQL NDB Cluster supports online table schema changes using ALTER TABLE ... NDB Cluster handles COPY and INPLACE as described in the next ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-params-ndbd.html
SchedulerResponsiveness: Set NDB scheduler response optimization 0-10; higher values provide better response time but lower throughput. The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-conflict-resolution.html
Due to the fact that no timestamp is available for a delete operation, a delete using NDB$MAX() is in fact processed as NDB$OLD, but for some use cases, this is not optimal. Requirements Source Column Control Conflict Resolution Control Conflict ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-schema.html
Important For insert conflict resolution using NDB$MAX_INS() or NDB$MAX_DEL_WIN_INS(), an SQL node (that is, a mysqld process) can record row updates on the source cluster as WRITE_ROW events with the --ndb-log-update-as-write option enabled for ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-command-options.html
Note The mysql client always passes optimizer hints to the server, regardless of whether this option is given. mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option file.
https://dev.mysql.com/doc/refman/9.7/en/mysql-configurator-cli.html
config-type N/A configuration-type list Developer, Server, Dedicated, Manual development configure, reconfigure N/A Optimizes system resources depending on the intended use of the server instance. MySQL Configurator supports GUI (default) and CLI ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/mysql-nutshell.html
For further information, see the description of innodb_log_writer_threads in the documentation, as well as Section 10.5.4, “Optimizing InnoDB Redo Logging”. This section summarizes what has been added to, deprecated in, changed, and removed ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to ...