Bug #13039 Highest possible valuse for MaximMaxNoOfTables option is 1599

• Submitted: 7 Sep 2005 13:48
• Modified: 8 Sep 2005 13:53
• Reporter: Serge Kozlov
• Status: Not a Bug
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 5.0.11-max
• OS: Linux (Mandrake Linux 10)
• CPU Architecture: Any

[7 Sep 2005 13:48] Serge Kozlov

Description:
I add 'MaxNoOfTables=1600' option to '[ndb default]' section and run a testcase
which try to create 1600 tables. But 1599 tables were created only. Last attepmt produces error errno 135.

How to repeat:
1. Add or change following options to '[ndb default]' section in
ndb/ndb_config_2_node.ini
DataMemory=500M
MaxNoOfAttributes=30000
MaxNoOfTables=1600

2. Create short testcase like following:

--source include/have_ndb.inc
--source include/not_embedded.inc
--disable_warnings
let $2 = 1599;
let $1 = $2;
while ($1)
{
    eval DROP TABLE IF EXISTS test.t$1;
    dec $1;
}
--enable_warnings
let $1 = $2;
while ($1)
{
    eval CREATE TABLE test.t$1 (a CHAR(1)) ENGINE=NDB;
    dec $1;
}
--disable_warnings
let $1 = $2;
while ($1)
{
    eval DROP TABLE IF EXISTS test.t$1;
    dec $1;
}
--enable_warnings

3. Run it

[7 Sep 2005 14:23] Serge Kozlov

The MaxNoOfAttributes should be corrected: MaxNoOfAttributes=20000

[8 Sep 2005 13:53] Hartmut Holzgraefe

http://dev.mysql.com/doc/mysql/en/mysql-cluster-limitations-in-4-1.html

The maximum number of metadata objects is limited to 1600, including database tables, system tables, indexes and BLOBs.