Hi Jeremy,
My follow-up for this answer from the other list was:
----------------
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...
----------------
I may have posted the same question here, earlier. I'd appreciate any input.
Thanks,
--jeff
----- Original Message -----
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Jeff Kilbride" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, March 02, 2002 7:11 PM
Subject: Re: InnoDB frightens me...
> 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
>
---------------------------------------------------------------------
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
