{"id":520,"date":"2019-02-22T03:55:45","date_gmt":"2019-02-22T03:55:45","guid":{"rendered":"https:\/\/monyog.jp\/?p=520"},"modified":"2019-03-07T02:22:30","modified_gmt":"2019-03-07T02:22:30","slug":"real-time%e3%83%87%e3%83%bc%e3%82%bf","status":"publish","type":"post","link":"https:\/\/smart-style.main.jp\/monyogjp\/static\/document\/520\/index.html","title":{"rendered":"Real-Time\u30c7\u30fc\u30bf"},"content":{"rendered":"

SQL Diagnostic Manager\u306eReal-Time\u306b\u3088\u3063\u3066\u8a18\u9332\u3055\u308c\u308b\u30bb\u30c3\u30b7\u30e7\u30f3\u30c7\u30fc\u30bf\u306f\u3001Monyog\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u2018Data\u2019\u30d5\u30a9\u30eb\u30c0\u30fc\u306eSQLite\u306b\u4fdd\u5b58\u3055\u308c\u307e\u3059\u3002
\nReal-Time\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u306f\u591a\u304f\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u308a\u307e\u3059\u3002\u30b9\u30ad\u30fc\u30de\u306e\u8a73\u7d30\u60c5\u5831\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n

inndob_locks:<\/h3>\n
\r\nCREATE TABLE `innodb_locks` (\r\n   `row_id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,\r\n   `lock_id` VARCHAR (81) NOT NULL DEFAULT '',\r\n   `lock_type` VARCHAR (32) NOT NULL DEFAULT '',\r\n   `lock_table` VARCHAR (1024) NOT NULL DEFAULT '',\r\n   `lock_index` VARCHAR (1024) DEFAULT NULL,\r\n   `lock_data` VARCHAR (8192) DEFAULT NULL,\r\n   `lock_mode` VARCHAR (8192) DEFAULT NULL)<\/pre>\n
innodb_transactions:<\/h3>\n
\r\nCREATE TABLE `innodb_transactions` (\r\n   `row_id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,\r\n   `trx_id` VARCHAR (18) NOT NULL DEFAULT '',\r\n   `trx_state` VARCHAR (13) NOT NULL DEFAULT '',\r\n   `trx_start_time` INTEGER NOT NULL,\r\n   `trx_query_id` INTEGER (128) NOT NULL DEFAULT '',\r\n   `trx_query_starttime` INTEGER NOT NULL,\r\n   `trx_query_endtime` INTEGER NOT NULL,\r\n   `trx_user_host` VARCHAR (20) NOT NULL DEFAULT '',\r\n   `trx_db` VARCHAR (64) NOT NULL DEFAULT '',\r\n   `blocking_trx_id` VARCHAR (18) NOT NULL DEFAULT '',\r\n   `blocking_query_id` INTEGER NOT NULL DEFAULT '')<\/pre>\n
metric_master:<\/h3>\n
\r\nCREATE TABLE [ metric_master ] (\r\n   [ metric_id ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,\r\n   [ metric_desc ] TEXT ASC UNIQUE)<\/pre>\n
profiler_timestamps:<\/h3>\n
\r\nCREATE TABLE `profiler_timestamps` (\r\n   [ timestamp_id ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,\r\n   [ server_timestamp ] INTEGER UNIQUE)<\/pre>\n
query_master:<\/h3>\n
CREATE TABLE 'query_master' (\r\n   'id' INTEGER PRIMARY KEY AUTOINCREMENT,\r\n   'query' TEXT,\r\n   UNIQUE ('query'))<\/pre>\n
query_snapshot:<\/h3>\n
CREATE TABLE 'query_snapshot' (\r\n   'pkeyid' INTEGER PRIMARY KEY AUTOINCREMENT,\r\n   'id' INTEGER,\r\n   'threadid' INTEGER,\r\n   'user' TEXT,\r\n   'querytime' INTEGER,\r\n   'uptime' INTEGER,\r\n   'host' TEXT,\r\n   'state' TEXT,\r\n   'db' TEXT)<\/pre>\n
schema_master:<\/h3>\n
CREATE TABLE [ schema_master ] (\r\n   [ schema_id ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,\r\n   [ schema_name ] TEXT UNIQUE)<\/pre>\n
schema_version:<\/h3>\n
CREATE TABLE [ schema_version ] (\r\n   [ schema_desc ] TEXT,\r\n   [ schema_major_version ] TEXT,\r\n   [ schema_minor_version ] TEXT,\r\n   PRIMARY KEY (\r\n      [ schema_major_version ],\r\n      [ schema_minor_version ]))<\/pre>\n
snapshot_master:<\/h3>\n
CREATE TABLE [ snapshot_master ] (\r\n   [ timestamp_id ] INTEGER NOT NULL,\r\n   [ metric_id ] INTEGER NOT NULL,\r\n   [ metric_now ] TEXT,\r\n   [ metric_diff ] TEXT,\r\n   PRIMARY KEY (metric_id, timestamp_id))<\/pre>\n
sqlite_sequence:<\/h3>\n
CREATE TABLE sqlite_sequence(name,seq)<\/pre>\n
table_master:<\/h3>\n
CREATE TABLE [ table_master ] (\r\n   [ table_id ] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,\r\n   [ schema_id ] INTEGER,\r\n   [ table_name ] TEXT,\r\n   UNIQUE (schema_id, table_name))<\/pre>\n
table_snapshot:<\/h3>\n
CREATE TABLE \\[ table\\_snapshot \\] (\r\n    \\[ timestamp\\_id \\] INTEGER NOT NULL, \\[ table\\_id \\] INTEGER NOT\r\n    NULL, \\[ COUNT\\] INTEGER, PRIMARY KEY (timestamp\\_id, table\\_id))<\/pre>\n
timestamp_master:<\/h3>\n
CREATE TABLE \\[ timestamp\\_master \\] (\r\n    \\[ timestamp\\_id \\] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT\r\n    UNIQUE, \\[ server\\_timestamp \\] INTEGER UNIQUE, \\[\r\n    server\\_start\\_time \\] INTEGER, \\[ server\\_uptime \\] INTEGER, \\[\r\n    server\\_uptime\\_diff \\] INTEGER, \\[ server\\_is\\_connected \\]\r\n    INTEGER)<\/pre>\n","protected":false},"excerpt":{"rendered":"
SQL Diagnostic Manager\u306eReal-Time\u306b\u3088… <\/p>\n
Read more<\/a><\/div>\n","protected":false},"author":2,"featured_media":891,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17,3],"tags":[],"_links":{"self":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/posts\/520"}],"collection":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/comments?post=520"}],"version-history":[{"count":0,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/posts\/520\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/media\/891"}],"wp:attachment":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/media?parent=520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/categories?post=520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/tags?post=520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}