MySQL Forums
Forum List  »  Performance

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).

Options: ReplyQuote

Written By
Re: why select @@session.tx_read_only take long time
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.