Guest User

Untitled

a guest
Feb 19th, 2020
73
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. >> MySQLTuner 1.7.2 - Major Hayden <major@mhtx.net>
  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] Logged in using credentials passed on the command line
  7. [OK] Currently running supported MySQL version 5.7.29-0ubuntu0.18.04.1
  8. [OK] Operating on 64-bit architecture
  9.  
  10. -------- Log file Recommendations ------------------------------------------------------------------
  11. [--] Log file: ./0.err(0B)
  12. [!!] Log file ./0.err doesn't exist
  13. [!!] Log file ./0.err isn't readable.
  14.  
  15. -------- Storage Engine Statistics -----------------------------------------------------------------
  16. [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
  17. [--] Data in InnoDB tables: 561M (Tables: 24)
  18. [!!] Total fragmented tables: 1
  19.  
  20. -------- Security Recommendations ------------------------------------------------------------------
  21. [OK] There are no anonymous accounts for any database users
  22. [OK] All database users have passwords assigned
  23. [!!] User 'someuser@%' hasn't specific host restriction.
  24. [--] There are 612 basic passwords in the list.
  25.  
  26. -------- CVE Security Recommendations --------------------------------------------------------------
  27. [OK] NO SECURITY CVE FOUND FOR YOUR VERSION
  28.  
  29. -------- Performance Metrics -----------------------------------------------------------------------
  30. [--] Up for: 12h 26m 53s (754K q [16.841 qps], 245K conn, TX: 8G, RX: 816M)
  31. [--] Reads / Writes: 88% / 12%
  32. [--] Binary logging is disabled
  33. [--] Physical Memory : 377.8G
  34. [--] Max MySQL memory : 5.0G
  35. [--] Other process memory: 265.3G
  36. [--] Total buffers: 676.0M global + 1.1M per thread (4190 max threads)
  37. [--] P_S Max memory usage: 72B
  38. [--] Galera GCache Max memory usage: 0B
  39. [OK] Maximum reached memory usage: 975.6M (0.25% of installed RAM)
  40. [OK] Maximum possible memory usage: 5.0G (1.33% of installed RAM)
  41. [OK] Overall possible memory usage with other process is compatible with memory available
  42. [OK] Slow queries: 0% (0/754K)
  43. [OK] Highest usage of available connections: 6% (282/4190)
  44. [OK] Aborted connections: 0.00% (6/245883)
  45. [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
  46. [!!] Query cache may be disabled by default due to mutex contention.
  47. [!!] Query cache efficiency: 0.0% (0 cached / 232K selects)
  48. [OK] Query cache prunes per day: 0
  49. [OK] Sorts requiring temporary tables: 0% (3 temp sorts / 374 sorts)
  50. [OK] No joins without indexes
  51. [OK] Temporary tables created on disk: 16% (268 on disk / 1K total)
  52. [OK] Thread cache hit rate: 91% (20K created / 245K connections)
  53. [!!] Table cache hit rate: 19% (400 open / 2K opened)
  54. [OK] Open file limit used: 0% (27/5K)
  55. [OK] Table locks acquired immediately: 100% (803 immediate / 803 locks)
  56.  
  57. -------- Performance schema ------------------------------------------------------------------------
  58. [--] Memory used by P_S: 72B
  59. [--] Sys schema is installed.
  60.  
  61. -------- ThreadPool Metrics ------------------------------------------------------------------------
  62. [--] ThreadPool stat is disabled.
  63.  
  64. -------- MyISAM Metrics ----------------------------------------------------------------------------
  65. [!!] Key buffer used: 18.3% (3M used / 16M cache)
  66. [OK] Key buffer size / total MyISAM indexes: 16.0M/43.0K
  67. [!!] Read Key buffer hit rate: 84.4% (122 cached / 19 reads)
  68.  
  69. -------- InnoDB Metrics ----------------------------------------------------------------------------
  70. [--] InnoDB is enabled.
  71. [--] InnoDB Thread Concurrency: 0
  72. [OK] InnoDB File per table is activated
  73. [!!] InnoDB buffer pool / data size: 128.0M/561.5M
  74. [!!] Ratio InnoDB log file size / InnoDB Buffer pool size (3198.4375 %): 2.0G * 2/128.0M should be equal 25%
  75. [OK] InnoDB buffer pool instances: 1
  76. [--] Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s)
  77. [OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
  78. [OK] InnoDB Read buffer efficiency: 99.82% (74918305 hits/ 75055124 total)
  79. [OK] InnoDB Write log efficiency: 99.42% (3686936 hits/ 3708334 total)
  80. [OK] InnoDB log waits: 0.00% (0 waits / 21398 writes)
  81.  
  82. -------- AriaDB Metrics ----------------------------------------------------------------------------
  83. [--] AriaDB is disabled.
  84.  
  85. -------- TokuDB Metrics ----------------------------------------------------------------------------
  86. [--] TokuDB is disabled.
  87.  
  88. -------- XtraDB Metrics ----------------------------------------------------------------------------
  89. [--] XtraDB is disabled.
  90.  
  91. -------- RocksDB Metrics ---------------------------------------------------------------------------
  92. [--] RocksDB is disabled.
  93.  
  94. -------- Spider Metrics ----------------------------------------------------------------------------
  95. [--] Spider is disabled.
  96.  
  97. -------- Connect Metrics ---------------------------------------------------------------------------
  98. [--] Connect is disabled.
  99.  
  100. -------- Galera Metrics ----------------------------------------------------------------------------
  101. [--] Galera is disabled.
  102.  
  103. -------- Replication Metrics -----------------------------------------------------------------------
  104. [--] Galera Synchronous replication: NO
  105. [--] No replication slave(s) for this server.
  106. [--] This is a standalone server.
  107.  
  108. -------- Recommendations ---------------------------------------------------------------------------
  109. General recommendations:
  110. Run OPTIMIZE TABLE to defragment tables for better performance
  111. OPTIMIZE TABLE `database.mail`; -- can free 118 MB
  112. Total freed space after theses OPTIMIZE TABLE : 118 Mb
  113. Restrict Host for user@% to user@SpecificDNSorIp
  114. MySQL started within last 24 hours - recommendations may be inaccurate
  115. Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
  116. Increase table_open_cache gradually to avoid file descriptor limits
  117. Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
  118. Beware that open_files_limit (5000) variable
  119. should be greater than table_open_cache (400)
  120. Variables to adjust:
  121. query_cache_size (=0)
  122. query_cache_type (=0)
  123. query_cache_limit (> 1M, or use smaller result sets)
  124. table_open_cache (> 400)
  125. innodb_buffer_pool_size (>= 561M) if possible.
  126. innodb_log_file_size * innodb_log_files_in_group should be equal to 1/4 of buffer pool size (=64M) if possible.
RAW Paste Data