Bug #103112 Queries Hanged With State of Statistics

• Submitted: 25 Mar 2021 16:36
• Modified: 29 Mar 2021 12:01
• Reporter: Irfan Ahmad
• Status: Not a Bug
• Category: MySQL Server: Row Based Replication ( RBR )
• Severity: S1 (Critical)
• Version: 5.7.30
• OS: CentOS (7.9)
• Assigned to: MySQL Verification Team
• CPU Architecture: Any (64-bit)
• Tags: queries-

[25 Mar 2021 16:36] Irfan Ahmad

Description:
We recently upgrade our GPL db patch from 5.7.22 into 5.7.30. We are running master/slave replication on mysql 5.7.30. Sometime, we perform big transaction on master server and when its replicate on slave server then mostly queries hanged into "statistics" state which boost up our db-connections and qureis count as well. We fix this issue through defragmentation command for specific tables e.g "alter table tab engine=innodb". Is there any permanent fix. This issue wasn't face regularly into 5.7.22

How to repeat:
Whenever we perform comparatively big transaction then problem start and queries goes into statistics mode.

Suggested fix:
We perform alter table table_name engine=innodb and issue fix for the time being.

[29 Mar 2021 12:01] MySQL Verification Team

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.