Create System Level Operational Object: sysgslowlog
Registered by
Aarti Pai
sysgslowlog
This object holds information on all slow queries that have been captured – mirrors what is in 5.1.
Column Datatype Description
EVENT_DATE DATETIME Date/time the statement was captured
USER_NAME VARCHAR User name
HOST_NAME VARCHAR Name of the user’s host machine/IP
QUERY_TIME NUMBER Thread ID
LOCK_TIME NUMBER Server ID
ROWS_SENT NUMBER The type of command
ROWS_EXAMINED NUMBER The text of the command
DATABASE VARCHAR Database where the query was issued
LAST_INSERT_ID NUMBER Last insert ID
INSERT_ID NUMBER Insert ID
SERVER_ID NUMBER Server ID
SQL_TEXT TEXT The SQL text
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:
-
future
- Started by
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
(?)
Work Items
Dependency tree
* Blueprints in grey have been implemented.
