mysql> desc mysql.http_status_history;
|
+--------+-------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+--------+-------------+------+-----+---------+-------+
|
| id | smallint(6) | NO | PRI | 0 | |
|
| status | blob | YES | | NULL | |
|
+--------+-------------+------+-----+---------+-------+
|
select id,column_json(status) from http_status_history;
|
|
{"date":"2014-03-12 21:36:57","UPTIME":"10","ROWS_READ":"-437","MEMORY_USED":"1.18e6","SELECT_SCAN":"-1","OPENED_FILES":"76","HANDLER_WRITE":"-38","ROWS_TMP_READ":"-400","HANDLER_COMMIT":"-1","HANDLER_UPDATE":"-38","HANDLER_READ_KEY":"-438","INNODB_ROWS_READ":"53","HANDLER_TMP_WRITE":"-400","INNODB_LOG_WRITES":"1","KEY_READ_REQUESTS":"16","COM_REPLACE_SELECT":"-1","CREATED_TMP_TABLES":"-1","INNODB_DATA_FSYNCS":"7","INNODB_DATA_WRITES":"11","INNODB_DATA_WRITTEN":"230400","INNODB_DBLWR_WRITES":"2","ARIA_PAGECACHE_READS":"2","INNODB_OS_LOG_FSYNCS":"2","INNODB_PAGES_WRITTEN":"7","INNODB_ROWS_INSERTED":"1","HANDLER_READ_RND_NEXT":"-400","INNODB_OS_LOG_WRITTEN":"512","TABLE_LOCKS_IMMEDIATE":"14","OPENED_PLUGIN_LIBRARIES":"33","UPTIME_SINCE_FLUSH_STATUS":"10","INNODB_DBLWR_PAGES_WRITTEN":"7","ARIA_PAGECACHE_READ_REQUESTS":"113","ARIA_PAGECACHE_WRITE_REQUESTS":"6","INNODB_BUFFER_POOL_BYTES_DIRTY":"-81920","INNODB_BUFFER_POOL_PAGES_DIRTY":"-5","INNODB_BUFFER_POOL_PAGES_FLUSHED":"7","INNODB_BUFFER_POOL_READ_REQUESTS":"70","INNODB_BUFFER_POOL_WRITE_REQUESTS":"4"} |
|
| {"date":"2014-03-12 21:37:08","UPTIME":"11","BUSY_TIME":"5.9e-5","QUESTIONS":"1","ROWS_READ":"-435","BYTES_SENT":"33","MEMORY_USED":"1.18e6","SELECT_SCAN":"-1","OPENED_FILES":"76","HANDLER_WRITE":"-37","ROWS_TMP_READ":"-400","BYTES_RECEIVED":"57","HANDLER_COMMIT":"-1","HANDLER_UPDATE":"-37","HANDLER_READ_KEY":"-437","INNODB_ROWS_READ":"54","HANDLER_TMP_WRITE":"-400","INNODB_LOG_WRITES":"1","KEY_READ_REQUESTS":"16","COM_REPLACE_SELECT":"-1","CREATED_TMP_TABLES":"-1","INNODB_DATA_FSYNCS":"7","INNODB_DATA_WRITES":"11","INNODB_DATA_WRITTEN":"230400","INNODB_DBLWR_WRITES":"2","ARIA_PAGECACHE_READS":"2","INNODB_OS_LOG_FSYNCS":"2","INNODB_PAGES_WRITTEN":"7","INNODB_ROWS_INSERTED":"1","HANDLER_READ_RND_NEXT":"-399","INNODB_OS_LOG_WRITTEN":"512","TABLE_LOCKS_IMMEDIATE":"14","OPENED_PLUGIN_LIBRARIES":"33","UPTIME_SINCE_FLUSH_STATUS":"11","INNODB_DBLWR_PAGES_WRITTEN":"7","ARIA_PAGECACHE_READ_REQUESTS":"113","ARIA_PAGECACHE_WRITE_REQUESTS":"6","INNODB_BUFFER_POOL_BYTES_DIRTY":"-81920","INNODB_BUFFER_POOL_PAGES_DIRTY":"-5","INNODB_BUFFER_POOL_PAGES_FLUSHED":"7","INNODB_BUFFER_POOL_READ_REQUESTS":"71","INNODB_BUFFER_POOL_WRITE_REQUESTS":"4"} |
|
select GROUP_CONCAT(cast(column_json(status) as char)) from mysql.http_status_history;
|
+----------------------------------------------------------------------------+
|
| GROUP_CONCAT(cast(column_json(status) as char)) |
|
+----------------------------------------------------------------------------+
|
| ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, |
|
+----------------------------------------------------------------------------+
|
{"report":{"fcp":1072.3000001907349,"ttfb":209.30000019073486,"pageVisibility":"visible","entityId":32632,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"c6e84a47-8494-4efb-8797-7a4bcc33ae79","navigationType":0,"readyForUser":1175.6000003814697,"redirectCount":0,"resourceLoadedEnd":1321.8000001907349,"resourceLoadedStart":214.9000005722046,"resourceTiming":[{"duration":269.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":214.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":214.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":484.4000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":269.70000076293945,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":215.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":215.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":484.9000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":278.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":215.4000005722046,"connectEnd":215.4000005722046,"connectStart":215.4000005722046,"domainLookupEnd":215.4000005722046,"domainLookupStart":215.4000005722046,"fetchStart":215.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":215.4000005722046,"responseEnd":493.80000019073486,"responseStart":493.80000019073486,"secureConnectionStart":215.4000005722046},{"duration":371.0999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":215.60000038146973,"connectEnd":215.60000038146973,"connectStart":215.60000038146973,"domainLookupEnd":215.60000038146973,"domainLookupStart":215.60000038146973,"fetchStart":215.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":215.60000038146973,"responseEnd":586.6999998092651,"responseStart":586.6999998092651,"secureConnectionStart":215.60000038146973},{"duration":374.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":215.80000019073486,"connectEnd":215.80000019073486,"connectStart":215.80000019073486,"domainLookupEnd":215.80000019073486,"domainLookupStart":215.80000019073486,"fetchStart":215.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":215.80000019073486,"responseEnd":590.5,"responseStart":590.5,"secureConnectionStart":215.80000019073486},{"duration":375.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":216,"connectEnd":216,"connectStart":216,"domainLookupEnd":216,"domainLookupStart":216,"fetchStart":216,"redirectEnd":0,"redirectStart":0,"requestStart":216,"responseEnd":591.1999998092651,"responseStart":591.1000003814697,"secureConnectionStart":216},{"duration":375.4000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":216.19999980926514,"connectEnd":216.19999980926514,"connectStart":216.19999980926514,"domainLookupEnd":216.19999980926514,"domainLookupStart":216.19999980926514,"fetchStart":216.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":216.19999980926514,"responseEnd":591.6000003814697,"responseStart":591.6000003814697,"secureConnectionStart":216.19999980926514},{"duration":424.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":216.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":216.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":641.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":375.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":216.60000038146973,"connectEnd":216.60000038146973,"connectStart":216.60000038146973,"domainLookupEnd":216.60000038146973,"domainLookupStart":216.60000038146973,"fetchStart":216.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":216.60000038146973,"responseEnd":591.9000005722046,"responseStart":591.9000005722046,"secureConnectionStart":216.60000038146973},{"duration":424.6000003814697,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":216.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":216.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":641.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":375.8999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":216.9000005722046,"connectEnd":216.9000005722046,"connectStart":216.9000005722046,"domainLookupEnd":216.9000005722046,"domainLookupStart":216.9000005722046,"fetchStart":216.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":216.9000005722046,"responseEnd":592.8000001907349,"responseStart":592.8000001907349,"secureConnectionStart":216.9000005722046},{"duration":643.9000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":224.5,"connectEnd":224.5,"connectStart":224.5,"domainLookupEnd":224.5,"domainLookupStart":224.5,"fetchStart":224.5,"redirectEnd":0,"redirectStart":0,"requestStart":224.5,"responseEnd":868.4000005722046,"responseStart":868.4000005722046,"secureConnectionStart":224.5},{"duration":1097.3000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":224.5,"connectEnd":224.5,"connectStart":224.5,"domainLookupEnd":224.5,"domainLookupStart":224.5,"fetchStart":224.5,"redirectEnd":0,"redirectStart":0,"requestStart":224.5,"responseEnd":1321.8000001907349,"responseStart":1321.8000001907349,"secureConnectionStart":224.5},{"duration":216.20000076293945,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":652.6999998092651,"connectEnd":652.6999998092651,"connectStart":652.6999998092651,"domainLookupEnd":652.6999998092651,"domainLookupStart":652.6999998092651,"fetchStart":652.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":652.6999998092651,"responseEnd":868.9000005722046,"responseStart":868.9000005722046,"secureConnectionStart":652.6999998092651}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":40,"responseStart":210,"responseEnd":223,"domLoading":213,"domInteractive":1351,"domContentLoadedEventStart":1351,"domContentLoadedEventEnd":1404,"domComplete":1681,"loadEventStart":1681,"loadEventEnd":1681,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1331.6000003814697},{"name":"bigPipe.sidebar-id.end","time":1332.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1332.9000005722046},{"name":"bigPipe.activity-panel-pipe-id.end","time":1334.1999998092651},{"name":"activityTabFullyLoaded","time":1418}],"measures":[],"correlationId":"a0a9dbe135a158","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":100,"dbReadsTimeInMs":14,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}