Thanks. I just saw the benchmark that InnoDB has on their site: http://www.innodb.com/bench.html
and I was fairly surprised by the speed difference between InnoDB and MyISAM when it comes to concurrent inserts/selects. I thought the new feature of MyISAM tables being able to do simultaneous inserts/selects would be faster than this benchmark claims. Does replication hurt MyISAM performance in the same way? If I'm running a master that takes all the inserts and one or more slaves to take all the select queries, would it be better implemented in MyISAM or InnoDB? I don't need the transaction ability of InnoDB, but if concurrent replication affects MyISAM performance in the same way as concurrent insert/select ops, it makes me wonder which table type I should use on my high insert activity tables. My assumption was MyISAM, but I'm not so sure now... Thanks, --jeff P.S. -- I saw your signature, so I'm picking your brain! :) ----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Jeff Kilbride" <[EMAIL PROTECTED]> Cc: "MySQL" <[EMAIL PROTECTED]> Sent: Friday, March 01, 2002 2:15 PM Subject: Re: Re-baselining replication slaves? > On Fri, Mar 01, 2002 at 01:21:52PM -0800, Jeff Kilbride wrote: > > Hi Jeremy, > > > > Just out of curiosity, what kind of tables are you using on your > > production system? MyISAM, InnoDB, a mix of the two, etc... > > We're 100% MyISAM right now, but are building some new things on > InnoDB. Based on data volume, it'll probably end up being 80-90% > MyISAM still, but based on queries, it'll probably be around 60% or so > hitting MyISAM tables. > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.47-max: up 22 days, processed 710,555,716 queries (368/sec. avg) > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
