Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-969

LP #997072: pt-query-digest reporting 4G for data on administrator command

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Jay Janssen last update 26-10-2012 17:56:16

      1. Query 15: 0 QPS, 0x concurrency, ID 0x44AE35A182869033 at byte 198286001
      2. This item is included in the report because it matches --limit.
      3. Scores: Apdex = 1.00 [1.0], V/M = 0.00
      4. Query_time sparkline: | ^_ |
      5. Attribute pct total min max avg 95% stddev median
      6. ============ === ======= ======= ======= ======= ======= ======= =======
      7. Count 18 148716
      8. Exec time 1 5s 15us 319us 33us 40us 5us 31us
      9. Lock time 0 0 0 0 0 0 0 0
      10. Rows sent 0 0 0 0 0 0 0 0
      11. Rows examine 0 0 0 0 0 0 0 0
      12. Rows affecte 0 0 0 0 0 0 0 0
      13. Rows read 0 0 0 0 0 0 0 0
      14. Bytes sent 83 1.91T 0 4.00G 13.46M 102.22 202.06M 102.22
      15. Merge passes 49 339.37G 0 4.00G 2.34M 0.99 69.64M 0
      16. Tmp tables 50 318.07G 0 4.00G 2.19M 0 79.89M 0
      17. Tmp disk tbl 50 194.88G 0 4.00G 1.34M 0 54.39M 0
      18. Tmp tbl size 51 336.44G 0 4.00G 2.32M 0 73.59M 0
      19. Query size 9 4.25M 30 30 30 30 0 30
      20. InnoDB:
      21. IO r bytes 50 84.59G 0 4.00G 733.90k 0 42.00M 0
      22. IO r ops 48 45.00G 0 4.00G 390.41k 0 26.02M 0
      23. IO r wait 51 191681302069s 0 4223245659s 1585991s 0 36903369s 0
      24. pages distin 51 171.66G 0 4.00G 1.45M 6.98 56.13M 2.90
      25. queue wait 51 163124669933s 0 4203828092s 1349711s 0 29931791s 0
      26. rec lock wai 51 219562386455s 0 3840637070s 1816682s 0 35066311s 0
      27. Boolean:
      28. Filesort 2% yes, 97% no
      29. Filesort on 0% yes, 99% no
      30. Full join 1% yes, 98% no
      31. Full scan 1% yes, 98% no
      32. QC Hit 1% yes, 98% no
      33. Tmp table 2% yes, 97% no
      34. Tmp table on 2% yes, 97% no
      35. String:
      36. Databases stumble
      37. Hosts
      38. InnoDB trxID 0 (614/0%), 3 (347/0%), 6973726576... (152/0%)... 118238 more
      39. Last errno 0 (129413/87%), 4294967295 (4542/3%)... 6665 more
      40. Users Sequai (142108/95%), chaiNgwae (6608/4%)
      41. Query_time distribution
      42. 1us
      43. 10us ################################################################
      44. 100us #
      45. 1ms
      46. 10ms
      47. 100ms
      48. 1s
      49. 10s+
        administrator command: Init DB\G

      This is skewing the digest summaries.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: