Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mySQL stress when binlog_reader hung #3

Open
hellracer opened this issue May 12, 2019 · 1 comment
Open

mySQL stress when binlog_reader hung #3

hellracer opened this issue May 12, 2019 · 1 comment

Comments

@hellracer
Copy link

Every day or so, binlog_reader failed to accept new connection that leads to stress mysql server, when this happen the QPS on the server in question goes haywire from around 300 QPS in our environment to 3K QPS that leads to a lot of instability on the system.

restarting binlog reader will make the system stable again, how can we troubleshoot this instability in binlog reader?

@hellracer hellracer changed the title proxySQL stress when binlog_reader hung mySQL stress when binlog_reader hung May 12, 2019
@hellracer
Copy link
Author

Anyone using this in production can share some pointers on how to make this stable? i'm running binlog_reader under supervisor, I don't think if it will make a difference.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant