PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-table-distribution-status.html
The table_distribution_status table provides information about the progress of table distribution for NDB tables. is_reorg_ongoing Whether table is currently being reorganized (1 if true) Notes The table_distribution_status table was added in NDB ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/mysql-cluster-privilege-distribution.html
NDB Cluster supports distribution of MySQL users and privileges across all SQL nodes in an NDB Cluster. This support is not enabled by default; you should follow the procedure outlined in this section in order to do so. Normally, each MySQL ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/mysql-installer-workflow.html
Manual Prevents MySQL Installer 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 Installer provides a wizard-like tool to install and ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/optimizing-myisam-bulk-data-loading.html
These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.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, if ...
https://dev.mysql.com/doc/refman/5.7/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 ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
TRUNCATE PARTITION prunes locks; only the partitions to be emptied are locked. In MySQL 5.7, partition lock pruning eliminates unneeded locks in many cases, and most statements reading from or updating a partitioned MyISAM table cause only the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
It is not possible under normal circumstances in NDB Cluster to create an NDB Cluster table using any partitioning type other than [LINEAR] KEY, and attempting to do so fails with an error. The following limitations apply to the use of storage ...