Reset or flush global status for all status variables
Reset or flush status somehow, say by truncating or global_status table?
Currently in MySQL you can only reset the status of Com_% variables and no others.
I'd like to be able to reset/flush all status variables with Drizzle if possible.
Perhaps this involves just truncating the global_status table.
- Lee Bieber
- Needs approval
- Andrew Hutchings
- Series goal:
- Accepted for 7.0
- Milestone target:
- Started by
- Andrew Hutchings on 2010-11-02
- Completed by
- Lee Bieber on 2010-11-10
Most global status variables are implemented using counters which are then sent in a dynamically built table when requested. For most of these variables this should be relatively simple.
Make 'flush' reset all global status counters: DONE
Test cases: DONE
As well as the standard FLUSH STATUS; which clears the current session counters there will be FLUSH GLOBAL STATUS; which a) clears the counters for current sessions and b) clears the global status counters (needed to do a to make b work).