Re: Question on slow queries
Well, let's study the third query -- UPDATE users. It's averaging 364ms; it might be possible to improve it.
Please provide the full statement, the SHOW CREATE TABLE, and the size of the table.
COMMIT is misleading, since we can't see what the transaction was doing.
Also provide
SHOW VARIABLES LIKE 'innodb%';
How big are all the InnoDB tables combined? Is it bigger than 640M? How much RAM is available?
Subject
Views
Written By
Posted
2554
May 30, 2013 04:18AM
Re: Question on slow queries
1009
May 31, 2013 05:14AM
990
June 01, 2013 02:45PM
1218
June 04, 2013 02:35AM
1300
June 05, 2013 11:27PM
835
June 06, 2013 02:02AM
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.