Re: MyISAM not scaling well
Posted by:
Rick James
Date: November 16, 2010 01:07AM
What do you see in SHOW PROCESSLIST when doing the stress test?
Multiple instances hitting the same data files? Ouch. That means inter-process locking; not cheap. Or data corruption.
Yes, locking (key_buffer and optionally the query_cache) are issues.
Do you have the Query cache ON? Is it useful? Consider OFF.
Suggest instrumenting your thread clients with a timer to time the MySQL calls versus other thread time. PHP: microtime(true); Perl: Time:HiRes.
Subject
Views
Written By
Posted
4013
November 09, 2010 11:08AM
1719
November 13, 2010 12:55AM
1697
November 15, 2010 05:29AM
Re: MyISAM not scaling well
1663
November 16, 2010 01:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.