Guest User

Untitled

a guest
Oct 19th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.38 KB | None | 0 0
  1. MySQL 5.1.41-3ubuntu12. uptime 0 1:57:29 Sat Aug 20 12:12:54 2011
  2.  
  3. __ Key _________________________________________________________________
  4. Buffer used 14.16M of 16.00M %Used: 88.48
  5. Current 1.84M %Usage: 11.52
  6. Write hit 92.62%
  7. Read hit 98.80%
  8.  
  9. __ Questions ___________________________________________________________
  10. Total 70.73k 10.0/s
  11. QC Hits 33.05k 4.7/s %Total: 46.73
  12. DMS 24.82k 3.5/s 35.10
  13. Com_ 10.01k 1.4/s 14.15
  14. COM_QUIT 3.82k 0.5/s 5.40
  15. -Unknown 970 0.1/s 1.37
  16. Slow 10 s 116 0.0/s 0.16 %DMS: 0.47 Log: OFF
  17. DMS 24.82k 3.5/s 35.10
  18. SELECT 24.78k 3.5/s 35.04 99.82
  19. UPDATE 42 0.0/s 0.06 0.17
  20. DELETE 1 0.0/s 0.00 0.00
  21. INSERT 1 0.0/s 0.00 0.00
  22. REPLACE 0 0/s 0.00 0.00
  23. Com_ 10.01k 1.4/s 14.15
  24. change_db 5.25k 0.7/s 7.42
  25. set_option 3.81k 0.5/s 5.39
  26. show_tables 651 0.1/s 0.92
  27.  
  28. __ SELECT and Sort _____________________________________________________
  29. Scan 3.57k 0.5/s %SELECT: 14.40
  30. Range 4 0.0/s 0.02
  31. Full join 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 1 0.0/s
  35. Sort range 12 0.0/s
  36. Sort mrg pass 0 0/s
  37.  
  38. __ Query Cache _________________________________________________________
  39. Memory usage 1.20M of 16.00M %Used: 7.49
  40. Block Fragmnt 5.64%
  41. Hits 33.05k 4.7/s
  42. Inserts 199 0.0/s
  43. Insrt:Prune 199:1 0.0/s
  44. Hit:Insert 166.08:1
  45.  
  46. __ Table Locks _________________________________________________________
  47. Waited 12 0.0/s %Total: 0.42
  48. Immediate 2.83k 0.4/s
  49.  
  50. __ Tables ______________________________________________________________
  51. Open 63 of 64 %Cache: 98.44
  52. Opened 12.10k 1.7/s
  53.  
  54. __ Connections _________________________________________________________
  55. Max used 89 of 151 %Max: 58.94
  56. Total 4.78k 0.7/s
  57.  
  58. __ Created Temp ________________________________________________________
  59. Disk table 895 0.1/s
  60. Table 2.47k 0.4/s Size: 16.0M
  61. File 5 0.0/s
  62.  
  63. __ Threads _____________________________________________________________
  64. Running 1 of 2
  65. Cached 7 of 8 %Hit: 62.19
  66. Created 1.81k 0.3/s
  67. Slow 1 0.0/s
  68.  
  69. __ Aborted _____________________________________________________________
  70. Clients 1.93k 0.3/s
  71. Connects 5 0.0/s
  72.  
  73. __ Bytes _______________________________________________________________
  74. Sent 2.66G 378.1k/s
  75. Received 9.59M 1.4k/s
  76.  
  77. __ InnoDB Buffer Pool __________________________________________________
  78. Usage 320.00k of 8.00M %Used: 3.91
  79. Read hit 94.86%
  80. Pages
  81. Free 492 %Total: 96.09
  82. Data 20 3.91 %Drty: 0.00
  83. Misc 0 0.00
  84. Latched 0 0.00
  85. Reads 253 0.0/s
  86. From file 13 0.0/s 5.14
  87. Ahead Rnd 1 0.0/s
  88. Ahead Sql 0 0/s
  89. Writes 0 0/s
  90. Flushes 0 0/s
  91. Wait Free 0 0/s
  92.  
  93. __ InnoDB Lock _________________________________________________________
  94. Waits 0 0/s
  95. Current 0
  96. Time acquiring
  97. Total 0 ms
  98. Average 0 ms
  99. Max 0 ms
  100.  
  101. __ InnoDB Data, Pages, Rows ____________________________________________
  102. Data
  103. Reads 26 0.0/s
  104. Writes 3 0.0/s
  105. fsync 3 0.0/s
  106. Pending
  107. Reads 0
  108. Writes 0
  109. fsync 0
  110.  
  111. Pages
  112. Created 0 0/s
  113. Read 20 0.0/s
  114. Written 0 0/s
  115.  
  116. Rows
  117. Deleted 0 0/s
  118. Inserted 0 0/s
  119. Read 0 0/s
  120. Updated 0 0/s
Add Comment
Please, Sign In to add comment