From: jon
Date: September 7 2007 3:46pm
Subject: svn commit - mysqldoc@docsrva: r7753 - trunk/refman-5.1
List-Archive: http://lists.mysql.com/commits/33914
Message-Id: <200709071546.l87FkCUw000817@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
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 DBI 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.)
@@ -18591,41 +18591,173 @@
The output from this script includes:
+
+
+
+
+
+ Minimum values for the DataMemory,
+ IndexMemory,
+ MaxNoOfTables,
+ MaxNoOfAttributes,
+ MaxNoOfOrderedIndexes,
+ MaxNoOfUniqueHashIndexes, and
+ MaxNoOfTriggers configuration
+ parameters required to accommodate the tables
+ analysed.
+
+
+
+
+
+ Memory requirements for all of the tables, attributes,
+ ordered indexes, and unique hash indexes defined in
+ the database.
+
+
+
+
+
+ The IndexMemory and
+ DataMemory required per table and
+ table row.
+
+
+
+
+
+ &mccge-warning-begin;
+
+ 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:
-
+
+ndb_size.pl [--database=db_name|ALL] [--hostname=host[:port]] [--socket=socket] [--user=user] [--password=password] [--help|-h] [--format=(html|text)] [--loadqueries=file] [--savequeries=file]
+
-
+
- Minimum values for the DataMemory,
- IndexMemory,
- MaxNoOfTables,
- MaxNoOfAttributes,
- MaxNoOfOrderedIndexes,
- MaxNoOfUniqueHashIndexes, and
- MaxNoOfTriggers configuration
- parameters required to accommodate the tables analysed.
+ ndb_size.pl now takes named options,
+ each of which is optional.
-
+
+
-
-
- Memory requirements for all of the tables, attributes,
- ordered indexes, and unique hash indexes defined in the
- database.
-
-
+
+ By default, this utility attempts to analyze all databases
+ on the server. You can specify a single database using the
+ option; the default behavior can
+ be made explicit by using ALL for the
+ name of the database. You can also exclude one or more
+ databases by using the 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. A hostname (and possibly a port as well) can be
+ specified using ; the default is
+ localhost:3306. If necessary, you can
+ specify a socket; the default is
+ /var/lib/mysql.sock. 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; this can take
+ either of the values html or
+ text, with text being
+ the default. An example of the text output is shown here:
-
-
- The IndexMemory and
- DataMemory required per table and
- table row.
-
-
+
+shell> ndb_size.pl --database=test --socket=/tmp/mysql.sock
+ndb_size.pl report for database: 'test' (1 tables)
+--------------------------------------------------
+Connected to: DBI:mysql:host=localhost;mysql_socket=/tmp/mysql.sock
-
+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
+
+
+
+
+ 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
+ ; a file containing such
+ arrays to be read in during script execution can be
+ specified using . Neither of
+ these options has a default value.
+
+
+
+ &mccge-warning-end-cluster;
+
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 @@
- Changes in release MySQL 5.1.22-ndb-6.2.5-beta (Not yet released)
+ Changes in release MySQL 5.1.22-ndb-6.2.5-beta (06 September 2007)
This is a new Beta development release, fixing recently
discovered bugs.
-
- [js] Uncomment next para following release.
-
-
-
NOTE: Although MySQL has worked
@@ -642,9 +636,72 @@
+
+
+ The following improvements have been made in the
+ ndb_size.pl utility:
+
+
+
+
+
+ Added the ability to run on multiple databases, and to
+ exclude lists of databases and tables from analysis.
+
+
+
+
+
+ Added schema name information to index table
+ calculations.
+
+
+
+
+
+ Made the database name an optional parameter, the
+ exclusion of which causes all databases to be
+ examined.
+
+
+
+
+
+ If selecting from
+ INFORMATION_SCHEMA fails, the
+ script attempt to fall back to SHOW
+ TABLES.
+
+
+
+
+
+ Added support for a
+ option to designate a table to handle unique index
+ size calculations.
+
+
+
+
+
+ Amended report title to cover cases where more than
+ one database is being analyzed.
+
+
+
+
+
+ (Bug #28683)
+
+
+
+ For more information, see
+ .
+
+
+
-