Create System Level Time Model Objects

Registered by Aarti Pai

systime
This object holds system information relating to amount of time spent on system activities.

Column Datatype Description
SERVER_ID NUMBER Server ID
ACTIVITY_NAME VARCHAR Activity the system has engaged in
ACTIVITY_TIME NUMBER Total amount of time spent in activity (in milli or possibly microseconds)

Notes:

Possible tracked activities could include:
Database CPU time
SQL execution time
SQL parse time
Procedure execution time
Trigger execution time
Temp table creation time
InnoDB log flush time
Idle time
Others?

These statistics could be moved from this separate object to the global statistics performance object, sysperfstat.

Blueprint information

Status:
Not started
Approver:
None
Priority:
Medium
Drafter:
Brian Aker
Direction:
Approved
Assignee:
None
Definition:
Approved
Series goal:
Accepted for trunk
Implementation:
Not started
Milestone target:
milestone icon future

Related branches

Sprints

Whiteboard

(?)

Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.