Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- log-error=/var/lib/mysql/animexunknown.iamhero.net.err
- default-storage-engine = MyISAM
- innodb_file_per_table = 1
- performance-schema = 1
- performance_schema_events_waits_history_size = 20
- performance_schema_events_waits_history_long_size = 15000
- max_allowed_packet = 268435456
- local-infile = 0
- open_files_limit = 10192
- table_open_cache = 24000
- table_definition_cache = 1024
- max_connections = 500
- query_cache_size = 512M
- query_cache_type = 0
- query_cache_limit = 4M
- join_buffer_size = 256.0K
- thread_cache_size = 8
- table_cache = 8192
- tmp_table_size = 16M
- max_heap_table_size = 256M
- innodb_buffer_pool_size = 15G
- innodb_log_file_size = 512M
- thread_stack = 128K
- key_buffer_size = 1280M
- [root@anime src]# perl mysqltuner.pl
- >> MySQLTuner 1.7.4 - Major Hayden <major@mhtx.net>
- >> Bug reports, feature requests, and downloads at http://mysqltuner.com/
- >> Run with '--help' for additional options and output filtering
- [--] Skipped version check for MySQLTuner script
- [OK] Currently running supported MySQL version 10.2.9-MariaDB
- [OK] Operating on 64-bit architecture
- -------- Log file Recommendations ------------------------------------------------------------------
- [--] Log file: /var/lib/mysql/animexunknown.iamhero.net.err(1M)
- [OK] Log file /var/lib/mysql/animexunknown.iamhero.net.err exists
- [OK] Log file /var/lib/mysql/animexunknown.iamhero.net.err is readable.
- [OK] Log file /var/lib/mysql/animexunknown.iamhero.net.err is not empty
- [OK] Log file /var/lib/mysql/animexunknown.iamhero.net.err is smaller than 32 Mb
- [!!] /var/lib/mysql/animexunknown.iamhero.net.err contains 2391 warning(s).
- [!!] /var/lib/mysql/animexunknown.iamhero.net.err contains 2293 error(s).
- [--] 92 start(s) detected in /var/lib/mysql/animexunknown.iamhero.net.err
- [--] 1) 2017-10-21 3:18:26 140421808523392 [Note] /usr/sbin/mysqld: ready for connections.
- [--] 2) 2017-10-21 3:08:04 140085739542656 [Note] /usr/sbin/mysqld: ready for connections.
- [--] 3) 2017-10-21 2:08:28 140208588351616 [Note] /usr/sbin/mysqld: ready for connections.
- [--] 4) 2017-10-19 2:36:44 140705789565056 [Note] /usr/sbin/mysqld: ready for connections.
- [--] 5) 2017-10-19 2:36:33 140568863770752 [Note] /usr/sbin/mysqld: ready for connections.
- [--] 6) 2017-10-17 19:30:14 140586253817984 [Note] /usr/sbin/mysqld: ready for connections.
- [--] 7) 2017-10-17 19:30:04 139620718205056 [Note] /usr/sbin/mysqld: ready for connections.
- [--] 8) 2017-10-14 19:51:50 140700734711936 [Note] /usr/sbin/mysqld: ready for connections.
- [--] 9) 2017-10-14 19:51:40 139751456983168 [Note] /usr/sbin/mysqld: ready for connections.
- [--] 10) 2017-10-04 16:23:04 139651866327168 [Note] /usr/sbin/mysqld: ready for connections.
- [--] 91 shutdown(s) detected in /var/lib/mysql/animexunknown.iamhero.net.err
- [--] 1) 2017-10-21 3:08:06 140085462673152 [Note] /usr/sbin/mysqld: Shutdown complete
- [--] 2) 2017-10-21 3:03:06 140207802783488 [Note] /usr/sbin/mysqld: Shutdown complete
- [--] 3) 2017-10-21 2:07:00 140705346029312 [Note] /usr/sbin/mysqld: Shutdown complete
- [--] 4) 2017-10-19 2:36:35 140568586901248 [Note] /usr/sbin/mysqld: Shutdown complete
- [--] 5) 2017-10-19 2:34:13 140585760294656 [Note] /usr/sbin/mysqld: Shutdown complete
- [--] 6) 2017-10-17 19:30:06 139620597221120 [Note] /usr/sbin/mysqld: Shutdown complete
- [--] 7) 2017-10-17 19:27:59 140700247639808 [Note] /usr/sbin/mysqld: Shutdown complete
- [--] 8) 2017-10-14 19:51:41 139751017780992 [Note] /usr/sbin/mysqld: Shutdown complete
- [--] 9) 2017-10-14 19:49:50 139651063711488 [Note] /usr/sbin/mysqld: Shutdown complete
- [--] 10) 2017-10-04 16:22:56 140438602782464 [Note] /usr/sbin/mysqld: Shutdown complete
- -------- Storage Engine Statistics -----------------------------------------------------------------
- [--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE
- [--] Data in MyISAM tables: 472M (Tables: 89)
- [--] Data in InnoDB tables: 4G (Tables: 1295)
- [--] Data in MEMORY tables: 2M (Tables: 24)
- [OK] Total fragmented tables: 0
- -------- Security Recommendations ------------------------------------------------------------------
- [OK] There are no anonymous accounts for any database users
- [OK] All database users have passwords assigned
- [--] There are 612 basic passwords in the list.
- -------- CVE Security Recommendations --------------------------------------------------------------
- [OK] NO SECURITY CVE FOUND FOR YOUR VERSION
- -------- Performance Metrics -----------------------------------------------------------------------
- [--] Up for: 13h 17m 8s (6M q [132.711 qps], 293K conn, TX: 269G, RX: 2G)
- [--] Reads / Writes: 87% / 13%
- [--] Binary logging is disabled
- [--] Physical Memory : 29.3G
- [--] Max MySQL memory : 1.8G
- [--] Other process memory: 1.0G
- [--] Total buffers: 417.0M global + 2.9M per thread (500 max threads)
- [--] P_S Max memory usage: 0B
- [--] Galera GCache Max memory usage: 0B
- [OK] Maximum reached memory usage: 446.1M (1.49% of installed RAM)
- [OK] Maximum possible memory usage: 1.8G (6.24% of installed RAM)
- [OK] Overall possible memory usage with other process is compatible with memory available
- [OK] Slow queries: 0% (0/6M)
- [OK] Highest usage of available connections: 2% (10/500)
- [OK] Aborted connections: 0.04% (104/293007)
- [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
- [!!] Query cache may be disabled by default due to mutex contention.
- [!!] Query cache efficiency: 0.0% (0 cached / 4M selects)
- [OK] Query cache prunes per day: 0
- [OK] Sorts requiring temporary tables: 0% (1 temp sorts / 320K sorts)
- [!!] Joins performed without indexes: 506
- [!!] Temporary tables created on disk: 98% (218K on disk / 221K total)
- [OK] Thread cache hit rate: 99% (10 created / 293K connections)
- [OK] Table cache hit rate: 82% (1K open / 1K opened)
- [OK] Open file limit used: 0% (107/240K)
- [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)
- -------- Performance schema ------------------------------------------------------------------------
- [--] Performance schema is disabled.
- [--] Memory used by P_S: 0B
- [--] Sys schema isn't installed.
- -------- ThreadPool Metrics ------------------------------------------------------------------------
- [--] ThreadPool stat is enabled.
- [--] Thread Pool Size: 6 thread(s).
- [--] Using default value is good enough for your version (10.2.9-MariaDB)
- -------- MyISAM Metrics ----------------------------------------------------------------------------
- [!!] Key buffer used: 31.4% (42M used / 134M cache)
- [OK] Key buffer size / total MyISAM indexes: 128.0M/261.0M
- [OK] Read Key buffer hit rate: 99.6% (4M cached / 15K reads)
- [!!] Write Key buffer hit rate: 56.4% (659K cached / 371K writes)
- -------- InnoDB Metrics ----------------------------------------------------------------------------
- [--] InnoDB is enabled.
- [--] InnoDB Thread Concurrency: 0
- [OK] InnoDB File per table is activated
- [!!] InnoDB buffer pool / data size: 128.0M/4.1G
- [!!] Ratio InnoDB log file size / InnoDB Buffer pool size (75 %): 48.0M * 2/128.0M should be equal 25%
- [OK] InnoDB buffer pool instances: 1
- [--] Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s)
- [OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
- [OK] InnoDB Read buffer efficiency: 99.96% (361634378 hits/ 361761376 total)
- [OK] InnoDB Write log efficiency: 91.95% (1527951 hits/ 1661676 total)
- [OK] InnoDB log waits: 0.00% (0 waits / 133725 writes)
- -------- AriaDB Metrics ----------------------------------------------------------------------------
- [--] AriaDB is enabled.
- [OK] Aria pagecache size / total Aria indexes: 128.0M/1B
- [OK] Aria pagecache hit rate: 98.9% (20M cached / 218K reads)
- -------- TokuDB Metrics ----------------------------------------------------------------------------
- [--] TokuDB is disabled.
- -------- XtraDB Metrics ----------------------------------------------------------------------------
- [--] XtraDB is disabled.
- -------- RocksDB Metrics ---------------------------------------------------------------------------
- [--] RocksDB is disabled.
- -------- Spider Metrics ----------------------------------------------------------------------------
- [--] Spider is disabled.
- -------- Connect Metrics ---------------------------------------------------------------------------
- [--] Connect is disabled.
- -------- Galera Metrics ----------------------------------------------------------------------------
- [--] Galera is disabled.
- -------- Replication Metrics -----------------------------------------------------------------------
- [--] Galera Synchronous replication: NO
- [--] No replication slave(s) for this server.
- [--] This is a standalone server.
- -------- Recommendations ---------------------------------------------------------------------------
- General recommendations:
- Control warning line(s) into /var/lib/mysql/animexunknown.iamhero.net.err file
- Control error line(s) into /var/lib/mysql/animexunknown.iamhero.net.err file
- MySQL started within last 24 hours - recommendations may be inaccurate
- Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
- Adjust your join queries to always utilize indexes
- When making adjustments, make tmp_table_size/max_heap_table_size equal
- Reduce your SELECT DISTINCT queries which have no LIMIT clause
- Performance should be activated for better diagnostics
- Consider installing Sys schema from https://github.com/mysql/mysql-sys
- Read this before changing innodb_log_file_size and/or innodb_log_files_in_group: bit.ly/2wgkDvS
- Variables to adjust:
- query_cache_size (=0)
- query_cache_type (=0)
- query_cache_limit (> 1M, or use smaller result sets)
- join_buffer_size (> 256.0K, or always use indexes with joins)
- tmp_table_size (> 16M)
- max_heap_table_size (> 16M)
- performance_schema = ON enable PFS
- innodb_buffer_pool_size (>= 4G) if possible.
- innodb_log_file_size should be (=16M) 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