MySQL Bugs: #28683: ndb_size.pl should support more than one database

Bug #28683	ndb_size.pl should support more than one database
Submitted:	25 May 2007 21:01	Modified:	15 Sep 2007 13:21
Reporter:	Monty Taylor
Status:	Closed
Category:	Server: Cluster	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Any
Assigned to:	Bugs System	Target Version:

Description:
I'm at a client who needs to assess the suitability of cluster, but they have 26 different
schemas, making the ndb_size.pl tool rather unwieldy. ndb_size.pl should support both the
ability to run against more than one db and the ability to specify tables to skip. 

How to repeat:
Run ndb_size.pl. It requires a database as an argument. 

Suggested fix:
I've got a patch I'll commit in just a bit.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/27358

ChangeSet@1.2504, 2007-05-25 12:05:48-07:00, mtaylor@qualinost.(none) +1 -0
  BUG#28683 - ndb_size.pl should support more than one database
  Added the ability to run ndb_size.pl on mulitple databases and also to exclude lists of
databases and tables from analysis.
  ---
  Added schema name information to index table calculations as well.
  ---
  Made database an optional parameter, the exclusion of which causes all databases to be
examined.
  If selecting from information_schema fails, attempt to fall back to show tables from
  ---
  Added support for setting an optional "real_table_name" for a table to deal with unique
indexe size calcs.
  ---
  Fixed report title for the case where we are using operating on more than one database.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/27372

ChangeSet@1.2504, 2007-05-25 13:45:46-07:00, mtaylor@qualinost.(none) +1 -0
  BUG#28683 - ndb_size.pl should support more than one database
  Added the ability to run ndb_size.pl on mulitple databases and also to exclude lists of
databases and tables from analysis.
  ---
  Added schema name information to index table calculations as well.
  ---
  Made database an optional parameter, the exclusion of which causes all databases to be
examined.
  If selecting from information_schema fails, attempt to fall back to show tables from
  ---
  Added support for setting an optional "real_table_name" for a table to deal with unique
indexe size calcs.
  ---
  Fixed report title for the case where we are using operating on more than one database.
  ---
  Fixed some perl style concerns timothy had. 
  Cull the list of databases in perl rather than passing both an in and a not in list to
MySQL
  Get this full list of databases from show databases if needed.

looks good to me. ok to push.

fixed up a few small things and pushed to 5.1-ndb

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/32536

ChangeSet@1.2579, 2007-08-15 12:12:31+10:00, stewart@flamingspork.com +1 -0
  [PATCH] BUG#28683 - ndb_size.pl should support more than one database
  
  Patch by: Monty Taylor <mtaylor@mysql.com>
  Fixes by: Stewart Smith
  
    Added the ability to run ndb_size.pl on mulitple databases and also to exclude lists
of databases and tables from analysis.
    ---
    Added schema name information to index table calculations as well.
    ---
    Made database an optional parameter, the exclusion of which causes all databases to be
examined.
    If selecting from information_schema fails, attempt to fall back to show tables from
    ---
    Added support for setting an optional "real_table_name" for a table to deal with
unique indexe size calcs.
    ---
    Fixed report title for the case where we are using operating on more than one
database.
    ---
    Fixed some perl style concerns timothy had.
    Cull the list of databases in perl rather than passing both an in and a not in list to
MySQL
    Get this full list of databases from show databases if needed.
  
    storage/ndb/tools/ndb_size.pl@stripped, 2007-05-25 13:45:44-07:00,
mtaylor@qualinost.(none) +102 -28
      Added the ability to run ndb_size.pl on mulitple databases and also to exclude lists
of databases and tables from analysis.
      ---
      Added schema name information to index table calculations as well.
      ---
      Made database an optional parameter, the exclusion of which causes all databases to
be examined.
      If selecting from information_schema fails, attempt to fall back to show tables from
      ---
      Added support for setting an optional "real_table_name" for a table to deal with
unique indexe size calcs.
      ---
      Fixed report title for the case where we are using operating on more than one
database.
      ---
      Fixed some perl style concerns timothy had. 
      Cull the list of databases in perl rather than passing both an in and a not in list
to MySQL
      Get this full list of databases from show databases if needed.
  
  Index: ndb-work/storage/ndb/tools/ndb_size.pl
  ===================================================================

Documented in mysql-5.1.22-ndb-6.2.5 changelog and mysql-cluster-utilities-ndb-size
section of 5.1 Cluster chapter.

Left status as PQ.

See also Bug #30903.

Pushed into 5.1.23-beta

Thank you for your bug report. This issue has been committed to our source repository of
that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version,
including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Also documented in 5.1.23 changelog; updated description in Cluster chapter of Manual.