Advertisement
Guest User

Untitled

a guest
Sep 28th, 2015
53
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. MySQL 5.5.42-cll uptime 0 20:49:19 Mon Sep 28 10:06:26 2015
  2.  
  3. __ Key _________________________________________________________________
  4. Buffer used 0 of 0 %Used: 0.00
  5. Current 0 %Usage: 0.00
  6. Write hit 0.00%
  7. Read hit 0.00%
  8.  
  9. __ Questions ___________________________________________________________
  10. Total 6.03M 80.4/s
  11. QC Hits 2.77M 37.0/s %Total: 46.03
  12. DMS 1.73M 23.0/s 28.63
  13. Com_ 1.45M 19.3/s 24.02
  14. COM_QUIT 288.65k 3.9/s 4.79
  15. -Unknown 209.56k 2.8/s 3.48
  16. Slow 1 s 10.48k 0.1/s 0.17 %DMS: 0.61 Log: ON
  17. DMS 1.73M 23.0/s 28.63
  18. SELECT 1.30M 17.4/s 21.58 75.35
  19. UPDATE 285.41k 3.8/s 4.73 16.54
  20. DELETE 74.06k 1.0/s 1.23 4.29
  21. INSERT 60.54k 0.8/s 1.00 3.51
  22. REPLACE 5.40k 0.1/s 0.09 0.31
  23. Com_ 1.45M 19.3/s 24.02
  24. set_option 784.31k 10.5/s 13.01
  25. change_db 299.26k 4.0/s 4.96
  26. admin_comma 206.35k 2.8/s 3.42
  27.  
  28. __ SELECT and Sort _____________________________________________________
  29. Scan 268.43k 3.6/s %SELECT: 20.64
  30. Range 275.54k 3.7/s 21.19
  31. Full join 9.47k 0.1/s 0.73
  32. Range check 29.06k 0.4/s 2.23
  33. Full rng join 6 0.0/s 0.00
  34. Sort scan 172.26k 2.3/s
  35. Sort range 102.19k 1.4/s
  36. Sort mrg pass 4.89k 0.1/s
  37.  
  38. __ Query Cache _________________________________________________________
  39. Memory usage 411.31M of 768.00M %Used: 53.56
  40. Block Fragmnt 4.50%
  41. Hits 2.77M 37.0/s
  42. Inserts 1.08M 14.3/s
  43. Insrt:Prune 5.08:1 11.5/s
  44. Hit:Insert 2.58:1
  45.  
  46. __ Table Locks _________________________________________________________
  47. Waited 2.80k 0.0/s %Total: 0.11
  48. Immediate 2.46M 32.8/s
  49.  
  50. __ Tables ______________________________________________________________
  51. Open 728 of 728 %Cache: 100.00
  52. Opened 3.45M 46.0/s
  53.  
  54. __ Connections _________________________________________________________
  55. Max used 64 of 200 %Max: 32.00
  56. Total 288.73k 3.9/s
  57.  
  58. __ Created Temp ________________________________________________________
  59. Disk table 173.57k 2.3/s
  60. Table 371.59k 5.0/s Size: 1.0G
  61. File 9.16k 0.1/s
  62.  
  63. __ Threads _____________________________________________________________
  64. Running 1 of 6
  65. Cached 9 of 12 %Hit: 99.69
  66. Created 883 0.0/s
  67. Slow 0 0/s
  68.  
  69. __ Aborted _____________________________________________________________
  70. Clients 152 0.0/s
  71. Connects 113 0.0/s
  72.  
  73. __ Bytes _______________________________________________________________
  74. Sent 294.20G 3.9M/s
  75. Received 1.07G 14.2k/s
  76.  
  77. __ InnoDB Buffer Pool __________________________________________________
  78. Usage 759.97M of 759.98M %Used: 100.00
  79. Read hit 99.82%
  80. Pages
  81. Free 1 %Total: 0.00
  82. Data 48.39k 99.48 %Drty: 0.00
  83. Misc 250 0.51
  84. Latched 0.00
  85. Reads 39.83M 531.4/s
  86. From file 72.79k 1.0/s 0.18
  87. Ahead Rnd 0 0/s
  88. Ahead Sql 0/s
  89. Writes 147.09k 2.0/s
  90. Flushes 35.69k 0.5/s
  91. Wait Free 0 0/s
  92.  
  93. __ InnoDB Lock _________________________________________________________
  94. Waits 5 0.0/s
  95. Current 0
  96. Time acquiring
  97. Total 4536 ms
  98. Average 907 ms
  99. Max 4535 ms
  100.  
  101. __ InnoDB Data, Pages, Rows ____________________________________________
  102. Data
  103. Reads 78.04k 1.0/s
  104. Writes 53.82k 0.7/s
  105. fsync 24.84k 0.3/s
  106. Pending
  107. Reads 0
  108. Writes 0
  109. fsync 0
  110.  
  111. Pages
  112. Created 1.13k 0.0/s
  113. Read 73.40k 1.0/s
  114. Written 35.69k 0.5/s
  115.  
  116. Rows
  117. Deleted 2.64k 0.0/s
  118. Inserted 9.21k 0.1/s
  119. Read 8.40M 112.0/s
  120. Updated 4.83k 0.1/s
Advertisement
RAW Paste Data Copied
Advertisement