Author Topic: Best performance with which MYSQL?  (Read 588 times)

hugelsb

  • EA Novice
  • *
  • Posts: 15
  • Karma: +0/-0
  • Modelling is the future!
    • View Profile
Best performance with which MYSQL?
« on: October 27, 2011, 06:39:08 pm »
We are starting to use MySQL as EA repository.
Which MYSQL MyISAM or InnoDB has the best performance?
Which DB parameter configuration you are recommending?

Thanks a lot for your help.
Beat

qwerty

  • EA Guru
  • *****
  • Posts: 9202
  • Karma: +140/-131
  • I'm no guru at all
    • View Profile
Re: Best performance with which MYSQL?
« Reply #1 on: October 28, 2011, 04:55:53 am »
I've never made performance checks for MySQL tuning. But just recently I compared our Linux-box-MySQL against a fat MS Sql Server. There wasn't any noticeable difference between both. So you can go with the default settings (which is InnoDB).

q.