# 141.2s user time, 640ms system time, 36.69M rss, 186.12M vsz # Current date: Sun May 4 14:57:28 2014 # Hostname: web306.webfaction.com # Files: /var/lib/mysql/mysqld-slow.log # Overall: 382.94k total, 311 unique, 60.99 QPS, 0.04x concurrency _______ # Time range: 2014-05-04 13:05:21 to 14:50:00 # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 223s 1us 12s 581us 515us 38ms 76us # Lock time 51s 0 5s 132us 167us 16ms 0 # Rows sent 174.99k 0 9.00k 0.47 0.99 27.33 0 # Rows examine 22.42M 0 180.30k 61.39 28.75 1.76k 0 # Query size 36.52M 14 1.96k 100.00 299.03 104.12 59.77 # Profile # Rank Query ID Response time Calls R/Call Apdx V/M Item # ==== ================== ============= ====== ====== ==== ===== ========= # 1 0x1CF8A5DED2C8DB51 45.4168 20.4% 21 2.1627 0.55 4.73 SELECT cpg?x_pictures cpg?x_albums cpg?x_categories # 2 0x7CC57311358AB5BF 30.2613 13.6% 7 4.3230 0.21 0.73 SELECT cpg?x_pictures cpg?x_albums cpg?x_categories # 3 0x2D75B2D0A910FE60 19.1996 8.6% 5537 0.0035 1.00 3.14 SELECT cpg?x_pictures # 4 0x7B5FEF90E1E7E63E 11.2571 5.1% 33307 0.0003 1.00 0.01 SELECT cpg?x_plugin_geodata # 5 0xA8C019341B87A2E3 7.5326 3.4% 539 0.0140 1.00 4.03 UPDATE cpg?x_pictures # 6 0xD5EF6894EC6548ED 7.4454 3.3% 11154 0.0007 1.00 0.04 DELETE cpg?x_mod_online # 7 0x8784E67470A27AFF 5.7047 2.6% 9621 0.0006 1.00 0.04 SELECT cpg?x_pictures # 8 0x0E20F2889DCE7F73 5.6015 2.5% 10781 0.0005 1.00 0.02 UPDATE cpg?x_mod_online # 9 0x7E0B27FCF9533849 5.5106 2.5% 35 0.1574 1.00 0.05 SELECT smf_log_httpBL # 10 0x84DDCD21D224E120 5.2573 2.4% 5528 0.0010 1.00 0.07 SELECT cpg?x_exif # 11 0xDCD588C6D3391023 4.7797 2.1% 2 2.3899 0.50 0.00 SELECT cpg?x_pictures cpg?x_albums cpg?x_categories # 12 0x5C86667DD7A988D2 4.6600 2.1% 11297 0.0004 1.00 0.00 SELECT cpg?x_pictures # 13 0x814513E415DE18DF 4.0613 1.8% 11168 0.0004 1.00 0.02 SET # 14 0x7F9F919808A282D2 4.0251 1.8% 333 0.0121 1.00 0.02 SELECT cpg?x_pictures cpg?x_albums # 15 0xD2793D802CCEBC4A 3.1712 1.4% 11163 0.0003 1.00 0.01 DELETE cpg?x_banned # 16 0xAFC6AD64746BA2E5 3.1705 1.4% 333 0.0095 1.00 0.01 SELECT cpg?x_pictures cpg?x_albums # 17 0x17F23455C2D8C4E8 2.8445 1.3% 5502 0.0005 1.00 0.01 SELECT cpg?x_pictures # 18 0x642DCDB5648DE20F 2.7880 1.3% 30 0.0929 0.98 1.20 SELECT cpg?x_pictures cpg?x_albums cpg?x_categories # 19 0x598868A787C6A5F7 2.3177 1.0% 323 0.0072 1.00 0.07 SELECT cpg?x_categories cpg?x_albums cpg?x_pictures # 20 0xFBB9A151D7BD634C 2.1521 1.0% 3877 0.0006 1.00 0.01 SELECT cpg?x_pictures # MISC 0xMISC 45.4944 20.4% 262385 0.0002 NS 0.0 <291 ITEMS> # Query 1: 0.00 QPS, 0.01x concurrency, ID 0x1CF8A5DED2C8DB51 at byte 242394569 # This item is included in the report because it matches --limit. # Scores: Apdex = 0.55 [1.0]*, V/M = 4.73 # Query_time sparkline: | _^_| # Time range: 2014-05-04 13:20:10 to 14:41:49 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 21 # Exec time 20 45s 665ms 12s 2s 2s 3s 1s # Lock time 0 4ms 165us 444us 209us 287us 68us 176us # Rows sent 0 171 1 16 8.14 15.25 6.07 9.83 # Rows examine 0 45.84k 732 12.19k 2.18k 1.69k 3.18k 1.20k # Query size 0 11.14k 542 545 543.10 537.02 0 537.02 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################# # 1s ################################################################ # 10s+ ######## # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_albums'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_albums`\G # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_categories'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_categories`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, user1, user2, user3, user4, user5, user6, user7, user8, user9 FROM cpg15x_pictures AS r INNER JOIN cpg15x_albums AS a ON a.aid = r.aid INNER JOIN cpg15x_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 3 AND 12) AND approved = 'YES' ORDER BY ctime DESC, pid DESC LIMIT 0 ,4\G # Query 2: 0.09 QPS, 0.40x concurrency, ID 0x7CC57311358AB5BF at byte 32635619 # This item is included in the report because it matches --limit. # Scores: Apdex = 0.21 [1.0]*, V/M = 0.73 # Query_time sparkline: | ^ | # Time range: 2014-05-04 13:13:53 to 13:15:08 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 7 # Exec time 13 30s 2s 7s 4s 7s 2s 4s # Lock time 0 2ms 169us 1ms 312us 1ms 293us 176us # Rows sent 0 37 1 16 5.29 15.25 6.44 0.99 # Rows examine 0 16.81k 2.40k 2.41k 2.40k 2.38k 0 2.38k # Query size 0 3.88k 568 569 568.29 563.87 0 563.87 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_albums'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_albums`\G # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_categories'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_categories`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip, user1, user2, user3, user4, user5, user6, user7, user8, user9 FROM cpg15x_pictures AS r INNER JOIN cpg15x_albums AS a ON a.aid = r.aid INNER JOIN cpg15x_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 16 AND 17) AND approved = 'YES' ORDER BY ctime DESC, pid DESC LIMIT 2 ,1\G # Query 3: 0.88 QPS, 0.00x concurrency, ID 0x2D75B2D0A910FE60 at byte 32651107 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 3.14 # Query_time sparkline: | ^^____ | # Time range: 2014-05-04 13:05:21 to 14:50:00 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 5537 # Exec time 8 19s 20us 4s 3ms 467us 104ms 93us # Lock time 36 18s 0 4s 3ms 167us 104ms 0 # Rows sent 1 2.34k 0 1 0.43 0.99 0.49 0 # Rows examine 0 2.34k 0 1 0.43 0.99 0.49 0 # Query size 0 275.78k 49 52 51.00 49.17 0.26 49.17 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us ################################################################ # 100us ############################################################### # 1ms # # 10ms # # 100ms # # 1s # # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT * FROM cpg15x_pictures AS p WHERE pid='10122'\G # Query 4: 5.30 QPS, 0.00x concurrency, ID 0x7B5FEF90E1E7E63E at byte 206165812 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.01 # Query_time sparkline: | _^___ | # Time range: 2014-05-04 13:05:21 to 14:50:00 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 8 33307 # Exec time 5 11s 30us 110ms 337us 515us 1ms 247us # Lock time 8 4s 0 59ms 127us 214us 823us 98us # Rows sent 15 27.14k 0 1 0.83 0.99 0.37 0.99 # Rows examine 0 27.14k 0 1 0.83 0.99 0.37 0.99 # Query size 5 1.90M 57 61 59.92 59.77 0.79 59.77 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us ########## # 100us ################################################################ # 1ms # # 10ms # # 100ms # # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_plugin_geodata'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_plugin_geodata`\G # EXPLAIN /*!50100 PARTITIONS*/ select * from cpg15x_plugin_geodata where geodata_pid='4537'\G # Query 5: 0.09 QPS, 0.00x concurrency, ID 0xA8C019341B87A2E3 at byte 32649377 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 4.03 # Query_time sparkline: | ^____ | # Time range: 2014-05-04 13:06:31 to 14:43:46 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 539 # Exec time 3 8s 324us 6s 14ms 2ms 237ms 568us # Lock time 14 7s 84us 5s 13ms 541us 237ms 131us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 539 1 1 1 1 0 1 # Query size 0 61.34k 114 118 116.54 112.70 0 112.70 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms ######### # 10ms # # 100ms # # 1s # # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G UPDATE cpg15x_pictures SET hits = hits + 1, lasthit_ip = '89.110.0.72', mtime = CURRENT_TIMESTAMP WHERE pid = 10126\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select hits = hits + 1, lasthit_ip = '89.110.0.72', mtime = CURRENT_TIMESTAMP from cpg15x_pictures where pid = 10126\G # Query 6: 1.78 QPS, 0.00x concurrency, ID 0xD5EF6894EC6548ED at byte 74950774 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.04 # Query_time sparkline: | ^___ | # Time range: 2014-05-04 13:05:21 to 14:50:00 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 2 11154 # Exec time 3 7s 100us 292ms 667us 424us 5ms 287us # Lock time 10 5s 28us 292ms 478us 224us 5ms 152us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 1 323.73k 22 40 29.72 36.69 3.60 28.75 # Query size 2 827.84k 76 76 76 76 0 76 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms # # 10ms # # 100ms # # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_mod_online'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_mod_online`\G DELETE FROM cpg15x_mod_online WHERE last_action < NOW() - INTERVAL 10 MINUTE\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select * from cpg15x_mod_online WHERE last_action < NOW() - INTERVAL 10 MINUTE\G # Query 7: 1.53 QPS, 0.00x concurrency, ID 0x8784E67470A27AFF at byte 371934445 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.04 # Query_time sparkline: | ^.___ | # Time range: 2014-05-04 13:05:21 to 14:50:00 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 2 9621 # Exec time 2 6s 15us 308ms 592us 2ms 5ms 76us # Lock time 2 1s 0 306ms 136us 159us 4ms 0 # Rows sent 2 3.50k 0 1 0.37 0.99 0.48 0 # Rows examine 2 462.01k 0 1.05k 49.17 346.17 130.37 0 # Query size 4 1.69M 182 186 183.76 183.58 2 183.58 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us ################################################################ # 100us ############################ # 1ms ############ # 10ms # # 100ms # # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT r.pid FROM cpg15x_pictures AS r WHERE ((aid = 198 ) )AND approved='YES' ORDER BY title DESC, pid DESC LIMIT 0 ,1\G # Query 8: 1.72 QPS, 0.00x concurrency, ID 0x0E20F2889DCE7F73 at byte 395257120 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.02 # Query_time sparkline: | ^___ | # Time range: 2014-05-04 13:05:21 to 14:50:00 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 2 10781 # Exec time 2 6s 144us 173ms 519us 541us 3ms 301us # Lock time 3 2s 20us 65ms 175us 214us 1ms 113us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 164.94k 1 38 15.67 22.53 6.61 17.65 # Query size 2 931.78k 85 90 88.50 88.31 2.10 88.31 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms # # 10ms # # 100ms # # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_mod_online'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_mod_online`\G UPDATE cpg15x_mod_online SET last_action = NOW() WHERE user_ip = '112.5.234.110' LIMIT 1\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select last_action = NOW() from cpg15x_mod_online where user_ip = '112.5.234.110' LIMIT 1 \G # Query 9: 0.01 QPS, 0.00x concurrency, ID 0x7E0B27FCF9533849 at byte 275270281 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0]*, V/M = 0.05 # Query_time sparkline: | _^ | # Time range: 2014-05-04 13:06:08 to 14:47:12 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 35 # Exec time 2 6s 73ms 628ms 157ms 253ms 93ms 128ms # Lock time 0 4ms 81us 382us 112us 152us 53us 89us # Rows sent 0 35 1 1 1 1 0 1 # Rows examine 27 6.16M 180.27k 180.30k 180.28k 174.27k 0 174.27k # Query size 0 2.43k 71 71 71 71 0 71 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms ######## # 100ms ################################################################ # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'smf_log_httpBL'\G # SHOW CREATE TABLE `mitko_photos`.`smf_log_httpBL`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT ID FROM smf_log_httpBL ORDER BY logTime DESC LIMIT 1\G # Query 10: 0.88 QPS, 0.00x concurrency, ID 0x84DDCD21D224E120 at byte 391818145 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.07 # Query_time sparkline: | ^.___ | # Time range: 2014-05-04 13:05:21 to 14:50:00 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 5528 # Exec time 2 5s 18us 347ms 951us 445us 8ms 69us # Lock time 0 174ms 0 14ms 31us 138us 249us 0 # Rows sent 0 1.14k 0 1 0.21 0.99 0.40 0 # Rows examine 0 1.14k 0 1 0.21 0.99 0.40 0 # Query size 0 264.54k 47 50 49.00 46.83 0.24 46.83 # String: # Databases mitko_phot... (5527/99%), `pyxis_for... (1/0%) # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us ################################################################ # 100us ################### # 1ms # # 10ms ## # 100ms # # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_exif'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_exif`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT exifData FROM cpg15x_exif WHERE pid = 5037\G # Query 11: 0.22 QPS, 0.53x concurrency, ID 0xDCD588C6D3391023 at byte 39688878 # This item is included in the report because it matches --limit. # Scores: Apdex = 0.50 [1.0]*, V/M = 0.00 # Query_time sparkline: | ^ | # Time range: 2014-05-04 13:15:22 to 13:15:31 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 2 # Exec time 2 5s 2s 2s 2s 2s 879us 2s # Lock time 0 360us 172us 188us 180us 188us 11us 180us # Rows sent 0 32 16 16 16 16 0 16 # Rows examine 0 4.82k 2.41k 2.41k 2.41k 2.41k 0 2.41k # Query size 0 1.17k 597 597 597 597 0 597 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_albums'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_albums`\G # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_categories'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_categories`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip, user1, user2, user3, user4, user5, user6, user7, user8, user9 FROM cpg15x_pictures AS r INNER JOIN cpg15x_albums AS a ON a.aid = r.aid INNER JOIN cpg15x_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 16 AND 17) AND approved = 'YES' AND hits > 0 ORDER BY hits DESC, pid ASC LIMIT 0 ,16\G # Query 12: 1.80 QPS, 0.00x concurrency, ID 0x5C86667DD7A988D2 at byte 63681933 # 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-05-04 13:05:21 to 14:50:00 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 2 11297 # Exec time 2 5s 15us 67ms 412us 2ms 1ms 76us # Lock time 1 582ms 0 32ms 51us 159us 326us 0 # Rows sent 2 4.26k 0 1 0.39 0.99 0.48 0 # Rows examine 2 460.04k 0 1.11k 41.70 258.32 110.23 0 # Query size 5 1.96M 180 184 181.79 174.84 0.53 174.84 # String: # Databases mitko_phot... (11296/99%), `pyxis_for... (1/0%) # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us ################################################################ # 100us ################################ # 1ms ########### # 10ms # # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT r.pid FROM cpg15x_pictures AS r WHERE ((aid = 10 ) )AND approved='YES' ORDER BY title ASC, pid ASC LIMIT 0 ,1\G # Query 13: 1.78 QPS, 0.00x concurrency, ID 0x814513E415DE18DF at byte 112540394 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.02 # Query_time sparkline: | _^__ | # Time range: 2014-05-04 13:05:21 to 14:50:00 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 2 11168 # Exec time 1 4s 27us 64ms 363us 194us 3ms 144us # Lock time 0 0 0 0 0 0 0 0 # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 196.31k 18 18 18 18 0 18 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us # # 100us ################################################################ # 1ms # # 10ms # # 100ms # 1s # 10s+ SET NAMES 'cp1251'\G # Query 14: 0.06 QPS, 0.00x concurrency, ID 0x7F9F919808A282D2 at byte 122669768 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.02 # Query_time sparkline: | _ ^._ | # Time range: 2014-05-04 13:07:25 to 14:48:04 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 333 # Exec time 1 4s 47us 99ms 12ms 38ms 14ms 8ms # Lock time 0 64ms 0 6ms 192us 247us 287us 167us # Rows sent 0 1.23k 0 4 3.79 3.89 0.84 3.89 # Rows examine 13 3.00M 0 9.59k 9.21k 9.33k 1.81k 9.33k # Query size 0 94.31k 290 290 290 290 0 290 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us ### # 100us # 1ms ################################################################ # 10ms ################## # 100ms # # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_albums'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_albums`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT p.* FROM cpg15x_pictures AS p INNER JOIN cpg15x_albums AS r ON r.aid = p.aid WHERE (1) AND approved = 'YES' AND p.hot_expire > 1399210443 ORDER BY p.hot_expire ASC, pid ASC LIMIT 0 ,4\G # Query 15: 1.78 QPS, 0.00x concurrency, ID 0xD2793D802CCEBC4A at byte 206080922 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.01 # Query_time sparkline: | _^__ | # Time range: 2014-05-04 13:05:21 to 14:50:00 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 2 11163 # Exec time 1 3s 42us 76ms 284us 332us 2ms 194us # Lock time 3 2s 15us 76ms 179us 194us 2ms 108us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 1 675.88k 62 62 62 62 0 62 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us # # 100us ################################################################ # 1ms # # 10ms # # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_banned'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_banned`\G DELETE FROM cpg15x_banned WHERE expiry < '2014-05-04 14:00:03'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select * from cpg15x_banned WHERE expiry < '2014-05-04 14:00:03'\G # Query 16: 0.06 QPS, 0.00x concurrency, ID 0xAFC6AD64746BA2E5 at byte 82999757 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.01 # Query_time sparkline: | __^. | # Time range: 2014-05-04 13:07:25 to 14:48:04 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 333 # Exec time 1 3s 47us 82ms 10ms 13ms 8ms 8ms # Lock time 0 200ms 0 61ms 601us 273us 4ms 176us # Rows sent 0 1.23k 0 4 3.77 3.89 0.90 3.89 # Rows examine 13 2.94M 0 9.59k 9.03k 9.33k 2.16k 9.33k # Query size 0 68.62k 211 211 211 211 0 211 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us #### # 100us # # 1ms ################################################################ # 10ms ################# # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_albums'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_albums`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT pid FROM cpg15x_pictures AS p INNER JOIN cpg15x_albums AS r ON r.aid = p.aid WHERE (1) AND approved = 'YES' AND p.hot_expire > 1399209782\G # Query 17: 0.88 QPS, 0.00x concurrency, ID 0x17F23455C2D8C4E8 at byte 161542485 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.01 # Query_time sparkline: | ^-__ | # Time range: 2014-05-04 13:05:21 to 14:50:00 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 5502 # Exec time 1 3s 19us 59ms 516us 1ms 2ms 84us # Lock time 0 336ms 0 20ms 61us 176us 285us 0 # Rows sent 1 2.31k 0 1 0.43 0.99 0.49 0 # Rows examine 1 233.77k 0 778 43.51 258.32 112.25 0 # Query size 3 1.38M 165 464 262.86 346.17 45.70 246.02 # String: # Databases mitko_phot... (5501/99%), `pyxis_for... (1/0%) # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us ################################################################ # 100us ########################################### # 1ms ############ # 10ms # # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM cpg15x_pictures WHERE ((aid='61' ) ) AND approved='YES' AND (title < 'Santo Domingo / Faro a Colon - faux lighthouse' OR title = 'Santo Domingo / Faro a Colon - faux lighthouse' AND pid < 6767)\G # Query 18: 0.01 QPS, 0.00x concurrency, ID 0x642DCDB5648DE20F at byte 32657241 # This item is included in the report because it matches --limit. # Scores: Apdex = 0.98 [1.0]*, V/M = 1.20 # Query_time sparkline: | . ^.__ | # Time range: 2014-05-04 13:14:00 to 14:41:49 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 30 # Exec time 1 3s 55us 2s 93ms 91ms 334ms 3ms # Lock time 4 3s 0 2s 84ms 12ms 336ms 185us # Rows sent 0 24 0 1 0.80 0.99 0.40 0.99 # Rows examine 0 40.75k 0 2.40k 1.36k 2.38k 877.78 1.14k # Query size 0 9.90k 337 339 337.93 329.68 0 329.68 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us ###################### # 100us # 1ms ################################################################ # 10ms ################## # 100ms ### # 1s ### # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_albums'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_albums`\G # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_categories'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_categories`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT r.pid FROM cpg15x_pictures AS r INNER JOIN cpg15x_albums AS a ON a.aid = r.aid INNER JOIN cpg15x_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 16 AND 17) AND approved = 'YES' ORDER BY ctime DESC, pid DESC LIMIT 2 ,1\G # Query 19: 0.05 QPS, 0.00x concurrency, ID 0x598868A787C6A5F7 at byte 314268413 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.07 # Query_time sparkline: | ^_ __ | # Time range: 2014-05-04 13:07:24 to 14:48:04 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 323 # Exec time 1 2s 48us 290ms 7ms 40ms 22ms 69us # Lock time 0 10ms 0 401us 30us 214us 78us 0 # Rows sent 5 9.45k 0 215 29.95 212.52 73.59 0 # Rows examine 2 461.62k 0 10.26k 1.43k 9.80k 3.39k 0 # Query size 0 125.86k 399 399 399 399 0 399 # String: # Databases mitko_photos # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us ################################################################ # 100us ##### # 1ms # 10ms ########## # 100ms # # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_categories'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_categories`\G # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_albums'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_albums`\G # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT c.cid, r.aid, COUNT(pid) AS pic_count, MAX(pid) AS last_pid, MAX(ctime) AS last_upload, depth AS level, lft FROM cpg15x_categories AS c INNER JOIN cpg15x_albums AS r ON r.category = c.cid INNER JOIN cpg15x_pictures AS p ON p.aid = r.aid WHERE c.depth >= 0 + 1 AND approved = 'YES' GROUP BY r.aid ORDER BY NULL\G # Query 20: 0.62 QPS, 0.00x concurrency, ID 0xFBB9A151D7BD634C at byte 32691638 # This item is included in the report because it matches --limit. # Scores: Apdex = 1.00 [1.0], V/M = 0.01 # Query_time sparkline: | ^-__ | # Time range: 2014-05-04 13:05:23 to 14:50:00 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 3877 # Exec time 0 2s 46us 89ms 555us 2ms 3ms 84us # Lock time 1 507ms 0 89ms 130us 194us 2ms 0 # Rows sent 5 9.77k 0 7 2.58 6.98 3.15 0 # Rows examine 0 156.50k 0 1.11k 41.33 271.23 109.11 0 # Query size 2 999.09k 262 266 263.88 258.32 0 258.32 # String: # Databases mitko_phot... (3876/99%), `pyxis_for... (1/0%) # Hosts web306.webfaction.com # Users mitko_photos # Query_time distribution # 1us # 10us ################################################################ # 100us ########################################## # 1ms ############# # 10ms # # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mitko_photos` LIKE 'cpg15x_pictures'\G # SHOW CREATE TABLE `mitko_photos`.`cpg15x_pictures`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title FROM cpg15x_pictures AS r WHERE ((aid = 73 ) )AND approved='YES' ORDER BY title ASC, pid ASC LIMIT 0 ,7\G