Author: jstephens
Date: 2007-09-07 17:46:05 +0200 (Fri, 07 Sep 2007)
New Revision: 7753
Log:
Documented Telco bugfixes:
Bug #26793, Bug #29228, Bug #28683
Includes changes to ndb_size.pl in telco 6.2.3.
Modified:
trunk/refman-5.1/mysql-cluster.xml
trunk/refman-5.1/news-5.1.xml
Modified: trunk/refman-5.1/mysql-cluster.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster.xml 2007-09-07 13:46:35 UTC (rev 7752)
+++ trunk/refman-5.1/mysql-cluster.xml 2007-09-07 15:46:05 UTC (rev 7753)
Changed blocks: 2, Lines Added: 160, Lines Deleted: 28; 9506 bytes
@@ -18507,8 +18507,8 @@
The <literal>DBI</literal> module, which can be obtained
from CPAN if it is not already part of your Perl
installation. (Many Linux and other operating system
- distributions provide their own packages for one or both
- of this library.)
+ distributions provide their own packages for this
+ library.)
</para>
<note>
@@ -18591,41 +18591,173 @@
<para>
The output from this script includes:
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ Minimum values for the <literal>DataMemory</literal>,
+ <literal>IndexMemory</literal>,
+ <literal>MaxNoOfTables</literal>,
+ <literal>MaxNoOfAttributes</literal>,
+ <literal>MaxNoOfOrderedIndexes</literal>,
+ <literal>MaxNoOfUniqueHashIndexes</literal>, and
+ <literal>MaxNoOfTriggers</literal> configuration
+ parameters required to accommodate the tables
+ analysed.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Memory requirements for all of the tables, attributes,
+ ordered indexes, and unique hash indexes defined in
+ the database.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ The <literal>IndexMemory</literal> and
+ <literal>DataMemory</literal> required per table and
+ table row.
+ </para>
+ </listitem>
+
+ </itemizedlist>
</para>
+
+ &mccge-warning-begin;
+ <para>
+ Beginning with MySQL 5.1.22-ndb-6.2.5, the behavior of this
+ utility and its available options have changed. Typical
+ usage is shown here:
- <itemizedlist>
+<programlisting>
+ndb_size.pl [--database=<replaceable>db_name</replaceable>|ALL] [--hostname=<replaceable>host</replaceable>[:<replaceable>port</replaceable>]] [--socket=<replaceable>socket</replaceable>] [--user=<replaceable>user</replaceable>] [--password=<replaceable>password</replaceable>] [--help|-h] [--format=(html|text)] [--loadqueries=<replaceable>file</replaceable>] [--savequeries=<replaceable>file</replaceable>]
+</programlisting>
- <listitem>
+ <important>
<para>
- Minimum values for the <literal>DataMemory</literal>,
- <literal>IndexMemory</literal>,
- <literal>MaxNoOfTables</literal>,
- <literal>MaxNoOfAttributes</literal>,
- <literal>MaxNoOfOrderedIndexes</literal>,
- <literal>MaxNoOfUniqueHashIndexes</literal>, and
- <literal>MaxNoOfTriggers</literal> configuration
- parameters required to accommodate the tables analysed.
+ <command>ndb_size.pl</command> now takes named options,
+ each of which is optional.
</para>
- </listitem>
+ </important>
+ </para>
- <listitem>
- <para>
- Memory requirements for all of the tables, attributes,
- ordered indexes, and unique hash indexes defined in the
- database.
- </para>
- </listitem>
+ <para>
+ By default, this utility attempts to analyze all databases
+ on the server. You can specify a single database using the
+ <option>--database</option> option; the default behavior can
+ be made explicit by using <literal>ALL</literal> for the
+ name of the database. You can also exclude one or more
+ databases by using the <option>--excludedbs</option> with a
+ comma-separated list of the names of the databases to be
+ skipped. Similarly, you can cause specific tables to be
+ skipped by listing their names, separated by commas,
+ following the optional <option>--excludetables</option>
+ option. A hostname (and possibly a port as well) can be
+ specified using <option>--hostname</option>; the default is
+ <literal>localhost:3306</literal>. If necessary, you can
+ specify a socket; the default is
+ <filename>/var/lib/mysql.sock</filename>. A MySQL username
+ and password can be specified the corresponding options
+ shown. It also possible to control the format of the output
+ using the <option>--format</option> option; this can take
+ either of the values <literal>html</literal> or
+ <literal>text</literal>, with <literal>text</literal> being
+ the default. An example of the text output is shown here:
- <listitem>
- <para>
- The <literal>IndexMemory</literal> and
- <literal>DataMemory</literal> required per table and
- table row.
- </para>
- </listitem>
+<programlisting>
+shell> <userinput>ndb_size.pl --database=test --socket=/tmp/mysql.sock</userinput>
+ndb_size.pl report for database: 'test' (1 tables)
+--------------------------------------------------
+Connected to: DBI:mysql:host=localhost;mysql_socket=/tmp/mysql.sock
- </itemizedlist>
+Including information for versions: 4.1, 5.0, 5.1
+test.t1
+-------
+
+DataMemory for Columns (* means varsized DataMemory):
+ Column Name Type Varsized Key 4.1 5.0 5.1
+ HIDDEN_NDB_PKEY bigint PRI 8 8 8
+ c2 varchar(50) Y 52 52 4*
+ c1 int(11) 4 4 4
+ -- -- --
+Fixed Size Columns DM/Row 64 64 12
+ Varsize Columns DM/Row 0 0 4
+
+
+DataMemory for Indexes:
+ Index Name Type 4.1 5.0 5.1
+ PRIMARY BTREE 16 16 16
+ -- -- --
+ Total Index DM/Row 16 16 16
+
+
+
+IndexMemory for Indexes:
+ Index Name 4.1 5.0 5.1
+ PRIMARY 33 16 16
+ -- -- --
+ Indexes IM/Row 33 16 16
+
+
+
+Summary (for THIS table):
+ 4.1 5.0 5.1
+ Fixed Overhead DM/Row 12 12 16
+ NULL Bytes/Row 4 4 4
+ DataMemory/Row 96 96 48 (Includes overhead, bitmap and indexes)
+
+ Varsize Overhead DM/Row 0 0 8
+ Varsize NULL Bytes/Row 0 0 4
+ Avg Varside DM/Row 0 0 16
+
+ No. Rows 0 0 0
+
+ Rows/32kb DM Page 340 340 680
+Fixedsize DataMemory (KB) 0 0 0
+
+Rows/32kb Varsize DM Page 0 0 2040
+ Varsize DataMemory (KB) 0 0 0
+
+ Rows/8kb IM Page 248 512 512
+ IndexMemory (KB) 0 0 0
+
+
+
+
+
+Parameter Minimum Requirements
+------------------------------
+* indicates greater than default
+
+ Parameter Default 4.1 5.0 5.1
+ DataMemory (KB) 81920 0 0 0
+ NoOfOrderedIndexes 128 1 1 1
+ NoOfTables 128 1 1 1
+ IndexMemory (KB) 18432 0 0 0
+ NoOfUniqueHashIndexes 64 0 0 0
+ NoOfAttributes 1000 3 3 3
+ NoOfTriggers 768 5 5 5
+</programlisting>
+ </para>
+
+ <para>
+ For debugging purposes, the Perl arrays containing the
+ queries run by this script can be read from the file
+ specified using can be saved to a file using
+ <option>--savequeries</option>; a file containing such
+ arrays to be read in during script execution can be
+ specified using <option>--loadqueries</option>. Neither of
+ these options has a default value.
+ </para>
+
+
+ &mccge-warning-end-cluster;
+
</refsection>
</refentry>
Modified: trunk/refman-5.1/news-5.1.xml
===================================================================
--- trunk/refman-5.1/news-5.1.xml 2007-09-07 13:46:35 UTC (rev 7752)
+++ trunk/refman-5.1/news-5.1.xml 2007-09-07 15:46:05 UTC (rev 7753)
Changed blocks: 4, Lines Added: 80, Lines Deleted: 11; 4425 bytes
@@ -535,18 +535,13 @@
<section id="news-5-1-22-ndb-6-2-5">
- <title>Changes in release MySQL 5.1.22-ndb-6.2.5-beta (Not yet released)</title>
+ <title>Changes in release MySQL 5.1.22-ndb-6.2.5-beta (06 September 2007)</title>
<para role="release-level">
This is a new Beta development release, fixing recently
discovered bugs.
</para>
- <remark role="TODO">
- [js] Uncomment next para following release.
- </remark>
-
-<!--
<para>
Like all releases for &mccge-series;, this is a source-only
release which you must compile and install using the
@@ -554,12 +549,11 @@
in <xref linkend="mysql-cluster-building"/>. You can download
the source code archive for this release from the MySQL FTP site
at
- <ulink url="ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.19-ndb-6.2.5"/>.
+ <ulink url="ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.22-ndb-6.2.5"/>.
The file
- <filename>mysqlcom-5.1.19-ndb-6.2.5-telco.tar.gz</filename> in
+ <filename>mysqlcom-5.1.22-ndb-6.2.5-telco.tar.gz</filename> in
this directory contains the complete source archive.
</para>
--->
<para role="release-non-production">
<emphasis role="bold">NOTE</emphasis>: Although MySQL has worked
@@ -642,9 +636,72 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ The following improvements have been made in the
+ <command>ndb_size.pl</command> utility:
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ Added the ability to run on multiple databases, and to
+ exclude lists of databases and tables from analysis.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Added schema name information to index table
+ calculations.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Made the database name an optional parameter, the
+ exclusion of which causes all databases to be
+ examined.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ If selecting from
+ <literal>INFORMATION_SCHEMA</literal> fails, the
+ script attempt to fall back to <literal>SHOW
+ TABLES</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Added support for a <option>real_table_name</option>
+ option to designate a table to handle unique index
+ size calculations.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Amended report title to cover cases where more than
+ one database is being analyzed.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ (Bug #28683)
+ </para>
+
+ <para>
+ For more information, see
+ <xref linkend="mysql-cluster-utilities-ndb-size"/>.
+ </para>
+ </listitem>
+
</itemizedlist>
-<!--
<para>
This release fixes the following bugs:
</para>
@@ -653,12 +710,24 @@
<listitem>
<para>
+ An attempt to perform a <literal>SELECT ... FROM
+ INFORMATION_SCHEMA.TABLES</literal> whose result included
+ information about <literal>NDB</literal> tables for which
+ the user had no privileges could crash the MySQL Server on
+ which the query was performed. (Bug #26793)
</para>
</listitem>
+ <listitem>
+ <para>
+ <command>ndb_size.pl</command> failed on tables with
+ <literal>FLOAT</literal> columns whose definitions included
+ commas (for example, <literal>FLOAT(6,2)</literal>). (Bug
+ #29228)
+ </para>
+ </listitem>
</itemizedlist>
--->
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r7753 - trunk/refman-5.1 | jon | 7 Sep |
