SHARE
TWEET

Untitled

a guest Jul 19th, 2019 63 in 142 days
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. MySQL 5.6.33-0ubuntu0.1  uptime 6 14:14:31      Fri Jul 19 15:47:48 2019
  2.  
  3. __ Key _________________________________________________________________
  4. Buffer used    51.00k of  32.00M  %Used:   0.16
  5.   Current       5.84M            %Usage:  18.24
  6. Write hit     100.00%
  7. Read hit      100.00%
  8.  
  9. __ Questions ___________________________________________________________
  10. Total          86.92M   152.6/s
  11.   DMS          85.52M   150.1/s  %Total:  98.39
  12.   Com_          3.30M     5.8/s            3.80
  13.   -Unknown      1.90M     3.3/s            2.19
  14.   COM_QUIT      1.09k     0.0/s            0.00
  15. Slow 1 s      470.76k     0.8/s            0.54  %DMS:   0.55  Log:
  16. DMS            85.52M   150.1/s           98.39
  17.   SELECT       79.87M   140.2/s           91.89         93.40
  18.   UPDATE        5.28M     9.3/s            6.08          6.18
  19.   INSERT      363.35k     0.6/s            0.42          0.42
  20.   DELETE          566     0.0/s            0.00          0.00
  21.   REPLACE           0       0/s            0.00          0.00
  22. Com_            3.30M     5.8/s            3.80
  23.   admin_comma   1.90M     3.3/s            2.19
  24.   begin       652.05k     1.1/s            0.75
  25.   commit      649.12k     1.1/s            0.75
  26.  
  27. __ SELECT and Sort _____________________________________________________
  28. Scan          468.75k     0.8/s %SELECT:   0.59
  29. Range           1.52M     2.7/s            1.91
  30. Full join          26     0.0/s            0.00
  31. Range check         0       0/s            0.00
  32. Full rng join   6.71k     0.0/s            0.01
  33. Sort scan       2.20M     3.9/s
  34. Sort range      7.35M    12.9/s
  35. Sort mrg pass   2.75k     0.0/s
  36.  
  37. __ Table Locks _________________________________________________________
  38. Waited              0       0/s  %Total:   0.00
  39. Immediate      91.16M   160.0/s
  40.  
  41. __ Tables ______________________________________________________________
  42. Open              407 of 2048    %Cache:  19.87
  43. Opened            414     0.0/s
  44.  
  45. __ Connections _________________________________________________________
  46. Max used           48 of  500      %Max:   9.60
  47. Total           2.08k     0.0/s
  48.  
  49. __ Created Temp ________________________________________________________
  50. Disk table    765.57k     1.3/s
  51. Table           2.81M     4.9/s    Size:  64.0M
  52. File            6.07k     0.0/s
  53.  
  54. __ Threads _____________________________________________________________
  55. Running             4 of   34
  56. Cached             14 of   50      %Hit:  97.69
  57. Created            48     0.0/s
  58. Slow                0       0/s
  59.  
  60. __ Aborted _____________________________________________________________
  61. Clients         1.98k     0.0/s
  62. Connects            9     0.0/s
  63.  
  64. __ Bytes _______________________________________________________________
  65. Sent          328.29G  576.3k/s
  66. Received       15.57G   27.3k/s
  67.  
  68. __ InnoDB Buffer Pool __________________________________________________
  69. Usage           8.87G of  12.00G  %Used:  73.89
  70. Read hit      100.00%
  71. Pages
  72.   Free        205.34k            %Total:  26.11
  73.   Data        538.00k                     68.41 %Drty:   0.02
  74.   Misc          43084                      5.48
  75.   Latched           0                      0.00
  76. Reads         434.57G  762.8k/s
  77.   From file   315.82k     0.6/s            0.00
  78.   Ahead Rnd         0       0/s
  79.   Ahead Sql                 0/s
  80. Writes         24.56M    43.1/s
  81. Flushes         4.55M     8.0/s
  82. Wait Free           0       0/s
  83.  
  84. __ InnoDB Lock _________________________________________________________
  85. Waits           12782     0.0/s
  86. Current             1
  87. Time acquiring
  88.   Total       4649313 ms
  89.   Average         363 ms
  90.   Max           40102 ms
  91.  
  92. __ InnoDB Data, Pages, Rows ____________________________________________
  93. Data
  94.   Reads       520.08k     0.9/s
  95.   Writes        6.85M    12.0/s
  96.   fsync         3.11M     5.5/s
  97.   Pending
  98.     Reads           0
  99.     Writes          0
  100.     fsync           0
  101.  
  102. Pages
  103.   Created      18.07k     0.0/s
  104.   Read        519.93k     0.9/s
  105.   Written       4.55M     8.0/s
  106.  
  107. Rows
  108.   Deleted         668     0.0/s
  109.   Inserted    363.81k     0.6/s
  110.   Read        293.35G  514.9k/s
  111.   Updated       5.31M     9.3/s
RAW Paste Data
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
 
Top