We're probably 98 percent selects. But that's part of the problem: the
selects build up at a fantastic rate when there are a flury of updates.
Hopefully, once we get to InnoDB, this won't be as likely to happen.
Cheers.
-Dana
> -----Original Message-----
> From: Paul DuBois [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 10:26 AM
> To: Dana Diederich; [EMAIL PROTECTED]
> Subject: RE: transactions...
>
> 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
**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to
whom they are addressed. If you have received this email
in error destroy it immediately.
**********************************************************************
Wal-Mart Stores, Inc. Confidential
**********************************************************************
---------------------------------------------------------------------
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
