Re: Performance Problem in some pCS
Posted by:
Rick James
Date: August 19, 2012 09:02PM
SHOW GLOBAL STATUS LIKE 'Innodb%';
How much RAM do you have? Hopefully 16GB or more.
SHOW CREATE TABLE
How big is the table?
Give an example of an INSERT.
Do you have the INSERTs in transactions? Or are you depending on autocommit=1?
When an INSERT is slow, what else is going on? (Do SHOW PROCESSLIST.) It could be that a SELECT is doing a table scan that is blocking the INSERT.
Subject
Views
Written By
Posted
1891
August 17, 2012 11:30AM
Re: Performance Problem in some pCS
872
August 19, 2012 09:02PM
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.