Re: why select @@session.tx_read_only take long time
Posted by:
Rick James
Date: November 02, 2016 11:43AM
Hmmm... Interesting.
Note that multiple connections ran the same query at the same time and it lasted the same length of time (nearly 19s).
What else was going on? Usually when something like this happens, another process is hogging something. Look further in the slowlog; maybe something else ended at essentially the same time.
Another tool for chasing it down: SHOW ENGINE INNODB STATUS; -- but it needs to be run promptly (unless you have a monitoring tool capturing it).
Subject
Views
Written By
Posted
3352
October 31, 2016 01:53AM
Re: why select @@session.tx_read_only take long time
2918
November 02, 2016 11:43AM
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.