MySQL Forums
Forum List  »  InnoDB

update slow occasionally
Posted by: zs none
Date: October 16, 2014 03:05AM

to test mysql performance ,i use 1000 robots to update their datas repeatly. I set the long_query_tim to 0 and analysis the result: (the innodb pool size and innodb log/log_buffer size is big enough).innodb_flush_log_at_trx_commit set to 2;
the qps is about 1000 .
question avg time 100us but the max time 200ms, is this because the log flush per second?

Options: ReplyQuote


Subject
Views
Written By
Posted
update slow occasionally
1696
October 16, 2014 03:05AM
948
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.