2

We have deployed REDIS to hold some frequent query result to reduce number of connections made on Database server. We need to find out Max_used_connection after deploying REDIS. So we plan to reset mysql status variable Max_used_connection.

While googling i found to reset Max_used_connections we need to use FLUSH STATUS.

Is it safe to execute Flush status in production ? MySQL docs says:

FLUSH STATUS - resets the counters for key caches (default and named) to zero and sets Max_used_connections to the current number of open connections.

I don't know impact of resetting counters for key caches.

Is it possible to reset Max_used_connections alone ?

Thanks in Advance.

4

Is it safe to execute Flush status in production ?

  • Well it should not affect anything as such but resets the status counters and you should be "Safe".

Is it possible to reset Max_used_connections alone ?

  • No

but "We need to find out Max_used_connection after deploying ...."

  • How about introducing graphs into monitoring? Say Cacti / Grafana will give you good glances over what's-going-on-inside-your-mysql!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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