Real-Time data

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

REATE 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

REATE 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)

Still need help? Contact Us Contact Us