Guest User

Untitled

a guest
Mar 26th, 2015
248
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. MySQL 10.0.17-MariaDB-1 uptime 1 0:59:28 Thu Mar 26 13:25:53 2015
  2.  
  3. __ Key _________________________________________________________________
  4. Buffer used 47.00k of 128.00M %Used: 0.04
  5. Current 23.39M %Usage: 18.28
  6. Write hit 14.88%
  7. Read hit 100.00%
  8.  
  9. __ Questions ___________________________________________________________
  10. Total 204.50M 2.3k/s
  11. DMS 145.95M 1.6k/s %Total: 71.37
  12. Com_ 35.21M 391.3/s 17.22
  13. COM_QUIT 24.58M 273.2/s 12.02
  14. -Unknown 1.87M 20.8/s 0.92
  15. QC Hits 638.12k 7.1/s 0.31
  16. Slow 10 s 25 0.0/s 0.00 %DMS: 0.00 Log:
  17. DMS 145.95M 1.6k/s 71.37
  18. SELECT 114.30M 1.3k/s 55.89 78.31
  19. UPDATE 20.38M 226.6/s 9.97 13.97
  20. INSERT 11.10M 123.4/s 5.43 7.61
  21. DELETE 166.11k 1.8/s 0.08 0.11
  22. REPLACE 0 0/s 0.00 0.00
  23. Com_ 35.21M 391.3/s 17.22
  24. set_option 24.58M 273.3/s 12.02
  25. call_proced 10.60M 117.8/s 5.18
  26. begin 6.74k 0.1/s 0.00
  27.  
  28. __ SELECT and Sort _____________________________________________________
  29. Scan 1.29M 14.3/s %SELECT: 1.13
  30. Range 24.30M 270.1/s 21.26
  31. Full join 52 0.0/s 0.00
  32. Range check 0 0/s 0.00
  33. Full rng join 0 0/s 0.00
  34. Sort scan 11.46M 127.4/s
  35. Sort range 11.86M 131.8/s
  36. Sort mrg pass 469 0.0/s
  37.  
  38. __ Query Cache _________________________________________________________
  39. Memory usage 823.41k of 128.00M %Used: 0.63
  40. Block Fragmnt 15.04%
  41. Hits 638.12k 7.1/s
  42. Inserts 35.26M 391.9/s
  43. Insrt:Prune 35.26M:1 391.9/s
  44. Hit:Insert 0.02:1
  45.  
  46. __ Table Locks _________________________________________________________
  47. Waited 0 0/s %Total: 0.00
  48. Immediate 248.51M 2.8k/s
  49.  
  50. __ Tables ______________________________________________________________
  51. Open 611 of 2048 %Cache: 29.83
  52. Opened 549 0.0/s
  53.  
  54. __ Connections _________________________________________________________
  55. Max used 116 of 200 %Max: 58.00
  56. Total 24.58M 273.3/s
  57.  
  58. __ Created Temp ________________________________________________________
  59. Disk table 44 0.0/s
  60. Table 11.49M 127.7/s Size: 64.0M
  61. File 617 0.0/s
  62.  
  63. __ Threads _____________________________________________________________
  64. Running 39 of 58
  65. Cached 60 of 128 %Hit: 100
  66. Created 118 0.0/s
  67. Slow 0 0/s
  68.  
  69. __ Aborted _____________________________________________________________
  70. Clients 16.39k 0.2/s
  71. Connects 0 0/s
  72.  
  73. __ Bytes _______________________________________________________________
  74. Sent 40.71G 452.5k/s
  75. Received 48.24G 536.2k/s
  76.  
  77. __ InnoDB Buffer Pool __________________________________________________
  78. Usage 3.87G of 4.00G %Used: 96.87
  79. Read hit 100.00%
  80. Pages
  81. Free 8.19k %Total: 3.13
  82. Data 232.84k 88.82 %Drty: 1.43
  83. Misc 21105 8.05
  84. Latched 0 0.00
  85. Reads 99.80G 1.1M/s
  86. From file 205.98k 2.3/s 0.00
  87. Ahead Rnd 0 0/s
  88. Ahead Sql 0/s
  89. Writes 319.12M 3.5k/s
  90. Flushes 6.48M 72.0/s
  91. Wait Free 0 0/s
  92.  
  93. __ InnoDB Lock _________________________________________________________
  94. Waits 45731 0.5/s
  95. Current 9
  96. Time acquiring
  97. Total 1650246 ms
  98. Average 36 ms
  99. Max 2785 ms
  100.  
  101. __ InnoDB Data, Pages, Rows ____________________________________________
  102. Data
  103. Reads 405.30k 4.5/s
  104. Writes 6.88M 76.5/s
  105. fsync 768.54k 8.5/s
  106. Pending
  107. Reads 0
  108. Writes 0
  109. fsync 0
  110.  
  111. Pages
  112. Created 138.63k 1.5/s
  113. Read 405.23k 4.5/s
  114. Written 6.48M 72.0/s
  115.  
  116. Rows
  117. Deleted 6.98M 77.6/s
  118. Inserted 10.81M 120.2/s
  119. Read 54.90G 610.2k/s
  120. Updated 47.15M 524.1/s
RAW Paste Data