0

I would like to know if anyone has personally benchmarked the new InnoDB with large data sets.

I don't use the latest version but I have implemented ISAM tables with over 20 million records. It's well indexed and I am able to pick out on a given condition, about 10K records in less than 10 seconds. But my issue is that it won't do to good with new inserts since the index has to be rebuilt.

I read that the new InnoDB engine is really fast with ACID Transactions.

BTW, the DB is going to be constantly read by many users and also new entries may coming in frequently.

Has anyone really tried this?

itsols
  • 5,406
  • 7
  • 51
  • 95

2 Answers2

3

I've never used the innodb plugin as I've always found the standard innodb engine to be perfectly perfomant, especially for reads. Not sure why people think myisam is more performant than innodb - it's a conundrum wrapped in an enigma.

Previous answers

More interesting stuff

Community
  • 1
  • 1
Jon Black
  • 16,223
  • 5
  • 43
  • 42
  • As of mysql 5.5, InnoDB is the default. It's not a plugin. Further, before the SUN takeover of MySQL, I was in the presence of the co-founder of MySQL, David Axmark during his visit. Then ISAM was the way to go for large, read-only DBs. This is why wanted to know if anyone has had first-hand exposure to this matter. And looking at the stats you've given, I guess InnoDB makes sense now :) Thanks! – itsols Jun 11 '11 at 15:36
  • yea misred his question thought he was talking about the innodb plugin which is a replacement for the standard innodb engine. http://code.openark.org/blog/mysql/reasons-to-use-innodb-plugin Neverthless, my answer is standard innodb engine related :) – Jon Black Jun 11 '11 at 16:02
  • How to create a `InnoDB` plugin for `MySQL` 5.5? – Jerry Mar 31 '14 at 12:05
1

Percona just had a session on InnoDB in 5.5 at their last seminar. You can download the slides for "Migrating From MyISAM to InnoDB" here (http://www.percona.com/live/nyc-2011/schedule/sessions/).

They have fixed a lot of things in 5.5 that increase performance and resolve a lot of issues so it can better take advantage of the hardware. Performance is still highly reliant on memory allocation though.

Brent Baisley
  • 12,641
  • 2
  • 26
  • 39
  • Thanks for sharing. I've seen the white paper myself (released today). But I was more keen on first hand experiences. +1 for your slides link. – itsols Jun 11 '11 at 15:38