API tools faq
paste
Advertisement
ianhuet

Untitled

ianhuet
Nov 19th, 2018
617
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.67 KB | None | 0 0
raw download clone embed print report
  1. >> MySQLTuner 1.7.5 - Major Hayden <[email protected]>
  2. >> Bug reports, feature requests, and downloads at http://mysqltuner.com/
  3. >> Run with '--help' for additional options and output filtering
  4.  
  5. [--] Skipped version check for MySQLTuner script
  6. [OK] Currently running supported MySQL version 5.5.60-MariaDB
  7. [OK] Operating on 64-bit architecture
  8.  
  9. -------- Log file Recommendations ------------------------------------------------------------------
  10. [--] Log file: /var/log/mariadb/mariadb.log(45K)
  11. [OK] Log file /var/log/mariadb/mariadb.log exists
  12. [OK] Log file /var/log/mariadb/mariadb.log is readable.
  13. [OK] Log file /var/log/mariadb/mariadb.log is not empty
  14. [OK] Log file /var/log/mariadb/mariadb.log is smaller than 32 Mb
  15. [!!] /var/log/mariadb/mariadb.log contains 1 warning(s).
  16. [!!] /var/log/mariadb/mariadb.log contains 16 error(s).
  17. [--] 31 start(s) detected in /var/log/mariadb/mariadb.log
  18. [--] 1) 181116 0:49:26 [Note] /usr/libexec/mysqld: ready for connections.
  19. [--] 2) 181109 8:28:59 [Note] /usr/libexec/mysqld: ready for connections.
  20. [--] 3) 181109 8:00:12 [Note] /usr/libexec/mysqld: ready for connections.
  21. [--] 4) 181106 23:47:13 [Note] /usr/libexec/mysqld: ready for connections.
  22. [--] 5) 181106 1:22:22 [Note] /usr/libexec/mysqld: ready for connections.
  23. [--] 6) 181029 11:05:08 [Note] /usr/libexec/mysqld: ready for connections.
  24. [--] 7) 181009 9:49:46 [Note] /usr/libexec/mysqld: ready for connections.
  25. [--] 8) 180929 22:48:02 [Note] /usr/libexec/mysqld: ready for connections.
  26. [--] 9) 180827 3:40:02 [Note] /usr/libexec/mysqld: ready for connections.
  27. [--] 10) 180723 23:24:44 [Note] /usr/libexec/mysqld: ready for connections.
  28. [--] 31 shutdown(s) detected in /var/log/mariadb/mariadb.log
  29. [--] 1) 181116 0:48:02 [Note] /usr/libexec/mysqld: Shutdown complete
  30. [--] 2) 181109 8:28:57 [Note] /usr/libexec/mysqld: Shutdown complete
  31. [--] 3) 181109 8:00:09 [Note] /usr/libexec/mysqld: Shutdown complete
  32. [--] 4) 181106 23:47:09 [Note] /usr/libexec/mysqld: Shutdown complete
  33. [--] 5) 181106 1:21:09 [Note] /usr/libexec/mysqld: Shutdown complete
  34. [--] 6) 181029 11:04:05 [Note] /usr/libexec/mysqld: Shutdown complete
  35. [--] 7) 181009 9:48:37 [Note] /usr/libexec/mysqld: Shutdown complete
  36. [--] 8) 180929 22:46:58 [Note] /usr/libexec/mysqld: Shutdown complete
  37. [--] 9) 180827 3:40:00 [Note] /usr/libexec/mysqld: Shutdown complete
  38. [--] 10) 180723 23:23:45 [Note] /usr/libexec/mysqld: Shutdown complete
  39.  
  40. -------- Storage Engine Statistics -----------------------------------------------------------------
  41. [--] Status: +ARCHIVE +Aria +BLACKHOLE +CSV +FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
  42. [--] Data in MyISAM tables: 836M (Tables: 100)
  43. [--] Data in InnoDB tables: 28M (Tables: 356)
  44. [OK] Total fragmented tables: 0
  45.  
  46. -------- Security Recommendations ------------------------------------------------------------------
  47. [OK] There are no anonymous accounts for any database users
  48. [OK] All database users have passwords assigned
  49. [!!] There is no basic password file list!
  50.  
  51. -------- CVE Security Recommendations --------------------------------------------------------------
  52. [--] Skipped due to --cvefile option undefined
  53.  
  54. -------- Performance Metrics -----------------------------------------------------------------------
  55. [--] Up for: 3d 13h 42m 42s (528K q [1.714 qps], 143K conn, TX: 3G, RX: 67M)
  56. [--] Reads / Writes: 97% / 3%
  57. [--] Binary logging is disabled
  58. [--] Physical Memory : 2.0G
  59. [--] Max MySQL memory : 1.6G
  60. [--] Other process memory: 400.6M
  61. [--] Total buffers: 1.2G global + 2.8M per thread (151 max threads)
  62. [--] P_S Max memory usage: 0B
  63. [--] Galera GCache Max memory usage: 0B
  64. [OK] Maximum reached memory usage: 1.2G (61.38% of installed RAM)
  65. [OK] Maximum possible memory usage: 1.6G (81.28% of installed RAM)
  66. [!!] Overall possible memory usage with other process exceeded memory
  67. [OK] Slow queries: 0% (268/528K)
  68. [OK] Highest usage of available connections: 5% (8/151)
  69. [OK] Aborted connections: 0.00% (1/143266)
  70. [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
  71. [!!] Query cache may be disabled by default due to mutex contention.
  72. [OK] Query cache efficiency: 46.5% (202K cached / 436K selects)
  73. [OK] Query cache prunes per day: 0
  74. [OK] Sorts requiring temporary tables: 3% (57 temp sorts / 1K sorts)
  75. [OK] No joins without indexes
  76. [!!] Temporary tables created on disk: 70% (12K on disk / 17K total)
  77. [OK] Thread cache hit rate: 99% (50 created / 143K connections)
  78. [!!] Table cache hit rate: 9% (400 open / 4K opened)
  79. [OK] Open file limit used: 21% (224/1K)
  80. [OK] Table locks acquired immediately: 99% (63K immediate / 63K locks)
  81.  
  82. -------- Performance schema ------------------------------------------------------------------------
  83. [--] Performance schema is disabled.
  84. [--] Memory used by P_S: 0B
  85. [--] Sys schema isn't installed.
  86.  
  87. -------- ThreadPool Metrics ------------------------------------------------------------------------
  88. [--] ThreadPool stat is enabled.
  89. [--] Thread Pool Size: 2 thread(s).
  90. [--] Using default value is good enough for your version (5.5.60-MariaDB)
  91.  
  92. -------- MyISAM Metrics ----------------------------------------------------------------------------
  93. [!!] Key buffer used: 75.7% (25M used / 33M cache)
  94. [OK] Key buffer size / total MyISAM indexes: 32.0M/238.8M
  95. [OK] Read Key buffer hit rate: 100.0% (1B cached / 79K reads)
  96. [OK] Write Key buffer hit rate: 100.0% (18K cached / 18K writes)
  97.  
  98. -------- InnoDB Metrics ----------------------------------------------------------------------------
  99. [--] InnoDB is enabled.
  100. [--] InnoDB Thread Concurrency: 0
  101. [!!] InnoDB File per table is not activated
  102. [OK] InnoDB buffer pool / data size: 756.0M/28.3M
  103. [!!] Ratio InnoDB log file size / InnoDB Buffer pool size (1.32275132275132 %): 5.0M * 2/756.0M should be equal 25%
  104. [OK] InnoDB buffer pool instances: 1
  105. [--] InnoDB Buffer Pool Chunk Size not used or defined in your version
  106. [OK] InnoDB Read buffer efficiency: 99.91% (2333138 hits/ 2335267 total)
  107. [!!] InnoDB Write Log efficiency: 2.25% (33 hits/ 1469 total)
  108. [OK] InnoDB log waits: 0.00% (0 waits / 1436 writes)
  109.  
  110. -------- AriaDB Metrics ----------------------------------------------------------------------------
  111. [--] AriaDB is enabled.
  112. [OK] Aria pagecache size / total Aria indexes: 128.0M/1B
  113. [OK] Aria pagecache hit rate: 99.6% (96K cached / 359 reads)
  114.  
  115. -------- TokuDB Metrics ----------------------------------------------------------------------------
  116. [--] TokuDB is disabled.
  117.  
  118. -------- XtraDB Metrics ----------------------------------------------------------------------------
  119. [--] XtraDB is disabled.
  120.  
  121. -------- RocksDB Metrics ---------------------------------------------------------------------------
  122. [--] RocksDB is disabled.
  123.  
  124. -------- Spider Metrics ----------------------------------------------------------------------------
  125. [--] Spider is disabled.
  126.  
  127. -------- Connect Metrics ---------------------------------------------------------------------------
  128. [--] Connect is disabled.
  129.  
  130. -------- Galera Metrics ----------------------------------------------------------------------------
  131. [--] Galera is disabled.
  132.  
  133. -------- Replication Metrics -----------------------------------------------------------------------
  134. [--] Galera Synchronous replication: NO
  135. [--] No replication slave(s) for this server.
  136. [--] This is a standalone server.
  137.  
  138. -------- Recommendations ---------------------------------------------------------------------------
  139. General recommendations:
  140. Control warning line(s) into /var/log/mariadb/mariadb.log file
  141. Control error line(s) into /var/log/mariadb/mariadb.log file
  142. Dedicate this server to your database for highest performance.
  143. Enable the slow query log to troubleshoot bad queries
  144. Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
  145. When making adjustments, make tmp_table_size/max_heap_table_size equal
  146. Reduce your SELECT DISTINCT queries which have no LIMIT clause
  147. Increase table_open_cache gradually to avoid file descriptor limits
  148. Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
  149. Beware that open_files_limit (1024) variable
  150. should be greater than table_open_cache (400)
  151. Consider installing Sys schema from https://github.com/mysql/mysql-sys
  152. Read this before changing innodb_log_file_size and/or innodb_log_files_in_group: http://bit.ly/2wgkDvS
  153. Variables to adjust:
  154. query_cache_size (=0)
  155. query_cache_type (=0)
  156. tmp_table_size (> 16M)
  157. max_heap_table_size (> 16M)
  158. table_open_cache (> 400)
  159. innodb_file_per_table=ON
  160. innodb_log_file_size should be (=94M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!