The session data that are recorded by SQL DM by MySQL Real-Time are stored in SQLite in Monyog directories data folder.
The Real-time database has many tables. Schema details are as follows:
inndob_locks:
Code Block |
---|
|
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:
Code Block |
---|
|
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:
Code Block |
---|
|
CREATE TABLE [ metric_master ] (
[ metric_id ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
[ metric_desc ] TEXT ASC UNIQUE) |
profiler_timestamps:
Code Block |
---|
|
CREATE TABLE `profiler_timestamps` (
[ timestamp_id ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
[ server_timestamp ] INTEGER UNIQUE) |
query_master:
Code Block |
---|
|
CREATE TABLE 'query_master' (
'id' INTEGER PRIMARY KEY AUTOINCREMENT,
'query' TEXT,
UNIQUE ('query')) |
query_snapshot:
Code Block |
---|
|
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:
Code Block |
---|
CREATE TABLE [ schema_master ] (
[ schema_id ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
[ schema_name ] TEXT UNIQUE) |
schema_version:
Code Block |
---|
|
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:
Code Block |
---|
|
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:
Code Block |
---|
|
CREATE TABLE sqlite_sequence(name,seq) |
table_master:
Code Block |
---|
|
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:
Code Block |
---|
|
CREATE TABLE \[ table\_snapshot \] (
\[ timestamp\_id \] INTEGER NOT NULL, \[ table\_id \] INTEGER NOT
NULL, \[ COUNT\] INTEGER, PRIMARY KEY (timestamp\_id, table\_id)) |
timestamp_master:
Code Block |
---|
|
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) |
...
...
...
...
...
...