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]
