I recently moved to a new web server (running 5.5.32) on one of my production systems. The new server has more RAM, faster CPU, etc so we see queried results a lot quicker. However, with basically the default my.cnf config file on each system, we see simple inserts taking about 10x longer than on the old system.
An example are simple inserts to the following InnoDB table: CREATE TABLE `test` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `num` int(10) unsigned DEFAULT NULL, `id_two` int(10) unsigned NOT NULL, `start` decimal(17,8) DEFAULT NULL, `stop` decimal(17,8) DEFAULT NULL, `length` int(10) unsigned DEFAULT NULL, UNIQUE KEY `ID` (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; One of our production systems creates ~3-8 thousand simple inserts to this table like: INSERT INTO `test` (`ID`, `num`, `id_two`, `start`, `stop`, `length`) VALUES (1,33602184,11172955,56617.02777778,56617.05347222,2220); Sending all of these on the old system takes 5-20 seconds, but writes to the new server can take nearly 10 minutes. Both systems are running on nearly the default my.cnf files from the mysql installs. I’ve even altered the newer my.cnf file to match what was on our old server with no change in the results. I’ve also allocated more RAM to InnoDB with also no change in insert time. I’m not sure what to try looking at next. Does anybody have any ideas? Cheers, Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql