MySQL Forums
Forum List  »  InnoDB

MySQL Server “freezes” after upgrade to 5.7
Posted by: Arthur Shapiro
Date: January 26, 2017 10:29AM

We recently upgraded from 5.6 to 5.7. Since then, few times every day, at random times, the server "freezes" for about 90 seconds. By that I mean that all queries and dml become extremely slow. In the slow query log, we just see commits and system/session variable queries (like select @@session.tx_read_only; ) that take about 90 secs and this happens for all the databases running on the server. We're plotting various mysql/innodb metrics over time and see corresponding spikes in innodb row lock time, table locks, innodb pages written or read and running threads. We've also collected SHOW ENGINE INNODB STATUS output at the time the spikes were occurring, but not quiet sure how to use it to determine the cause of this problem. We do have some deadlocks, but they do not occur at every outage, so it's unlikely to be the root cause.

Any suggestions for how to troubleshoot this issue?

Options: ReplyQuote

Written By
MySQL Server “freezes” after upgrade to 5.7
January 26, 2017 10:29AM

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.