Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [root@xtradb1 ~]# pt-query-digest /var/lib/mysql/slow.log
- # 200ms user time, 10ms system time, 23.09M rss, 197.38M vsz
- # Current date: Mon Dec 16 11:09:52 2013
- # Hostname: xtradb1
- # Files: /var/lib/mysql/slow.log
- # Overall: 9 total, 2 unique, 0.00 QPS, 0.00x concurrency ________________
- # Time range: 2013-12-10 15:22:24 to 2013-12-11 16:39:28
- # Attribute total min max avg 95% stddev median
- # ============ ======= ======= ======= ======= ======= ======= =======
- # Exec time 308s 18s 44s 34s 42s 11s 39s
- # Lock time 2ms 0 347us 177us 332us 134us 194us
- # Rows sent 9 1 1 1 1 0 1
- # Rows examine 164.32M 0 27.39M 18.26M 27.20M 12.82M 27.20M
- # Rows affecte 0 0 0 0 0 0 0
- # Rows read 164.32M 0 27.39M 18.26M 27.20M 12.82M 27.20M
- # Bytes sent 5.06k 80 824 576 793.42 338.06 793.42
- # Merge passes 0 0 0 0 0 0 0
- # Tmp tables 6 0 1 0.67 0.99 0.47 0.99
- # Tmp disk tbl 0 0 0 0 0 0 0
- # Tmp tbl size 745.88k 0 124.31k 82.88k 123.85k 58.38k 123.85k
- # Query size 4.93k 32 826 561.33 793.42 359.08 793.42
- # Boolean:
- # Filesort 66% yes, 33% no
- # Full scan 66% yes, 33% no
- # Tmp table 66% yes, 33% no
- # Profile
- # Rank Query ID Response time Calls R/Call V/M Item
- # ==== ================== ============== ===== ======= ===== =============
- # 1 0xAF149D6E79069F04 251.6022 81.6% 6 41.9337 0.09 SELECT product_auction_instance products sites product_auction_instance products
- # 2 0x600A9E8364E8B864 56.7702 18.4% 3 18.9234 0.03 SELECT
- # Query 1: 0.00 QPS, 0.00x concurrency, ID 0xAF149D6E79069F04 at byte 4427
- # This item is included in the report because it matches --limit.
- # Scores: V/M = 0.09
- # Time range: 2013-12-10 15:22:24 to 2013-12-11 15:12:59
- # Attribute pct total min max avg 95% stddev median
- # ============ === ======= ======= ======= ======= ======= ======= =======
- # Count 66 6
- # Exec time 81 252s 40s 44s 42s 42s 2s 42s
- # Lock time 100 2ms 187us 347us 266us 332us 68us 324us
- # Rows sent 66 6 1 1 1 1 0 1
- # Rows examine 100 164.32M 27.39M 27.39M 27.39M 27.20M 0 27.20M
- # Rows affecte 0 0 0 0 0 0 0 0
- # Rows read 100 164.32M 27.39M 27.39M 27.39M 27.20M 0 27.20M
- # Bytes sent 95 4.83k 824 824 824 824 0 824
- # Merge passes 0 0 0 0 0 0 0 0
- # Tmp tables 100 6 1 1 1 1 0 1
- # Tmp disk tbl 0 0 0 0 0 0 0 0
- # Tmp tbl size 100 745.88k 124.31k 124.31k 124.31k 124.31k 0 124.31k
- # Query size 98 4.84k 826 826 826 826 0 826
- # Boolean:
- # Filesort 100% yes, 0% no
- # Full scan 100% yes, 0% no
- # Tmp table 100% yes, 0% no
- # String:
- # Databases dev_xxxxxxxx
- # Hosts localhost
- # Last errno 0
- # Users root
- # Query_time distribution
- # 1us
- # 10us
- # 100us
- # 1ms
- # 10ms
- # 100ms
- # 1s
- # 10s+ ################################################################
- # Tables
- # SHOW TABLE STATUS FROM `dev_xxxxxx` LIKE 'product_auction_instance'\G
- # SHOW CREATE TABLE `dev_xxxxxx`.`product_auction_instance`\G
- # SHOW TABLE STATUS FROM `dev_xxxxxx` LIKE 'products'\G
- # SHOW CREATE TABLE `dev_xxxxx`.`products`\G
- # SHOW TABLE STATUS FROM `dev_xxxxx` LIKE 'sites'\G
- # SHOW CREATE TABLE `dev_xxxxxx`.`sites`\G
- # EXPLAIN /*!50100 PARTITIONS*/
- SELECT p0_.id AS id0, p0_.start_date AS start_date1, p0_.end_date AS end_date2, p0_.coupon_expiration_date AS coupon_expiration_date3, p0_.status AS status4, p0_.active AS active5, p0_.product_id AS product_id6, p0_.winner_id AS winner_id7 FROM product_auction_instance p0_ INNER JOIN products p1_ ON p0_.product_id = p1_.id INNER JOIN sites s2_ ON p1_.site_id = s2_.id WHERE s2_.code = 'xxxxxxxx' AND p1_.active = 1 AND p1_.featured = 0 AND p0_.active = 1 AND p0_.start_date > CURRENT_TIMESTAMP AND p1_.id NOT IN (SELECT p3_.id FROM product_auction_instance p4_ INNER JOIN products p3_ ON p4_.product_id = p3_.id WHERE p3_.active = 1 AND p3_.featured = 0 AND p4_.active = 1 AND p4_.start_date <= CURRENT_TIMESTAMP AND p4_.end_date >= CURRENT_TIMESTAMP GROUP BY p3_.id) GROUP BY p1_.id ORDER BY p0_.start_date ASC LIMIT 3\G
- # Query 2: 0.00 QPS, 0.00x concurrency, ID 0x600A9E8364E8B864 at byte 7075
- # This item is included in the report because it matches --limit.
- # Scores: V/M = 0.03
- # Time range: 2013-12-10 19:21:10 to 2013-12-11 16:39:28
- # Attribute pct total min max avg 95% stddev median
- # ============ === ======= ======= ======= ======= ======= ======= =======
- # Count 33 3
- # Exec time 18 57s 18s 20s 19s 19s 813ms 18s
- # Lock time 0 0 0 0 0 0 0 0
- # Rows sent 33 3 1 1 1 1 0 1
- # Rows examine 0 0 0 0 0 0 0 0
- # Rows affecte 0 0 0 0 0 0 0 0
- # Rows read 0 0 0 0 0 0 0 0
- # Bytes sent 4 240 80 80 80 80 0 80
- # Merge passes 0 0 0 0 0 0 0 0
- # Tmp tables 0 0 0 0 0 0 0 0
- # Tmp disk tbl 0 0 0 0 0 0 0 0
- # Tmp tbl size 0 0 0 0 0 0 0 0
- # Query size 1 96 32 32 32 32 0 32
- # String:
- # Databases dev_xxxxxx
- # Hosts localhost
- # Last errno 0
- # Users root
- # Query_time distribution
- # 1us
- # 10us
- # 100us
- # 1ms
- # 10ms
- # 100ms
- # 1s
- # 10s+ ################################################################
- # EXPLAIN /*!50100 PARTITIONS*/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement