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.