From: jon Date: January 9 2009 7:05pm Subject: svn commit - mysqldoc@docsrva: r13078 - in trunk: dynamic-docs/changelog mysql-monitor-2.0 mysqlqb refman-4.1 refman-5.0 refman-5.1 refman-5.1-maria refman-6.0 List-Archive: http://lists.mysql.com/commits/62889 Message-Id: <200901091905.n09J5KGI004237@docsrva.mysql.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Author: jstephens Date: 2009-01-09 20:05:19 +0100 (Fri, 09 Jan 2009) New Revision: 13078 Log: Documented multi-threaded data node process (ndbmtd) for Cluster 6.4.0. Updated dependencies. Modified: trunk/dynamic-docs/changelog/mysqld-1.xml trunk/mysql-monitor-2.0/Makefile.depends trunk/mysqlqb/Makefile.depends trunk/refman-4.1/Makefile.depends trunk/refman-5.0/Makefile.depends trunk/refman-5.1-maria/Makefile.depends trunk/refman-5.1/Makefile.depends trunk/refman-5.1/mysql-cluster-configuration.xml trunk/refman-5.1/mysql-cluster-process-management.xml trunk/refman-5.1/mysql-cluster-roadmap.xml trunk/refman-6.0/Makefile.depends Modified: trunk/dynamic-docs/changelog/mysqld-1.xml =================================================================== --- trunk/dynamic-docs/changelog/mysqld-1.xml 2009-01-09 18:57:39 UTC (rev 13077) +++ trunk/dynamic-docs/changelog/mysqld-1.xml 2009-01-09 19:05:19 UTC (rev 13078) Changed blocks: 1, Lines Added: 30, Lines Deleted: 0; 1047 bytes @@ -6,6 +6,36 @@ ]> + + + + + + + + + + + + + + + A multi-threaded version of the MySQL Cluster data node daemon + is now available. The multi-threaded ndbmtd + binary is similar to ndbd and functions in + much the same way, but is intended for use on machines with + multiple CPU cores. + + + + For more information, see + . + + + + + + Modified: trunk/mysql-monitor-2.0/Makefile.depends =================================================================== --- trunk/mysql-monitor-2.0/Makefile.depends 2009-01-09 18:57:39 UTC (rev 13077) +++ trunk/mysql-monitor-2.0/Makefile.depends 2009-01-09 19:05:19 UTC (rev 13078) Changed blocks: 4, Lines Added: 4, Lines Deleted: 4; 2104 bytes @@ -14,7 +14,7 @@ dashboard_advisors_IDMAPS = \ ../mysql-monitor-2.0/metadata/dashboard-advisors.idmap \ ../mysql-monitor-2.0/metadata/dashboard-configure.idmap \ - ../mysql-monitor-2.0/metadata/data-items.idmap \ + ../mysql-monitor-2.0/metadata/data-items-core.idmap \ ../mysql-monitor-2.0/metadata/install.idmap dashboard-advisors.validpure: $(dashboard_advisors_SOURCES) dashboard-advisors.titles: $(dashboard_advisors_SOURCES) @@ -611,7 +611,7 @@ images/published/usage-advisor-configuration.png monitor_refman_chapter_arbitrary_SOURCES = monitor-refman-chapter-arbitrary.xml $(monitor_refman_chapter_arbitrary_INCLUDES) monitor_refman_chapter_arbitrary_IDMAPS = \ - ../mysql-monitor-2.0/metadata/data-items.idmap \ + ../mysql-monitor-2.0/metadata/data-items-core.idmap \ ../mysql-monitor-2.0/metadata/log-files.idmap \ ../refman-5.1/metadata/functions-core.idmap \ ../refman-5.1/metadata/sql-syntax-utility.idmap \ @@ -766,7 +766,7 @@ ../mysql-monitor-2.0/metadata/dashboard-overview.idmap \ ../mysql-monitor-2.0/metadata/dashboard-query-analysis.idmap \ ../mysql-monitor-2.0/metadata/dashboard-replication.idmap \ - ../mysql-monitor-2.0/metadata/data-items.idmap \ + ../mysql-monitor-2.0/metadata/data-items-core.idmap \ ../mysql-monitor-2.0/metadata/deployment.idmap \ ../mysql-monitor-2.0/metadata/install.idmap \ ../mysql-monitor-2.0/metadata/log-files.idmap \ @@ -928,7 +928,7 @@ ../mysql-monitor-2.0/metadata/dashboard-overview.idmap \ ../mysql-monitor-2.0/metadata/dashboard-query-analysis.idmap \ ../mysql-monitor-2.0/metadata/dashboard-replication.idmap \ - ../mysql-monitor-2.0/metadata/data-items.idmap \ + ../mysql-monitor-2.0/metadata/data-items-core.idmap \ ../mysql-monitor-2.0/metadata/deployment.idmap \ ../mysql-monitor-2.0/metadata/install.idmap \ ../mysql-monitor-2.0/metadata/log-files.idmap \ Modified: trunk/mysqlqb/Makefile.depends =================================================================== --- trunk/mysqlqb/Makefile.depends 2009-01-09 18:57:39 UTC (rev 13077) +++ trunk/mysqlqb/Makefile.depends 2009-01-09 19:05:19 UTC (rev 13078) Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 575 bytes @@ -67,7 +67,7 @@ ../refman-5.0/metadata/views.idmap \ ../refman-common/metadata/bug-reports.idmap \ ../refman-common/metadata/credits.idmap \ - metadata/mysqlqb_functions.idmap + ../refman-common/metadata/regexp.idmap mysqlqb.validpure: $(mysqlqb_SOURCES) mysqlqb.titles: $(mysqlqb_SOURCES) mysqlqb.useless: $(mysqlqb_SOURCES) Modified: trunk/refman-4.1/Makefile.depends =================================================================== --- trunk/refman-4.1/Makefile.depends 2009-01-09 18:57:39 UTC (rev 13077) +++ trunk/refman-4.1/Makefile.depends 2009-01-09 19:05:19 UTC (rev 13078) Changed blocks: 5, Lines Added: 6, Lines Deleted: 2; 2278 bytes @@ -884,6 +884,10 @@ extending_mysql_IMAGES = extending_mysql_SOURCES = extending-mysql.xml $(extending_mysql_INCLUDES) extending_mysql_IDMAPS = \ + ../refman-4.1/metadata/dba-log-files.idmap \ + ../refman-4.1/metadata/dba-mysqld-server-core.idmap \ + ../refman-4.1/metadata/dba.idmap \ + ../refman-4.1/metadata/errors-problems.idmap \ ../refman-4.1/metadata/extending-mysql.idmap \ ../refman-4.1/metadata/installing.idmap \ ../refman-4.1/metadata/language-structure.idmap \ @@ -891,6 +895,7 @@ ../refman-4.1/metadata/se-innodb-core.idmap \ ../refman-4.1/metadata/sql-syntax-data-manipulation.idmap \ ../refman-4.1/metadata/sql-syntax-server-administration.idmap \ + ../refman-4.1/metadata/sql-syntax-utility.idmap \ ../refman-common/metadata/bug-reports.idmap \ ../refman-common/metadata/information-sources.idmap extending-mysql.validpure: $(extending_mysql_SOURCES) @@ -935,7 +940,6 @@ ../refman-4.1/metadata/dba-privilege-system.idmap \ ../refman-4.1/metadata/dba-security-core.idmap \ ../refman-4.1/metadata/dba-user-management-core.idmap \ - ../refman-4.1/metadata/dba.idmap \ ../refman-4.1/metadata/errors-problems.idmap \ ../refman-4.1/metadata/extending-mysql.idmap \ ../refman-4.1/metadata/functions-core.idmap \ @@ -959,7 +963,6 @@ ../refman-4.1/metadata/sql-syntax-data-definition.idmap \ ../refman-4.1/metadata/sql-syntax-data-manipulation.idmap \ ../refman-4.1/metadata/sql-syntax-replication.idmap \ - ../refman-4.1/metadata/sql-syntax-utility.idmap \ ../refman-4.1/metadata/storage-engines.idmap \ ../refman-common/metadata/bug-reports.idmap \ ../refman-common/metadata/information-sources.idmap @@ -1077,6 +1080,7 @@ ../refman-4.1/metadata/introduction.idmap \ ../refman-4.1/metadata/language-structure.idmap \ ../refman-4.1/metadata/sql-syntax-data-manipulation.idmap \ + ../refman-4.1/metadata/sql-syntax-prepared-statements.idmap \ ../refman-common/metadata/apis-perl.idmap language-structure.validpure: $(language_structure_SOURCES) language-structure.titles: $(language_structure_SOURCES) Modified: trunk/refman-5.0/Makefile.depends =================================================================== --- trunk/refman-5.0/Makefile.depends 2009-01-09 18:57:39 UTC (rev 13077) +++ trunk/refman-5.0/Makefile.depends 2009-01-09 19:05:19 UTC (rev 13078) Changed blocks: 3, Lines Added: 2, Lines Deleted: 1; 1527 bytes @@ -1304,7 +1304,6 @@ ../refman-5.0/metadata/installing-core.idmap \ ../refman-5.0/metadata/news-5.0-core.idmap \ ../refman-5.0/metadata/programs-using.idmap \ - ../refman-5.0/metadata/replication-options-core.idmap \ ../refman-5.0/metadata/se-innodb-core.idmap \ ../refman-5.0/metadata/sql-syntax-data-definition.idmap \ ../refman-5.0/metadata/sql-syntax-data-manipulation.idmap \ @@ -1827,6 +1826,7 @@ ../dynamic-docs/reserved-words/mysql-5.0.9-beta \ ../mysql-monitor-2.0/../common/fixedchars.ent \ ../mysql-monitor-2.0/../common/phrases.ent \ + ../mysql-monitor-2.0/../dynamic-docs/faq/monitor.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-advisors.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-configure.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-events.xml \ @@ -2522,6 +2522,7 @@ ../mysql-monitor-2.0/../common/phrases.ent \ ../mysql-monitor-2.0/../dynamic-docs/changelog/monitor-versions.xml \ ../mysql-monitor-2.0/../dynamic-docs/changelog/monitor.xml \ + ../mysql-monitor-2.0/../dynamic-docs/faq/monitor.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-advisors.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-configure.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-events.xml \ Modified: trunk/refman-5.1/Makefile.depends =================================================================== --- trunk/refman-5.1/Makefile.depends 2009-01-09 18:57:39 UTC (rev 13077) +++ trunk/refman-5.1/Makefile.depends 2009-01-09 19:05:19 UTC (rev 13078) Changed blocks: 3, Lines Added: 2, Lines Deleted: 1; 1541 bytes @@ -1350,7 +1350,6 @@ ../refman-5.1/metadata/dba-mysqld-server-core.idmap \ ../refman-5.1/metadata/errors-problems-core.idmap \ ../refman-5.1/metadata/programs-using.idmap \ - ../refman-5.1/metadata/replication-options-core.idmap \ ../refman-5.1/metadata/se-innodb-core.idmap \ ../refman-5.1/metadata/sql-syntax-data-definition.idmap \ ../refman-5.1/metadata/sql-syntax-data-manipulation.idmap \ @@ -1858,6 +1857,7 @@ ../dynamic-docs/reserved-words/mysql-5.1.9-beta \ ../mysql-monitor-2.0/../common/fixedchars.ent \ ../mysql-monitor-2.0/../common/phrases.ent \ + ../mysql-monitor-2.0/../dynamic-docs/faq/monitor.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-advisors.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-configure.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-events.xml \ @@ -2602,6 +2602,7 @@ ../mysql-monitor-2.0/../common/phrases.ent \ ../mysql-monitor-2.0/../dynamic-docs/changelog/monitor-versions.xml \ ../mysql-monitor-2.0/../dynamic-docs/changelog/monitor.xml \ + ../mysql-monitor-2.0/../dynamic-docs/faq/monitor.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-advisors.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-configure.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-events.xml \ Modified: trunk/refman-5.1/mysql-cluster-configuration.xml =================================================================== --- trunk/refman-5.1/mysql-cluster-configuration.xml 2009-01-09 18:57:39 UTC (rev 13077) +++ trunk/refman-5.1/mysql-cluster-configuration.xml 2009-01-09 19:05:19 UTC (rev 13078) Changed blocks: 3, Lines Added: 32, Lines Deleted: 6; 2646 bytes @@ -1695,13 +1695,22 @@ Parameter names and values are currently case-sensitive. - - - Information about configuration parameters specific to MySQL - Cluster Disk Data tables can be found later in this section. - - + + Information about configuration parameters specific to MySQL + Cluster Disk Data tables can be found later in this section. + + + Beginning with MySQL Cluster NDB 6.4.0, all of these parameters + also apply to ndbmtd (the multi-threaded + version of ndbd). An additional data node + configuration parameter + MaxNoOfExecutionThreads applies to + ndbmtd only, and has no effect when used with + ndbd. For a description of this parameter and + its use, see . + + Identifying data nodes @@ -6209,6 +6218,13 @@ + Beginning with MySQL Cluster NDB 6.4.0, these parameters also + apply to ndbmtd, which is a multi-threaded + version of ndbd. For more information, see + . + + + Restart Type Column Values @@ -6667,6 +6683,16 @@ S + MaxNoOfExecutionThreads + (added in MySQL Cluster NDB 6.4.0; applies to + ndbmtd only) + integer + none + 2 + 8 + N + + MaxNoOfFiredTriggers integer 4000 Modified: trunk/refman-5.1/mysql-cluster-process-management.xml =================================================================== --- trunk/refman-5.1/mysql-cluster-process-management.xml 2009-01-09 18:57:39 UTC (rev 13077) +++ trunk/refman-5.1/mysql-cluster-process-management.xml 2009-01-09 19:05:19 UTC (rev 13078) Changed blocks: 8, Lines Added: 347, Lines Deleted: 2; 14141 bytes @@ -569,6 +569,299 @@ +
+ + fake title for ndbmtd man page section wrapper + + + + + ndbmtd (MySQL Cluster process) + + + + MySQL Cluster + ndbmtd process + + + + MySQL Cluster + data nodes + + + + data nodes (MySQL Cluster) + + + + storage nodes - see data nodes, ndbd, ndbmtd + data nodes, ndbd, ndbmtd + + + + ndbmtd + + 8 + MySQL Database System + MySQL + ¤t-series; + The Storage Engine Node Process (Multi-Threaded) + + + + ndbmtd + + the storage engine node process (multi-threaded version) + + + + + ndbmtd options + + + + + + Description + + + ndbmtd is a multi-threaded version of + ndbd, the process that is used to handle + all the data in tables using the + NDBCLUSTER storage engine. + ndbmtd is intended for use on host + computers having multiple CPU cores. Except where otherwise + noted, ndbmtd functions in the same way as + ndbd; therefore, in this section, we + concentrate on the ways in which ndbmtd + differs from ndbd, and you should consult + , for additional + information about running MySQL Cluster data nodes that apply + to both the single-threaded and multi-threaded versions of the + data node process. + + + + Command-line options and configuration parameters used with + ndbd also apply to + ndbmtd. For more information about these + options and parameters, see + , and + , respectively. + + + + Using ndbmtd differs from using + ndbd in two key respects: + + + + + + + You must set an appropriate value for the + MaxNoOfExecutionThreads configuration + parameter in the config.ini file. + + + + + + Trace files are generated by critical errors in + ndbmtd processes in a somewhat + different fashion from how these are generated by + ndbd failures. + + + + + + + ndbmtd + MaxNoOfExecutionThreads + + + + MaxNoOfExecutionThreads + ndbmtd + + + + ndbmtd + trace files + + + + trace files + ndbmtd + + + + + Number of execution threads + + + The MaxNoOfExecutionThreads configuration + parameter is used to determine the number of execution + threads spawned by ndbmtd. Although this + parameter is set in [ndbd] or + [ndbd default] sections of the + config.ini file, it is exclusive to + ndbmtd and does not apply to + ndbd. + + + + + + This parameter takes an integer value from 2 to 8 inclusive. + Generally, you should set this to the number of CPU cores on + the data node host, as shown in the following table: + + + + + + + + + Number of Cores + Recommended MaxNoOfExecutionThreads Value + + + + + 2 + 2 + + + 4 + 4 + + + 8 or more + 8 + + + + + + + It is possible to set this parameter to other values, but + these are automatically rounded as follows: + + + + + + + + + config.ini Value + Value Used + + + + + 3 + 2 + + + 5 or 6 + 4 + + + 7 + 8 + + + + + + + Setting this parameter outside the permitted range of values + causes the management server to abort on startup with the + error Error line number: + Illegal value value for parameter + MaxNoOfExecutionThreads. + + + + + In MySQL Cluster NDB 6.4.0, it is not possible to set + MaxNoOfExecution threads to 2. You can + safely use the value 3 instead (it is treated as 2 + internally). This issue is resolved in MySQL Cluster NDB + 6.4.1. + + + + + MySQL Cluster + log files + + + + log files (MySQL Cluster) + ndbmtd + + + + ndbmtd + trace files + + + + Like ndbd, ndbmtd + generates a set of log files which are placed in the directory + specified by DataDir in the + config.ini configuration file. Except for + trace files, these are generated in the same way and have the + same names as those generated by ndbd. + + + + In the event of a critical error, ndbmtd + generates trace files describing what happened just prior to + the error' occurrence. These files, which can be found in + the data node's DataDir, are useful + for analysis of problems by the MySQL Cluster Development and + Support teams. One trace file is generated for each + ndbmtd thread. The names of these files + follow the pattern + ndb_node_id_trace.log.trace_id_tthread_id, + where node_id is the data + node's unique node ID in the cluster, + trace_id is a trace sequence + number, and thread_id is the thread + ID. For example, in the event of the failure of an + ndbmtd process running as a MySQL Cluster + data node having the node ID 3 and with + MaxNoOfExecutionThreads equal to 4, four + trace files are generated in the data node's data + directory; if the is the first time this node has failed, then + these files are named + ndb_3_trace.log.1_t1, + ndb_3_trace.log.1_t2, + ndb_3_trace.log.1_t3, and + ndb_3_trace.log.1_t4. Internally, these + trace files follow the same format as ndbd + trace files. + + + + The ndbd exit codes and messages that are + generated when a data node process shuts down prematurely are + also used by ndbmtd. See + , for a listing of these. + + + + + + +
+
fake title for ndb_mgmd man page section wrapper @@ -1047,7 +1340,8 @@
- Command Options for <command>ndbd</command> + Command Options for <command>ndbd</command> and + <command>ndbmtd</command> MySQL Cluster @@ -1065,12 +1359,39 @@ + command options (MySQL Cluster) + ndbmtd + + + MySQL Cluster ndbd process + + MySQL Cluster + ndbmtd process + + - For options common to all NDB programs, see + This section describes command options specific to the MySQL + Cluster data node program ndbd. + + + + + All of these options also apply to the multi-threaded version + of this program — ndbmtd, which is + available beginning with MySQL Cluster NDB 6.4.0 — and + you may substitute ndbmtd + for ndbd wherever the latter + occurs in this section. + + + + + For options common to all + NDBCLUSTER programs, see . @@ -1110,6 +1431,10 @@ --initial option (ndbd) + + --initial option (ndbmtd) + + @@ -1197,6 +1522,10 @@ --initial-start option (ndbd) + + --initial-start option (ndbmtd) + + @@ -1238,6 +1567,10 @@ --nowait-nodes option (ndbd) + + --nowait-nodes option (ndbmtd) + + @@ -1280,6 +1613,10 @@ --nodaemon option (ndbd) + + --nodaemon option (ndbmtd) + + @@ -1301,6 +1638,14 @@ -n option (ndbd) + + --nostart option (ndbmtd) + + + + -n option (ndbmtd) + + , Modified: trunk/refman-5.1/mysql-cluster-roadmap.xml =================================================================== --- trunk/refman-5.1/mysql-cluster-roadmap.xml 2009-01-09 18:57:39 UTC (rev 13077) +++ trunk/refman-5.1/mysql-cluster-roadmap.xml 2009-01-09 19:05:19 UTC (rev 13078) Changed blocks: 1, Lines Added: 5, Lines Deleted: 6; 1222 bytes @@ -1373,12 +1373,11 @@ A multithreaded version of the data node daemon, ndbmtd, is available for use on data node - hosts with multiple cores/CPUs. New configuration parameters - are available for optimizing ndbmtd - usage; for example, it is possible to locking specific data - node processes to specific cores/CPUs. In all other major - respects, ndbmtd functions the same as - ndbd. + hosts with multiple CPU cores. In most respects, + ndbmtd functions in the same way as + ndbd, and can use the same command-line + options and configuration parameters. For more information, + see . Modified: trunk/refman-5.1-maria/Makefile.depends =================================================================== --- trunk/refman-5.1-maria/Makefile.depends 2009-01-09 18:57:39 UTC (rev 13077) +++ trunk/refman-5.1-maria/Makefile.depends 2009-01-09 19:05:19 UTC (rev 13078) Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 731 bytes @@ -248,6 +248,7 @@ ../mysql-monitor-2.0/../common/phrases.ent \ ../mysql-monitor-2.0/../dynamic-docs/changelog/monitor-versions.xml \ ../mysql-monitor-2.0/../dynamic-docs/changelog/monitor.xml \ + ../mysql-monitor-2.0/../dynamic-docs/faq/monitor.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-advisors.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-configure.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-events.xml \ Modified: trunk/refman-6.0/Makefile.depends =================================================================== --- trunk/refman-6.0/Makefile.depends 2009-01-09 18:57:39 UTC (rev 13077) +++ trunk/refman-6.0/Makefile.depends 2009-01-09 19:05:19 UTC (rev 13078) Changed blocks: 3, Lines Added: 2, Lines Deleted: 1; 1533 bytes @@ -1168,7 +1168,6 @@ ../refman-6.0/metadata/dba-mysqld-server-core.idmap \ ../refman-6.0/metadata/errors-problems.idmap \ ../refman-6.0/metadata/programs-using.idmap \ - ../refman-6.0/metadata/replication-options-core.idmap \ ../refman-6.0/metadata/se-innodb-core.idmap \ ../refman-6.0/metadata/sql-syntax-data-definition.idmap \ ../refman-6.0/metadata/sql-syntax-data-manipulation.idmap \ @@ -1610,6 +1609,7 @@ ../dynamic-docs/opsfunctions/opfunctions.xml \ ../mysql-monitor-2.0/../common/fixedchars.ent \ ../mysql-monitor-2.0/../common/phrases.ent \ + ../mysql-monitor-2.0/../dynamic-docs/faq/monitor.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-advisors.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-configure.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-events.xml \ @@ -2217,6 +2217,7 @@ ../mysql-monitor-2.0/../common/phrases.ent \ ../mysql-monitor-2.0/../dynamic-docs/changelog/monitor-versions.xml \ ../mysql-monitor-2.0/../dynamic-docs/changelog/monitor.xml \ + ../mysql-monitor-2.0/../dynamic-docs/faq/monitor.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-advisors.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-configure.xml \ ../mysql-monitor-2.0/../mysql-monitor-2.0/dashboard-events.xml \