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