: "DuffMan" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 24, 2003 5:07 AM
Subject: Poor InnoDB Performance
> I converted 3 of 30 MyISAM tables to InnoDB. Since
> then I have been constantly reaching my limit of 100
> connections because Selects on the
I converted 3 of 30 MyISAM tables to InnoDB. Since
then I have been constantly reaching my limit of 100
connections because Selects on the InnoDB tables are
slow.
If I cut off traffic and execute a SELECT, it takes
less than 0.01 seconds. If a execute the exact same
query again with traffic, it ta
