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.
Blueprint information
- Status:
- Complete
- Approver:
- Lee Bieber
- Priority:
- High
- Drafter:
- None
- Direction:
- Needs approval
- Assignee:
- Andrew Hutchings
- Definition:
- Approved
- Series goal:
- Accepted for 7.0
- Implementation:
- Implemented
- Milestone target:
- 2010-11-08
- Started by
- Andrew Hutchings
- Completed by
- Lee Bieber
Whiteboard
Rackspace request
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.
Work items:
Make 'flush' reset all global status counters: DONE
Test cases: DONE
Implementation:
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).