Re: MyISAM not scaling well
Posted by:
Rick James
Date: November 13, 2010 12:55AM
* See the note on cores in
http://mysql.rjweb.org/doc.php/memory
* Consider using InnoDB -- it has row locking, not table locking.
* What are the actual queries? (I don't understand "forward queries in a flow style".) Also, please show us SHOW CREATE TABLE foo; Also, SHOW TABLE STATUS.
* How many queries per second?
* Do you have one instance of MySQL on one server? Are the clients all hitting that machine?
* Do the clients connect & disconnect for each forwarding?
* 20% of 16 cores is ~3 core's worth. That seem very high.
Subject
Views
Written By
Posted
4013
November 09, 2010 11:08AM
Re: MyISAM not scaling well
1718
November 13, 2010 12:55AM
1697
November 15, 2010 05:29AM
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.