On Sat, Mar 02, 2002 at 06:52:57PM -0800, Jeff Kilbride wrote: > I'm looking to make the move to InnoDB, too. All I've heard is positve. > Here's a reply I got on another list: > > -------------------- > If you have a very busy read/write op database, MyISAM can't handle > it. It's very efficient for when you have many more reads than > writes, but once you start hitting a balance between the two and > then get some load, MyISAM just locks up. It's just known. > Table-level locks lead to lengthy delays.
And from what I've seen, things start to get problematic with MyISAM when the percentage of read-only queries drops below about 70% or so. 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 23 days, processed 765,311,906 queries (376/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