Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- >> MySQLTuner 1.7.1 - Major Hayden <major@mhtx.net>
- >> Bug reports, feature requests, and downloads at http://mysqltuner.com/
- >> Modified by George Liu (eva2000) at https://centminmod.com/
- >> Run with '--help' for additional options and output filtering
- [[0;34m--[0m] Skipped version check for MySQLTuner script
- [[0;32mOK[0m] Currently running supported MySQL version 10.1.40-MariaDB
- [[0;32mOK[0m] Operating on 64-bit architecture
- -------- Log file Recommendations ------------------------------------------------------------------
- [[0;34m--[0m] Log file: (0B)
- [[0;31m!![0m] Log file doesn't exist
- [[0;31m!![0m] Log file isn't readable.
- -------- Storage Engine Statistics -----------------------------------------------------------------
- [[0;34m--[0m] Status: [0;32m+Aria [0m[0;32m+CSV [0m[0;32m+InnoDB [0m[0;32m+MEMORY [0m[0;32m+MRG_MyISAM [0m[0;32m+MyISAM [0m[0;32m+PERFORMANCE_SCHEMA [0m[0;32m+SEQUENCE [0m
- [[0;34m--[0m] Data in MyISAM tables: 1K (Tables: 1)
- [[0;34m--[0m] Data in InnoDB tables: 14G (Tables: 532)
- [[0;32mOK[0m] Total fragmented tables: 0
- -------- Security Recommendations ------------------------------------------------------------------
- [[0;32mOK[0m] There are no anonymous accounts for any database users
- [[0;32mOK[0m] All database users have passwords assigned
- [[0;31m!![0m] There is no basic password file list!
- -------- CVE Security Recommendations --------------------------------------------------------------
- [[0;34m--[0m] Skipped due to --cvefile option undefined
- -------- Performance Metrics -----------------------------------------------------------------------
- [[0;34m--[0m] Up for: 15h 42m 9s (4M q [70.855 qps], 1M conn, TX: 8G, RX: 10G)
- [[0;34m--[0m] Reads / Writes: 91% / 9%
- [[0;34m--[0m] Binary logging is disabled
- [[0;34m--[0m] Physical Memory : 47.0G
- [[0;34m--[0m] Max MySQL memory : 33.4G
- [[0;34m--[0m] Other process memory: 13.8G
- [[0;34m--[0m] Total buffers: 26.8G global + 6.8M per thread (1000 max threads)
- [[0;34m--[0m] P_S Max memory usage: 0B
- [[0;34m--[0m] Galera GCache Max memory usage: 0B
- [[0;32mOK[0m] Maximum reached memory usage: 32.9G (70.08% of installed RAM)
- [[0;32mOK[0m] Maximum possible memory usage: 33.4G (71.05% of installed RAM)
- [[0;31m!![0m] Overall possible memory usage with other process exceeded memory
- [[0;32mOK[0m] Slow queries: 0% (4/4M)
- [[0;31m!![0m] Highest connection usage: 93% (931/1000)
- [[0;32mOK[0m] Aborted connections: 0.76% (10010/1313264)
- [[0;32mOK[0m] Query cache is disabled by default due to mutex contention on multiprocessor machines.
- [[0;32mOK[0m] Sorts requiring temporary tables: 0% (32 temp sorts / 248K sorts)
- [[0;31m!![0m] Joins performed without indexes: 83574
- [[0;31m!![0m] Temporary tables created on disk: 40% (72K on disk / 177K total)
- [[0;32mOK[0m] Thread cache hit rate: 99% (7K created / 1M connections)
- [[0;32mOK[0m] Table cache hit rate: 64% (1K open / 1K opened)
- [[0;32mOK[0m] Open file limit used: 0% (61/17K)
- [[0;32mOK[0m] Table locks acquired immediately: 100% (2M immediate / 2M locks)
- -------- Performance schema ------------------------------------------------------------------------
- [[0;34m--[0m] Performance schema is disabled.
- [[0;34m--[0m] Memory used by P_S: 0B
- [[0;34m--[0m] Sys schema isn't installed.
- -------- ThreadPool Metrics ------------------------------------------------------------------------
- [[0;34m--[0m] ThreadPool stat is enabled.
- [[0;34m--[0m] Thread Pool Size: 20 thread(s).
- [[0;34m--[0m] Using default value is good enough for your version (10.1.40-MariaDB)
- -------- MyISAM Metrics ----------------------------------------------------------------------------
- [[0;31m!![0m] Key buffer used: 18.7% (150M used / 805M cache)
- [[0;32mOK[0m] Key buffer size / total MyISAM indexes: 768.0M/124.0K
- [[0;32mOK[0m] Read Key buffer hit rate: 99.4% (1K cached / 9 reads)
- [[0;31m!![0m] Write Key buffer hit rate: 67.5% (154 cached / 104 writes)
- -------- InnoDB Metrics ----------------------------------------------------------------------------
- [[0;34m--[0m] InnoDB is enabled.
- [[0;34m--[0m] InnoDB Thread Concurrency: 0
- [[0;32mOK[0m] InnoDB File per table is activated
- [[0;32mOK[0m] InnoDB buffer pool / data size: 24.0G/14.3G
- [[0;31m!![0m] Ratio InnoDB log file size / InnoDB Buffer pool size (41.6666666666667 %): 5.0G * 2/24.0G should be equal 25%
- [[0;31m!![0m] InnoDB buffer pool instances: 8
- [[0;34m--[0m] InnoDB Buffer Pool Chunk Size not used or defined in your version
- [[0;32mOK[0m] InnoDB Read buffer efficiency: 100.00% (1099379224 hits/ 1099379388 total)
- [[0;32mOK[0m] InnoDB Write log efficiency: 99.51% (44716403 hits/ 44936008 total)
- [[0;31m!![0m] InnoDB log waits: 0.00% (2 waits / 219605 writes)
- -------- AriaDB Metrics ----------------------------------------------------------------------------
- [[0;34m--[0m] AriaDB is enabled.
- [[0;32mOK[0m] Aria pagecache size / total Aria indexes: 1.0G/1B
- [[0;31m!![0m] Aria pagecache hit rate: 94.8% (1M cached / 63K reads)
- -------- TokuDB Metrics ----------------------------------------------------------------------------
- [[0;34m--[0m] TokuDB is disabled.
- -------- XtraDB Metrics ----------------------------------------------------------------------------
- [[0;34m--[0m] XtraDB is disabled.
- -------- RocksDB Metrics ---------------------------------------------------------------------------
- [[0;34m--[0m] RocksDB is disabled.
- -------- Spider Metrics ----------------------------------------------------------------------------
- [[0;34m--[0m] Spider is disabled.
- -------- Connect Metrics ---------------------------------------------------------------------------
- [[0;34m--[0m] Connect is disabled.
- -------- Galera Metrics ----------------------------------------------------------------------------
- [[0;34m--[0m] Galera is disabled.
- -------- Replication Metrics -----------------------------------------------------------------------
- [[0;34m--[0m] Galera Synchronous replication: NO
- [[0;34m--[0m] No replication slave(s) for this server.
- [[0;34m--[0m] This is a standalone server.
- -------- Recommendations ---------------------------------------------------------------------------
- General recommendations:
- MySQL started within last 24 hours - recommendations may be inaccurate
- Dedicate this server to your database for highest performance.
- Reduce or eliminate persistent connections to reduce connection usage
- Adjust your join queries to always utilize indexes. Please note this
- calculation is made by adding Select_full_join + Select_range_check
- status values and triggered when the total >250
- Temporary table size is already large - reduce result set size
- Reduce your SELECT DISTINCT queries without LIMIT clauses
- Performance should be activated for better diagnostics
- Consider installing Sys schema from https://github.com/mysql/mysql-sys
- Variables to adjust:
- max_connections (> 1000)
- wait_timeout (< 1800)
- interactive_timeout (< 28800)
- join_buffer_size (> 2.0M, or always use indexes with joins)
- performance_schema = ON enable PFS
- innodb_log_file_size * innodb_log_files_in_group should be equals to 1/4 of buffer pool size (=12G) if possible.
- innodb_buffer_pool_instances(=24)
- innodb_log_buffer_size (>= 16M)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement