So it appears I am having an issue with 4.1.13 which I'm guessing is a bug... wanted some input before I file it...

Setting up a new machine to take over for an old one, so it's clean, Operating System and some empty disks... the server does nothing other than MySQL so there are no other processes running. It has 16Gbytes of ram and the data disks are a 7 disk RAID5 array on a 2GBit/Sec Fiber Channel connection.

If I create my data directories and copy the "mysql" database from another server with a simple copy (mysql is myisam so it's no issue) I am ready to launch mysqld... When mysqld launches it of course needs to create my InnoDB data files and log files before it comes up...

I first did this under 4.1.13 Community edition and was SHOCKED by the results... one 2Gbyte shared data file for InnoDB, and 2 250Mbyte log files... what felt like an hour later it finished... Tried 4.1.13 Pro released today... same thing... Tried 4.1.12, better, still slower than I would expect, but better... let me quantify that a little. From the log files below you will see that the time to create the InnoDB files and get to the point of being ready to connect is:

MySQL 4.1.13 Pro:    54 minutes 51 seconds
MySQL 4.1.12 Standard: 4 minutes 16 seconds

While I didn't keep a 4.1.13 Standard log, it's pretty much the same as 4.1.13 Pro.

If I copy the 2Gbyte file once it is created, it can be duplicated in 22 seconds... so disk performance on it's own isn't the issue. Any Disk I/O I try and do on the machine during the hour long lock out is also degraded... copying another file for example can take a very long time... 3 minutes for a 35Mbyte directory... copying the same file after MySQL has launched takes no time at all.

I duplicated this exact same thing with another server... times don't change much here, so it doesn;t seem to be specific to this one machine.

This is all on Mac OS X 10.4.2

Best Regards, Bruce


[data-admin:/var/mysql] root# tail -f mysql.err
050722 13:51:08  mysqld started
InnoDB: The first specified data file /mysqldata/ibdata01 did not exist:
InnoDB: a new database to be created!
050722 13:51:09 InnoDB: Setting file /mysqldata/ibdata01 size to 2000 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 050722 14:34:45 InnoDB: Log file /mysqldata/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /mysqldata/ib_logfile0 size to 250 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
050722 14:40:15 InnoDB: Log file /mysqldata2/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /mysqldata2/ib_logfile1 size to 250 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050722 14:45:59  InnoDB: Started; log sequence number 0 0
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.13-pro-gpl-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Pro (GPL)


[data-admin:/var/mysql] root# tail -f mysql.err
050722 14:58:06  mysqld started
InnoDB: The first specified data file /mysqldata/ibdata01 did not exist:
InnoDB: a new database to be created!
050722 14:58:06 InnoDB: Setting file /mysqldata/ibdata01 size to 2000 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 050722 15:01:22 InnoDB: Log file /mysqldata/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /mysqldata/ib_logfile0 size to 250 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
050722 15:01:47 InnoDB: Log file /mysqldata/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /mysqldata/ib_logfile1 size to 250 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050722 15:02:22  InnoDB: Started; log sequence number 0 0
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.12-standard-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)

After MySQL finishes creating the files and is running but sitting idle, duplicating the 2Gbyte file takes 22 seconds, so it is not a disk performance issue:

[data-admin:/var/mysql] root# time cp /mysqldata/ibdata01 /mysqldata/ ibdatacopy
0.016u 5.571s 0:22.67 24.6%     0+0k 16+24io 0pf+0w


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to