At 9:40 -0500 9/23/02, Dana Diederich wrote: >Perhaps the InnoDB/MyISAM gurus can comment on this. I want to switch from >MyISAM to Innodb, because we have database tables that have many updates, >inserts, deletes and selects going on at the same time. My belief is that >InnoDB's better locking semantics (as compared to MyISAM) will give me >better overall performance in such a high contention environment. For >example, each update won't block other updates or selects or deletes. > >Is this a fair assumption?
Yes. InnoDB's row-level locking fares better when your query mix contains many updates, rather than just a lot of selects. MyISAM tables use table-level locking, which works well for a mix of selects, but degrades when you start throwing updates into the mix. > Honestly, the 'other' features of InnoDB >(transactions and reliability) aren't as important to me as overall speed. > >Cheers. >-Dana --------------------------------------------------------------------- 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