A Lightweight SQL Database for Cloud Infrastructure and Web Applications

Reset or flush global status for all status variables

Registered by Nadeem on 2010-05-11

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:
milestone icon 2010-11-08
Started by
Andrew Hutchings on 2010-11-02
Completed by
Lee Bieber on 2010-11-10

Sprints

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).

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.