Skip to content

Instantly share code, notes, and snippets.

@TimSimmons

TimSimmons/analysis.sql

Last active August 29, 2015 14:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save TimSimmons/f573c797ddec1b37d2f1 to your computer and use it in GitHub Desktop.
Save TimSimmons/f573c797ddec1b37d2f1 to your computer and use it in GitHub Desktop.
Download ZIP
Query Analysis results
Raw
analysis.sql
# 336.7s user time, 960ms system time, 21.99M rss, 65.09M vsz
# Current date: Wed Oct 22 16:35:03 2014
# Hostname: galera-2
# Files: slow.log
# Overall: 1.86M total, 175 unique, 1.97k QPS, 0.07x concurrency _________
# Time range: 2014-10-22 16:19:15 to 16:35:02
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 67s 1us 110ms 36us 20us 990us 15us
# Lock time 2s 0 4ms 0 0 6us 0
# Rows sent 45.76k 0 24 0.03 0 0.17 0
# Rows examine 6.28M 0 22.99k 3.54 0 276.01 0
# Query size 40.42M 6 624 22.76 14.52 63.19 13.83
# Profile
# Rank Query ID Response time Calls R/Call Apdx V/M Item
# ==== ================== ============= ======= ====== ==== ===== ========
# 1 0x6C099B0B73EA7633 29.1824 43.5% 1802204 0.0000 1.00 0.00
# 2 0xA8C3198C3A54D679 21.5103 32.0% 272 0.0791 1.00 0.00 SELECT domains
# 3 0x11A42EC90381791A 7.4969 11.2% 272 0.0276 1.00 0.00 SELECT domains
# 4 0x813031B8BBC3B329 1.6894 2.5% 806 0.0021 1.00 0.00 COMMIT
# 5 0xB520F69E5FA52E1C 0.6148 0.9% 4584 0.0001 1.00 0.00 SELECT domains
# 6 0xFB40C942D1B44B4D 0.4937 0.7% 1790 0.0003 1.00 0.00 SELECT records
# 7 0xCB8666383F6B160C 0.3360 0.5% 2562 0.0001 1.00 0.00 SELECT records
# 8 0xC731DDC3B253F7AD 0.3163 0.5% 3200 0.0001 1.00 0.00 SELECT records
# 9 0x977442B2D8E53573 0.2981 0.4% 2266 0.0001 1.00 0.00 SELECT records
# 10 0x249BB38F67FE2017 0.2727 0.4% 986 0.0003 1.00 0.00 SELECT records
# 11 0x42A4EFA7FAE44329 0.2704 0.4% 1281 0.0002 1.00 0.00 INSERT records
# 12 0x416F578748DFC723 0.2620 0.4% 635 0.0004 1.00 0.00 SELECT recordsets
# 13 0x130A4DE9EF90F265 0.1981 0.3% 1774 0.0001 1.00 0.00 SELECT records
# 14 0xC7FDCC89EBD0E191 0.1742 0.3% 1932 0.0001 1.00 0.00 SELECT recordsets
# 15 0xD8C5A43E53A0FED4 0.1694 0.3% 493 0.0003 1.00 0.00 SELECT recordsets
# 16 0xD3175891294518C7 0.1683 0.3% 1127 0.0001 1.00 0.00 SELECT domains
# 17 0x0D5FC338F4B0F25F 0.1654 0.2% 1281 0.0001 1.00 0.00 SELECT recordsets
# 18 0x1C5E5D86637F3621 0.1632 0.2% 614 0.0003 1.00 0.00 SELECT recordsets
# 19 0x0AABD326E93D8ABA 0.1559 0.2% 1037 0.0002 1.00 0.00 SELECT servers
# MISC 0xMISC 3.2078 4.8% 32999 0.0001 NS 0.0 <156 ITEMS>
SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description
FROM recordsets INNER JOIN domains ON recordsets.domain_id = domains.id
WHERE domains.deleted = '0' AND recordsets.type = 'SOA' AND recordsets.name = 'Delvin5749197512.com.'
LIMIT 2;
# Query 2: 2.06 QPS, 0.16x concurrency, ID 0xA8C3198C3A54D679 at byte 12403643
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^_ |
# Time range: 2014-10-22 16:20:16 to 16:22:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 272
# Exec time 32 22s 72ms 110ms 79ms 87ms 5ms 75ms
# Lock time 0 11ms 34us 107us 38us 49us 6us 36us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 95 6.02M 22.34k 22.99k 22.68k 22.45k 332.50 22.45k
# Query size 0 126.91k 474 482 477.79 463.90 0 463.90
# String:
# Databases designate
# Hosts
# Users designate
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms #
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'domains'\G
# SHOW CREATE TABLE `designate`.`domains`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id
FROM domains
WHERE domains.name LIKE '%Trudie4444714228.com.' AND domains.deleted = '0' ORDER BY domains.created_at ASC, domains.id ASC, domains.created_at ASC\G
# Query 3: 2.06 QPS, 0.06x concurrency, ID 0x11A42EC90381791A at byte 9028020
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^ |
# Time range: 2014-10-22 16:20:16 to 16:22:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 272
# Exec time 11 7s 25ms 52ms 28ms 30ms 2ms 27ms
# Lock time 0 12ms 28us 125us 44us 73us 15us 36us
# Rows sent 0 272 1 1 1 1 0 1
# Rows examine 3 237.41k 801 955 893.76 918.49 34.45 874.75
# Query size 0 36.47k 136 138 137.31 136.99 1 136.99
# String:
# Databases designate
# Hosts
# Users designate
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'domains'\G
# SHOW CREATE TABLE `designate`.`domains`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT count(domains.id) AS count_1
FROM domains
WHERE domains.tenant_id = 'T18' AND domains.tenant_id = 'T18' AND domains.deleted = '0'\G
# Query 5: 34.73 QPS, 0.00x concurrency, ID 0xB520F69E5FA52E1C at byte 1730329
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^_ |
# Time range: 2014-10-22 16:20:16 to 16:22:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 4584
# Exec time 0 615ms 106us 4ms 134us 204us 65us 119us
# Lock time 11 191ms 32us 4ms 41us 63us 54us 36us
# Rows sent 9 4.48k 1 1 1 1 0 1
# Rows examine 0 4.48k 1 1 1 1 0 1
# Query size 4 1.97M 450 451 450.61 441.81 0 441.81
# String:
# Databases designate
# Hosts
# Users designate
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'domains'\G
# SHOW CREATE TABLE `designate`.`domains`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id
FROM domains
WHERE domains.id = 'd10e345abb614d2185e7863cb8461e6b' AND domains.tenant_id = 'T15' AND domains.deleted = '0'
LIMIT 2\G
# Query 6: 13.46 QPS, 0.00x concurrency, ID 0xFB40C942D1B44B4D at byte 712604
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^ |
# Time range: 2014-10-22 16:20:15 to 16:22:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1790
# Exec time 0 494ms 178us 772us 275us 424us 75us 236us
# Lock time 4 81ms 31us 173us 45us 69us 12us 38us
# Rows sent 3 1.75k 1 1 1 1 0 1
# Rows examine 0 3.50k 2 2 2 2 0 2
# Query size 2 1.00M 586 586 586 586 0 586
# String:
# Databases designate
# Hosts
# Users designate
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'records'\G
# SHOW CREATE TABLE `designate`.`records`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status
FROM records
WHERE records.recordset_id = 'a3ce47a091c247a7a2bedd501b075833' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC\G
# Query 7: 142.33 QPS, 0.02x concurrency, ID 0xCB8666383F6B160C at byte 20588374
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^ |
# Time range: 2014-10-22 16:22:55 to 16:23:13
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 2562
# Exec time 0 336ms 113us 332us 131us 152us 15us 125us
# Lock time 5 85ms 28us 93us 33us 40us 5us 30us
# Rows sent 5 2.50k 1 1 1 1 0 1
# Rows examine 0 0 0 0 0 0 0 0
# Query size 2 1.03M 371 465 421.91 441.81 33.74 441.81
# String:
# Databases designate
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'records'\G
# SHOW CREATE TABLE `designate`.`records`\G
EXPLAIN select * from records where id='c2f24dd6e0ad477ab21844a531688d7f' and version= 1 and created_at= '2014-10-22 16:21:31.660593' and tenant_id= 'T19' and domain_id= '9b5dcffd5bc445d6872113afa007314b' and recordset_id= '54992ae9558b46cfa93a18d601bd0c5b' and data= '241.141.28.145' and hash= '6669024e044c4450066af4a4d78fe79c' and managed= 0 and status= 'ACTIVE'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select * from records where id='c2f24dd6e0ad477ab21844a531688d7f' and version= 1 and created_at= '2014-10-22 16:21:31.660593' and tenant_id= 'T19' and domain_id= '9b5dcffd5bc445d6872113afa007314b' and recordset_id= '54992ae9558b46cfa93a18d601bd0c5b' and data= '241.141.28.145' and hash= '6669024e044c4450066af4a4d78fe79c' and managed= 0 and status= 'ACTIVE'\G
# Query 8: 177.78 QPS, 0.02x concurrency, ID 0xC731DDC3B253F7AD at byte 21546427
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^_ |
# Time range: 2014-10-22 16:22:55 to 16:23:13
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 3200
# Exec time 0 316ms 84us 258us 98us 113us 13us 93us
# Lock time 6 106ms 28us 95us 32us 40us 5us 30us
# Rows sent 6 3.12k 1 1 1 1 0 1
# Rows examine 0 0 0 0 0 0 0 0
# Query size 3 1.56M 512 512 512 512 0 512
# String:
# Databases designate
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us ################################################################
# 100us #########################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'records'\G
# SHOW CREATE TABLE `designate`.`records`\G
EXPLAIN SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status
FROM records
WHERE records.id = '1c002ab5609745caa7152801ce92497a'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status
FROM records
WHERE records.id = '1c002ab5609745caa7152801ce92497a'\G
# Query 9: 125.89 QPS, 0.02x concurrency, ID 0x977442B2D8E53573 at byte 20895240
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^ |
# Time range: 2014-10-22 16:22:55 to 16:23:13
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 2266
# Exec time 0 298ms 116us 321us 131us 152us 15us 119us
# Lock time 4 82ms 31us 168us 35us 42us 6us 33us
# Rows sent 4 2.21k 1 1 1 1 0 1
# Rows examine 0 0 0 0 0 0 0 0
# Query size 3 1.28M 594 594 594 594 0 594
# String:
# Databases designate
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'records'\G
# SHOW CREATE TABLE `designate`.`records`\G
EXPLAIN SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status
FROM records
WHERE records.recordset_id = '2fd4fb851dd34a71903cffc71b04fc30' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status
FROM records
WHERE records.recordset_id = '2fd4fb851dd34a71903cffc71b04fc30' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC\G
# Query 10: 7.47 QPS, 0.00x concurrency, ID 0x249BB38F67FE2017 at byte 293211
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^ |
# Time range: 2014-10-22 16:20:16 to 16:22:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 986
# Exec time 0 273ms 218us 608us 276us 384us 54us 260us
# Lock time 2 40ms 34us 130us 41us 52us 8us 36us
# Rows sent 2 986 1 1 1 1 0 1
# Rows examine 0 1.93k 2 2 2 2 0 2
# Query size 1 592.74k 615 616 615.58 592.07 0 592.07
# String:
# Databases designate
# Hosts
# Users designate
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'records'\G
# SHOW CREATE TABLE `designate`.`records`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status
FROM records
WHERE records.recordset_id = '73221cc3359245798f0bff792a59aaba' AND records.tenant_id = 'T25' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC\G
# Query 11: 9.70 QPS, 0.00x concurrency, ID 0x42A4EFA7FAE44329 at byte 765752
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^_ |
# Time range: 2014-10-22 16:20:16 to 16:22:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1281
# Exec time 0 270ms 150us 2ms 211us 301us 75us 185us
# Lock time 2 45ms 27us 443us 35us 44us 16us 31us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 1 474.01k 328 422 378.91 400.73 29.83 381.65
# String:
# Databases designate
# Hosts
# Users designate
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'records'\G
# SHOW CREATE TABLE `designate`.`records`\G
INSERT INTO records (id, version, created_at, tenant_id, domain_id, recordset_id, data, hash, managed, status) VALUES ('c1dfc20631414cd49b839bebc3946fe5', 1, '2014-10-22 16:20:12.014431', 'T15', 'b9848dd3d82444c49e15c54b575a27bb', 'c6356f50cf364bb096fdd5c2f7f3fe08', 'staging-ns1.staging.raqit.com. lesch.alto.gleichner-mckenzie.com. 1413994811 3600 600 86400 3600', '4bec815cd3244453c5503146ad5a7537', 0, 'ACTIVE')\G
# Query 12: 4.81 QPS, 0.00x concurrency, ID 0x416F578748DFC723 at byte 161278
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^_ |
# Time range: 2014-10-22 16:20:16 to 16:22:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 635
# Exec time 0 262ms 226us 2ms 412us 626us 132us 384us
# Lock time 2 35ms 32us 168us 54us 93us 20us 44us
# Rows sent 1 635 1 1 1 1 0 1
# Rows examine 0 1.24k 2 2 2 2 0 2
# Query size 0 244.95k 395 395 395 395 0 395
# String:
# Databases designate
# Hosts
# Users designate
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'recordsets'\G
# SHOW CREATE TABLE `designate`.`recordsets`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description
FROM recordsets
WHERE recordsets.type = 'SOA' AND recordsets.domain_id = '60c9494f99af4e0dadad241be5dade6c' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC\G
# Query 13: 13.44 QPS, 0.00x concurrency, ID 0x130A4DE9EF90F265 at byte 10606778
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | _^ |
# Time range: 2014-10-22 16:20:16 to 16:22:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1774
# Exec time 0 198ms 91us 386us 111us 144us 19us 103us
# Lock time 3 61ms 27us 312us 34us 44us 9us 31us
# Rows sent 2 1.25k 0 1 0.72 0.99 0.44 0.99
# Rows examine 0 1.25k 0 1 0.72 0.99 0.44 0.99
# Query size 2 873.14k 504 504 504 504 0 504
# String:
# Databases designate
# Hosts
# Users designate
# Query_time distribution
# 1us
# 10us ############
# 100us ################################################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'records'\G
# SHOW CREATE TABLE `designate`.`records`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.priority, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status
FROM records
WHERE records.id = '82c0962a7f7e423c92e018bbf352c9c7'\G
# Query 14: 107.33 QPS, 0.01x concurrency, ID 0xC7FDCC89EBD0E191 at byte 17494514
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^_ |
# Time range: 2014-10-22 16:22:55 to 16:23:13
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1932
# Exec time 0 174ms 76us 251us 90us 119us 14us 80us
# Lock time 3 53ms 23us 89us 27us 33us 4us 23us
# Rows sent 4 1.89k 1 1 1 1 0 1
# Rows examine 0 0 0 0 0 0 0 0
# Query size 1 541.49k 287 287 287 287 0 287
# String:
# Databases designate
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us ################################################################
# 100us ############
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'recordsets'\G
# SHOW CREATE TABLE `designate`.`recordsets`\G
EXPLAIN SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description
FROM recordsets
WHERE recordsets.id = 'fdde5ab5f297470c8391165d6922b4a5'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description
FROM recordsets
WHERE recordsets.id = 'fdde5ab5f297470c8391165d6922b4a5'\G
# Query 15: 3.73 QPS, 0.00x concurrency, ID 0xD8C5A43E53A0FED4 at byte 242479
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^_ |
# Time range: 2014-10-22 16:20:16 to 16:22:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 493
# Exec time 0 169ms 197us 2ms 343us 1ms 286us 247us
# Lock time 1 17ms 29us 80us 35us 47us 6us 33us
# Rows sent 1 493 1 1 1 1 0 1
# Rows examine 0 493 1 1 1 1 0 1
# Query size 0 171.68k 356 357 356.58 346.17 0 346.17
# String:
# Databases designate
# Hosts
# Users designate
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms ###
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'recordsets'\G
# SHOW CREATE TABLE `designate`.`recordsets`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description
FROM recordsets
WHERE recordsets.type = 'SOA' AND recordsets.domain_id = 'f24e6455507f49bca82846bded770aa1' AND recordsets.tenant_id = 'T13'
LIMIT 2\G
# Query 16: 8.47 QPS, 0.00x concurrency, ID 0xD3175891294518C7 at byte 1556775
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | _^ |
# Time range: 2014-10-22 16:20:15 to 16:22:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1127
# Exec time 0 168ms 95us 581us 149us 247us 56us 131us
# Lock time 3 54ms 31us 373us 47us 89us 23us 38us
# Rows sent 1 583 0 1 0.52 0.99 0.50 0.99
# Rows examine 0 583 0 1 0.52 0.99 0.50 0.99
# Query size 1 443.34k 391 417 402.82 400.73 9.54 400.73
# String:
# Databases designate
# Hosts
# Users designate
# Query_time distribution
# 1us
# 10us #####
# 100us ################################################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'domains'\G
# SHOW CREATE TABLE `designate`.`domains`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id
FROM domains
WHERE domains.name = 'Josephus6993530774.com.' AND domains.deleted = '0'
LIMIT 2\G
# Query 17: 9.70 QPS, 0.00x concurrency, ID 0x0D5FC338F4B0F25F at byte 3689719
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^ |
# Time range: 2014-10-22 16:20:16 to 16:22:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1281
# Exec time 0 165ms 99us 429us 129us 194us 36us 113us
# Lock time 3 50ms 30us 296us 39us 52us 11us 35us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 1 598.29k 471 495 478.26 487.09 8.87 463.90
# String:
# Databases designate
# Hosts
# Users designate
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'recordsets'\G
# SHOW CREATE TABLE `designate`.`recordsets`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description
FROM recordsets
WHERE recordsets.type = 'CNAME' AND recordsets.domain_id = 'ac3f3ae1883d4691956f03b67ce83ef3' AND recordsets.name = 'Chelsi1716931076.com.' AND recordsets.tenant_id = 'T15' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC\G
# Query 18: 4.65 QPS, 0.00x concurrency, ID 0x1C5E5D86637F3621 at byte 1069975
# This item is included in the report because it matches --limit.
# Scores: Apdex = 1.00 [1.0], V/M = 0.00
# Query_time sparkline: | ^ |
# Time range: 2014-10-22 16:20:16 to 16:22:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 614
# Exec time 0 163ms 173us 810us 265us 403us 78us 236us
# Lock time 1 24ms 31us 94us 39us 63us 9us 35us
# Rows sent 2 1.21k 1 11 2.01 4.96 1.38 1.96
# Rows examine 0 2.41k 2 22 4.03 9.83 2.76 3.89
# Query size 0 237.45k 396 396 396 396 0 396
# String:
# Databases designate
# Hosts
# Users designate
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `designate` LIKE 'recordsets'\G
# SHOW CREATE TABLE `designate`.`recordsets`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description
FROM recordsets
WHERE recordsets.type != 'SOA' AND recordsets.domain_id = '86928496675c41bca3e25e3bdae62581' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC\G
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment