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:

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)



SQL Diagnostic Manager for MySQL agentless and cost-effective performance monitoring for MySQL and MariaDB.
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels