API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 16th, 2013
51
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.29 KB | None | 0 0
raw download clone embed print report
  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*/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!