MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

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?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
update slow occasionally
1900
zs none
October 16, 2014 03:05AM
Re: update slow occasionally
1051
Rick James
October 16, 2014 10:23PM
Re: update slow occasionally
1042
Chrisa Torain
October 25, 2014 01:13AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.