Guest User

Untitled

a guest
Dec 16th, 2013
14
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [root@xtradb1 ~]# pt-query-digest /var/lib/mysql/slow.log
  2.  
  3. # 200ms user time, 10ms system time, 23.09M rss, 197.38M vsz
  4. # Current date: Mon Dec 16 11:09:52 2013
  5. # Hostname: xtradb1
  6. # Files: /var/lib/mysql/slow.log
  7. # Overall: 9 total, 2 unique, 0.00 QPS, 0.00x concurrency ________________
  8. # Time range: 2013-12-10 15:22:24 to 2013-12-11 16:39:28
  9. # Attribute total min max avg 95% stddev median
  10. # ============ ======= ======= ======= ======= ======= ======= =======
  11. # Exec time 308s 18s 44s 34s 42s 11s 39s
  12. # Lock time 2ms 0 347us 177us 332us 134us 194us
  13. # Rows sent 9 1 1 1 1 0 1
  14. # Rows examine 164.32M 0 27.39M 18.26M 27.20M 12.82M 27.20M
  15. # Rows affecte 0 0 0 0 0 0 0
  16. # Rows read 164.32M 0 27.39M 18.26M 27.20M 12.82M 27.20M
  17. # Bytes sent 5.06k 80 824 576 793.42 338.06 793.42
  18. # Merge passes 0 0 0 0 0 0 0
  19. # Tmp tables 6 0 1 0.67 0.99 0.47 0.99
  20. # Tmp disk tbl 0 0 0 0 0 0 0
  21. # Tmp tbl size 745.88k 0 124.31k 82.88k 123.85k 58.38k 123.85k
  22. # Query size 4.93k 32 826 561.33 793.42 359.08 793.42
  23. # Boolean:
  24. # Filesort 66% yes, 33% no
  25. # Full scan 66% yes, 33% no
  26. # Tmp table 66% yes, 33% no
  27.  
  28. # Profile
  29. # Rank Query ID Response time Calls R/Call V/M Item
  30. # ==== ================== ============== ===== ======= ===== =============
  31. # 1 0xAF149D6E79069F04 251.6022 81.6% 6 41.9337 0.09 SELECT product_auction_instance products sites product_auction_instance products
  32. # 2 0x600A9E8364E8B864 56.7702 18.4% 3 18.9234 0.03 SELECT
  33.  
  34. # Query 1: 0.00 QPS, 0.00x concurrency, ID 0xAF149D6E79069F04 at byte 4427
  35. # This item is included in the report because it matches --limit.
  36. # Scores: V/M = 0.09
  37. # Time range: 2013-12-10 15:22:24 to 2013-12-11 15:12:59
  38. # Attribute pct total min max avg 95% stddev median
  39. # ============ === ======= ======= ======= ======= ======= ======= =======
  40. # Count 66 6
  41. # Exec time 81 252s 40s 44s 42s 42s 2s 42s
  42. # Lock time 100 2ms 187us 347us 266us 332us 68us 324us
  43. # Rows sent 66 6 1 1 1 1 0 1
  44. # Rows examine 100 164.32M 27.39M 27.39M 27.39M 27.20M 0 27.20M
  45. # Rows affecte 0 0 0 0 0 0 0 0
  46. # Rows read 100 164.32M 27.39M 27.39M 27.39M 27.20M 0 27.20M
  47. # Bytes sent 95 4.83k 824 824 824 824 0 824
  48. # Merge passes 0 0 0 0 0 0 0 0
  49. # Tmp tables 100 6 1 1 1 1 0 1
  50. # Tmp disk tbl 0 0 0 0 0 0 0 0
  51. # Tmp tbl size 100 745.88k 124.31k 124.31k 124.31k 124.31k 0 124.31k
  52. # Query size 98 4.84k 826 826 826 826 0 826
  53. # Boolean:
  54. # Filesort 100% yes, 0% no
  55. # Full scan 100% yes, 0% no
  56. # Tmp table 100% yes, 0% no
  57. # String:
  58. # Databases dev_xxxxxxxx
  59. # Hosts localhost
  60. # Last errno 0
  61. # Users root
  62. # Query_time distribution
  63. # 1us
  64. # 10us
  65. # 100us
  66. # 1ms
  67. # 10ms
  68. # 100ms
  69. # 1s
  70. # 10s+ ################################################################
  71. # Tables
  72. # SHOW TABLE STATUS FROM `dev_xxxxxx` LIKE 'product_auction_instance'\G
  73. # SHOW CREATE TABLE `dev_xxxxxx`.`product_auction_instance`\G
  74. # SHOW TABLE STATUS FROM `dev_xxxxxx` LIKE 'products'\G
  75. # SHOW CREATE TABLE `dev_xxxxx`.`products`\G
  76. # SHOW TABLE STATUS FROM `dev_xxxxx` LIKE 'sites'\G
  77. # SHOW CREATE TABLE `dev_xxxxxx`.`sites`\G
  78. # EXPLAIN /*!50100 PARTITIONS*/
  79. 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
  80.  
  81. # Query 2: 0.00 QPS, 0.00x concurrency, ID 0x600A9E8364E8B864 at byte 7075
  82. # This item is included in the report because it matches --limit.
  83. # Scores: V/M = 0.03
  84. # Time range: 2013-12-10 19:21:10 to 2013-12-11 16:39:28
  85. # Attribute pct total min max avg 95% stddev median
  86. # ============ === ======= ======= ======= ======= ======= ======= =======
  87. # Count 33 3
  88. # Exec time 18 57s 18s 20s 19s 19s 813ms 18s
  89. # Lock time 0 0 0 0 0 0 0 0
  90. # Rows sent 33 3 1 1 1 1 0 1
  91. # Rows examine 0 0 0 0 0 0 0 0
  92. # Rows affecte 0 0 0 0 0 0 0 0
  93. # Rows read 0 0 0 0 0 0 0 0
  94. # Bytes sent 4 240 80 80 80 80 0 80
  95. # Merge passes 0 0 0 0 0 0 0 0
  96. # Tmp tables 0 0 0 0 0 0 0 0
  97. # Tmp disk tbl 0 0 0 0 0 0 0 0
  98. # Tmp tbl size 0 0 0 0 0 0 0 0
  99. # Query size 1 96 32 32 32 32 0 32
  100. # String:
  101. # Databases dev_xxxxxx
  102. # Hosts localhost
  103. # Last errno 0
  104. # Users root
  105. # Query_time distribution
  106. # 1us
  107. # 10us
  108. # 100us
  109. # 1ms
  110. # 10ms
  111. # 100ms
  112. # 1s
  113. # 10s+ ################################################################
  114. # EXPLAIN /*!50100 PARTITIONS*/
RAW Paste Data