0

A recent issue in our network caused a large number of aborted connects, which is now being displayed on the health dashboard of our web application as a potential issue.

Aside from restarting MySQL, is there a way to reset Aborted_connects to 0? I have tried flush hosts and flush status, but they do not reset Aborted_connects

EDIT : MySQL 5.7.24

4
  • Did FLUSH GLOBAL STATUS acheive this? What MySQL version? Messy but you could gdb attach to the process and set aborted_connects=0.
    – danblack
    Mar 14, 2019 at 22:01
  • MySQL 5.7.24. FLUSH GLOBAL STATUS tells me ERROR 1064 (42000): You have an error in your SQL syntax; Mar 14, 2019 at 22:25
  • Sorry about syntax, was thinking 'SET [GLOBAL|SESSION]` applied to flush too.
    – danblack
    Mar 15, 2019 at 2:33
  • 1
    Plan B: Get a dashboard that looks at the change in that Status, not the value-since-restsrt.
    – Rick James
    Mar 15, 2019 at 18:31

1 Answer 1

1

The reason FLUSH STATUS doesn't reset this is because its a function in MySQL rather than a simple variable (code ref).

Using gdb assignment, you should be able to:

gdb -p $(pidof mysqld) -batch \
  -ex 'set variable Connection_handler_manager::m_instance->m_aborted_connects = 0L' \
  -ex continue \
  -ex quit

Otherwise you don't have much choice apart from a restart.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.