MySQL Forums
Forum List  »  InnoDB

Re: update slow occasionally
Posted by: Rick James
Date: October 16, 2014 10:23PM

There are many possible answers. Let's gather some more info:

Was it I/O bound? (There is I/O because of logging, even though you have a large buffer_pool.)

Was it CPU-bound?

Were the 1000 robots hitting the same row(s)? Random rows?

What was max_connections? Max_used_connections?

What was the value of autocommit? Were you using BEGIN...COMMIT?

Options: ReplyQuote


Subject
Views
Written By
Posted
1696
October 16, 2014 03:05AM
Re: update slow occasionally
947
October 16, 2014 10:23PM
932
October 25, 2014 01:13AM


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.