|
|
The session data that are recorded by MONyog's Real-Time are stored in SQLite in MONyog directories's 'Data' folder.
The Real-time database has many tables. Schema details are as follows-
inndob_locks:
CREATE TABLE `innodb_locks` (
`row_id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
`lock_id` VARCHAR (81) NOT NULL DEFAULT '',
`lock_type` VARCHAR (32) NOT NULL DEFAULT '',
`lock_table` VARCHAR (1024) NOT NULL DEFAULT '',
`lock_index` VARCHAR (1024) DEFAULT NULL,
`lock_data` VARCHAR (8192) DEFAULT NULL,
`lock_mode` VARCHAR (8192) DEFAULT NULL)
innodb_transactions:
CREATE TABLE `innodb_transactions` (
`row_id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
`trx_id` VARCHAR (18) NOT NULL DEFAULT '',
`trx_state` VARCHAR (13) NOT NULL DEFAULT '',
`trx_start_time` INTEGER NOT NULL,
`trx_query_id` INTEGER (128) NOT NULL DEFAULT '',
`trx_query_starttime` INTEGER NOT NULL,
`trx_query_endtime` INTEGER NOT NULL,
`trx_user_host` VARCHAR (20) NOT NULL DEFAULT '',
`trx_db` VARCHAR (64) NOT NULL DEFAULT '',
`blocking_trx_id` VARCHAR (18) NOT NULL DEFAULT '',
`blocking_query_id` INTEGER NOT NULL DEFAULT '')
metric_master:
CREATE TABLE [ metric_master ] (
[ metric_id ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
[ metric_desc ] TEXT ASC UNIQUE)
profiler_timestamps:
CREATE TABLE `profiler_timestamps` (
[ timestamp_id ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
[ server_timestamp ] INTEGER UNIQUE)
query_master:
CREATE TABLE 'query_master' (
'id' INTEGER PRIMARY KEY AUTOINCREMENT,
'query' TEXT,
UNIQUE ('query'))
query_snapshot:
CREATE TABLE 'query_snapshot' (
'pkeyid' INTEGER PRIMARY KEY AUTOINCREMENT,
'id' INTEGER,
'threadid' INTEGER,
'user' TEXT,
'querytime' INTEGER,
'uptime' INTEGER,
'host' TEXT,
'state' TEXT,
'db' TEXT)
schema_master:
CREATE TABLE [ schema_master ] (
[ schema_id ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
[ schema_name ] TEXT UNIQUE)
schema_version:
CREATE TABLE [ schema_version ] (
[ schema_desc ] TEXT,
[ schema_major_version ] TEXT,
[ schema_minor_version ] TEXT,
PRIMARY KEY (
[ schema_major_version ],
[ schema_minor_version ]))
snapshot_master:
CREATE TABLE [ snapshot_master ] (
[ timestamp_id ] INTEGER NOT NULL,
[ metric_id ] INTEGER NOT NULL,
[ metric_now ] TEXT,
[ metric_diff ] TEXT,
PRIMARY KEY (metric_id, timestamp_id))
sqlite_sequence:
CREATE TABLE sqlite_sequence(name,seq)
table_master:
CREATE TABLE [ table_master ] (
[ table_id ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
[ schema_id ] INTEGER,
[ table_name ] TEXT,
UNIQUE (schema_id, table_name))
table_snapshot:
CREATE TABLE [ table_snapshot ] (
[ timestamp_id ] INTEGER NOT NULL,
[ table_id ] INTEGER NOT NULL,
[ COUNT] INTEGER,
PRIMARY KEY (timestamp_id, table_id))
timestamp_master:
CREATE TABLE [ timestamp_master ] (
[ timestamp_id ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
[ server_timestamp ] INTEGER UNIQUE,
[ server_start_time ] INTEGER,
[ server_uptime ] INTEGER,
[ server_uptime_diff ] INTEGER,
[ server_is_connected ] INTEGER)
|
|