API tools faq
paste
Guest User

systemstats

a guest
May 2nd, 2020
136
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.46 KB | None | 0 0
raw download clone embed print report
  1. [--] Skipped version check for MySQLTuner script
  2. [OK] Logged in using credentials from debian maintenance account.
  3. [OK] Currently running supported MySQL version 5.7.29-0ubuntu0.18.04.1
  4. [OK] Operating on 64-bit architecture
  5.  
  6. -------- Log file Recommendations ------------------------------------------------------------------
  7. [--] Log file: /var/log/mysql/error.log(16K)
  8. [OK] Log file /var/log/mysql/error.log exists
  9. [OK] Log file /var/log/mysql/error.log is readable.
  10. [OK] Log file /var/log/mysql/error.log is not empty
  11. [OK] Log file /var/log/mysql/error.log is smaller than 32 Mb
  12. [!!] /var/log/mysql/error.log contains 3 warning(s).
  13. [OK] /var/log/mysql/error.log doesn't contain any error.
  14. [--] 1 start(s) detected in /var/log/mysql/error.log
  15. [--] 1) 2020-05-02T07:45:28.563284Z 0 [Note] /usr/sbin/mysqld: ready for connections.
  16. [--] 0 shutdown(s) detected in /var/log/mysql/error.log
  17.  
  18. -------- Storage Engine Statistics -----------------------------------------------------------------
  19. [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
  20. [--] Data in ARCHIVE tables: 230K (Tables: 11)
  21. [--] Data in MyISAM tables: 8K (Tables: 2)
  22. [--] Data in InnoDB tables: 87M (Tables: 196)
  23. [OK] Total fragmented tables: 0
  24.  
  25. -------- Security Recommendations ------------------------------------------------------------------
  26. [OK] There are no anonymous accounts for any database users
  27. [OK] All database users have passwords assigned
  28. [--] There are 612 basic passwords in the list.
  29.  
  30. -------- CVE Security Recommendations --------------------------------------------------------------
  31. [OK] NO SECURITY CVE FOUND FOR YOUR VERSION
  32.  
  33. -------- Performance Metrics -----------------------------------------------------------------------
  34. [--] Up for: 6m 30s (6K q [16.449 qps], 33 conn, TX: 1M, RX: 1M)
  35. [--] Reads / Writes: 98% / 2%
  36. [--] Binary logging is disabled
  37. [--] Physical Memory : 985.2M
  38. [--] Max MySQL memory : 766.3M
  39. [--] Other process memory: 38.2M
  40. [--] Total buffers: 660.0M global + 1.1M per thread (100 max threads)
  41. [--] P_S Max memory usage: 72B
  42. [--] Galera GCache Max memory usage: 0B
  43. [OK] Maximum reached memory usage: 671.7M (68.18% of installed RAM)
  44. [OK] Maximum possible memory usage: 766.3M (77.78% of installed RAM)
  45. [OK] Overall possible memory usage with other process is compatible with memory available
  46. [OK] Slow queries: 0% (0/6K)
  47. [OK] Highest usage of available connections: 11% (11/100)
  48. [OK] Aborted connections: 0.00% (0/33)
  49. [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
  50. [!!] Query cache may be disabled by default due to mutex contention.
  51. [!!] Query cache efficiency: 0.0% (0 cached / 6K selects)
  52. [OK] Query cache prunes per day: 0
  53. [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 48 sorts)
  54. [OK] No joins without indexes
  55. [OK] Temporary tables created on disk: 0% (0 on disk / 957 total)
  56. [OK] Thread cache hit rate: 66% (11 created / 33 connections)
  57. [OK] Table cache hit rate: 97% (300 open / 307 opened)
  58. [OK] Open file limit used: 0% (14/5K)
  59. [OK] Table locks acquired immediately: 100% (103 immediate / 103 locks)
  60.  
  61. -------- Performance schema ------------------------------------------------------------------------
  62. [--] Memory used by P_S: 72B
  63. [--] Sys schema is installed.
  64.  
  65. -------- ThreadPool Metrics ------------------------------------------------------------------------
  66. [--] ThreadPool stat is disabled.
  67.  
  68. -------- MyISAM Metrics ----------------------------------------------------------------------------
  69. [!!] Key buffer used: 18.3% (3M used / 16M cache)
  70. [OK] Key buffer size / total MyISAM indexes: 16.0M/51.0K
  71. [!!] Read Key buffer hit rate: 50.0% (6 cached / 3 reads)
  72.  
  73. -------- InnoDB Metrics ----------------------------------------------------------------------------
  74. [--] InnoDB is enabled.
  75. [--] InnoDB Thread Concurrency: 8
  76. [OK] InnoDB File per table is activated
  77. [OK] InnoDB buffer pool / data size: 128.0M/87.5M
  78. [!!] Ratio InnoDB log file size / InnoDB Buffer pool size (12.5 %): 8.0M * 2/128.0M should be equal 25%
  79. [OK] InnoDB buffer pool instances: 1
  80. [--] Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s)
  81. [OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
  82. [OK] InnoDB Read buffer efficiency: 97.35% (26606 hits/ 27329 total)
  83. [!!] InnoDB Write Log efficiency: 65.68% (155 hits/ 236 total)
  84. [OK] InnoDB log waits: 0.00% (0 waits / 81 writes)
  85.  
  86. -------- AriaDB Metrics ----------------------------------------------------------------------------
  87. [--] AriaDB is disabled.
  88.  
  89. -------- TokuDB Metrics ----------------------------------------------------------------------------
  90. [--] TokuDB is disabled.
  91.  
  92. -------- XtraDB Metrics ----------------------------------------------------------------------------
  93. [--] XtraDB is disabled.
  94.  
  95. -------- RocksDB Metrics ---------------------------------------------------------------------------
  96. [--] RocksDB is disabled.
  97.  
  98. -------- Spider Metrics ----------------------------------------------------------------------------
  99. [--] Spider is disabled.
  100.  
  101. -------- Connect Metrics ---------------------------------------------------------------------------
  102. [--] Connect is disabled.
  103.  
  104. -------- Galera Metrics ----------------------------------------------------------------------------
  105. [--] Galera is disabled.
  106.  
  107. -------- Replication Metrics -----------------------------------------------------------------------
  108. [--] Galera Synchronous replication: NO
  109. [--] No replication slave(s) for this server.
  110. [--] This is a standalone server.
  111.  
  112. -------- Recommendations ---------------------------------------------------------------------------
  113. General recommendations:
  114. Control warning line(s) into /var/log/mysql/error.log file
  115. MySQL started within last 24 hours - recommendations may be inaccurate
  116. Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
  117. Variables to adjust:
  118. query_cache_size (=0)
  119. query_cache_type (=0)
  120. query_cache_limit (> 2M, or use smaller result sets)
  121. innodb_log_file_size * innodb_log_files_in_group should be equal to 1/4 of buffer pool size (=64M) if possible.
  122.  
  123.  
  124.  
  125.  
  126.  
  127. ----------------------------------> TOP
  128.  
  129. Tasks: 99 total, 9 running, 49 sleeping, 0 stopped, 0 zombie
  130. %Cpu(s): 99.3 us, 0.7 sy, 0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
  131. KiB Mem : 1008848 total, 108832 free, 736244 used, 163772 buff/cache
  132. KiB Swap: 0 total, 0 free, 0 used. 96380 avail Mem
  133.  
  134. PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
  135. 11793 www-data 20 0 591888 101708 21552 R 12.6 10.1 1:30.76 /usr/sbin/apache2 -k start
  136. 12042 www-data 20 0 547104 71044 36108 R 12.6 7.0 1:12.34 /usr/sbin/apache2 -k start
  137. 12131 www-data 20 0 544772 55332 21272 R 12.6 5.5 0:58.75 /usr/sbin/apache2 -k start
  138. 12132 www-data 20 0 544768 54636 21228 R 12.6 5.4 0:53.21 /usr/sbin/apache2 -k start
  139. 12136 www-data 20 0 544768 53440 21100 R 12.6 5.3 0:40.43 /usr/sbin/apache2 -k start
  140. 12137 www-data 20 0 538916 64004 35980 R 12.6 6.3 0:15.99 /usr/sbin/apache2 -k start
  141. 12049 www-data 20 0 559124 68204 20432 R 12.3 6.8 1:00.66 /usr/sbin/apache2 -k start
  142. 12130 www-data 20 0 546648 55304 21272 R 12.3 5.5 1:00.38 /usr/sbin/apache2 -k start
  143. 11808 root 20 0 108324 1380 0 S 0.3 0.1 0:00.08 sshd: root@pts/0
  144. 14975 root 20 0 42276 3776 3168 R 0.3 0.4 0:00.04 top
  145. 1 root 20 0 225492 2820 328 S 0.0 0.3 0:02.55 /sbin/init
  146. 2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 [kthreadd]
  147. 4 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [kworker/0:0H]
  148. 6 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [mm_percpu_wq]
  149. 7 root 20 0 0 0 0 S 0.0 0.0 0:01.06 [ksoftirqd/0]
  150. 8 root 20 0 0 0 0 I 0.0 0.0 0:03.70 [rcu_sched]
  151. 9 root 20 0 0 0 0 I 0.0 0.0 0:00.00 [rcu_bh]
  152. 10 root rt 0 0 0 0 S 0.0 0.0 0:00.00 [migration/0]
  153. 11 root rt 0 0 0 0 S 0.0 0.0 0:00.31 [watchdog/0]
  154. 12 root 20 0 0 0 0 S 0.0 0.0 0:00.00 [cpuhp/0]
  155. 13 root 20 0 0 0 0 S 0.0 0.0 0:00.00 [kdevtmpfs]
  156. 14 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [netns]
  157. 15 root 20 0 0 0 0 S 0.0 0.0 0:00.00 [rcu_tasks_kthre]
  158. 16 root 20 0 0 0 0 S 0.0 0.0 0:00.00 [kauditd]
  159. 17 root 20 0 0 0 0 S 0.0 0.0 0:00.03 [khungtaskd]
  160. 18 root 20 0 0 0 0 S 0.0 0.0 0:00.01 [oom_reaper]
  161. 19 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [writeback]
  162. 20 root 20 0 0 0 0 S 0.0 0.0 0:00.00 [kcompactd0]
  163. 21 root 25 5 0 0 0 S 0.0 0.0 0:00.00 [ksmd]
  164. 22 root 39 19 0 0 0 S 0.0 0.0 0:00.00 [khugepaged]
  165. 23 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [crypto]
  166. 24 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [kintegrityd]
  167. 25 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [kblockd]
  168. 26 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [ata_sff]
  169. 27 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [md]
  170. 28 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [edac-poller]
  171. 29 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [devfreq_wq]
  172. 30 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [watchdogd]
  173. 34 root 20 0 0 0 0 S 0.0 0.0 7:22.13 [kswapd0]
  174. 35 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [kworker/u3:0]
  175. 36 root 20 0 0 0 0 S 0.0 0.0 0:00.00 [ecryptfs-kthrea]
  176. 78 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [kthrotld]
  177. 79 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [acpi_thermal_pm]
  178. 80 root 20 0 0 0 0 S 0.0 0.0 0:00.00 [scsi_eh_0]
  179. 81 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [scsi_tmf_0]
  180. 82 root 20 0 0 0 0 S 0.0 0.0 0:00.00 [scsi_eh_1]
  181. 83 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [scsi_tmf_1]
  182. 89 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [ipv6_addrconf]
  183. 98 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [kstrp]
  184. 115 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [charger_manager]
  185. 164 root 20 0 0 0 0 S 0.0 0.0 0:00.00 [scsi_eh_2]
  186. 165 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [scsi_tmf_2]
  187. 276 root 0 -20 0 0 0 I 0.0 0.0 0:00.00 [raid5wq]
  188.  
  189.  
  190.  
  191. -------------------------> ulimit -a
  192.  
  193. core file size (blocks, -c) 0
  194. data seg size (kbytes, -d) unlimited
  195. scheduling priority (-e) 0
  196. file size (blocks, -f) unlimited
  197. pending signals (-i) 3838
  198. max locked memory (kbytes, -l) 16384
  199. max memory size (kbytes, -m) unlimited
  200. open files (-n) 1024
  201. pipe size (512 bytes, -p) 8
  202. POSIX message queues (bytes, -q) 819200
  203. real-time priority (-r) 0
  204. stack size (kbytes, -s) 8192
  205. cpu time (seconds, -t) unlimited
  206. max user processes (-u) 3838
  207. virtual memory (kbytes, -v) unlimited
  208. file locks (-x) unlimited
  209.  
  210.  
  211. -------------------------> iostat
  212.  
  213. Linux 4.15.0-99-generic (ubuntu-s-1vcpu-1gb-fra1-01) 05/02/20 _x86_64_ (1 CPU)
  214.  
  215. avg-cpu: %user %nice %system %iowait %steal %idle
  216. 79.84 0.01 1.52 0.05 0.01 18.57
  217.  
  218. Device r/s w/s rMB/s wMB/s rrqm/s wrqm/s %rrqm %wrqm r_await w_await aqu-sz rareq-sz wareq-sz svctm %util
  219. loop0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00
  220. vda 124.07 2.93 3.12 0.12 0.08 0.81 0.06 21.56 0.63 3.62 0.08 25.76 41.97 0.07 0.89
  221.  
  222. avg-cpu: %user %nice %system %iowait %steal %idle
  223. 97.61 0.00 2.39 0.00 0.00 0.00
  224.  
  225. Device r/s w/s rMB/s wMB/s rrqm/s wrqm/s %rrqm %wrqm r_await w_await aqu-sz rareq-sz wareq-sz svctm %util
  226. loop0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  227. vda 376.69 11.55 1.50 0.20 0.00 5.78 0.00 33.33 0.49 2.76 0.18 4.08 17.86 0.03 1.04
  228.  
  229. avg-cpu: %user %nice %system %iowait %steal %idle
  230. 99.00 0.00 1.00 0.00 0.00 0.00
  231.  
  232. Device r/s w/s rMB/s wMB/s rrqm/s wrqm/s %rrqm %wrqm r_await w_await aqu-sz rareq-sz wareq-sz svctm %util
  233. loop0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  234. vda 0.00 4.81 0.00 0.09 0.00 1.40 0.00 22.58 0.00 0.83 0.00 0.00 18.50 0.00 0.00
Add Comment
Please, Sign In to add comment
Public Pastes
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!