Optimize mysql cpanel

This report after 24 hrs, please advice best config, 50GB RAM, 10 Core e5, SSD [--] Skipped version check for MySQLTuner script [!!] Currently running unsupported MySQL version 10.0.31-MariaDB [OK] Operating on 64-bit architecture -------- Log file Recommendations ------------------------------------------------------------------ [--] Log file: /var/lib/mysql/vmi116126.contaboserver.net.err(311K) [OK] Log file /var/lib/mysql/vmi116126.contaboserver.net.err exists [OK] Log file /var/lib/mysql/vmi116126.contaboserver.net.err is readable. [OK] Log file /var/lib/mysql/vmi116126.contaboserver.net.err is not empty [OK] Log file /var/lib/mysql/vmi116126.contaboserver.net.err is smaller than 32 Mb [!!] /var/lib/mysql/vmi116126.contaboserver.net.err contains 453 warning(s). [!!] /var/lib/mysql/vmi116126.contaboserver.net.err contains 588 error(s). [--] 38 start(s) detected in /var/lib/mysql/vmi116126.contaboserver.net.err [--] 1) 170601 23:12:37 [Note] /usr/sbin/mysqld: ready for connections. [--] 2) 170601 23:11:23 [Note] /usr/sbin/mysqld: ready for connections. [--] 3) 170601 23:09:54 [Note] /usr/sbin/mysqld: ready for connections. [--] 4) 170601 23:09:50 [Note] /usr/sbin/mysqld: ready for connections. [--] 5) 170601 23:09:19 [Note] /usr/sbin/mysqld: ready for connections. [--] 6) 170601 18:20:20 [Note] /usr/sbin/mysqld: ready for connections. [--] 7) 170601 15:36:49 [Note] /usr/sbin/mysqld: ready for connections. [--] 8) 170601 12:04:34 [Note] /usr/sbin/mysqld: ready for connections. [--] 9) 170601 12:04:24 [Note] /usr/sbin/mysqld: ready for connections. [--] 10) 170601 10:16:17 [Note] /usr/sbin/mysqld: ready for connections. [--] 40 shutdown(s) detected in /var/lib/mysql/vmi116126.contaboserver.net.err [--] 1) 170601 23:12:36 [Note] /usr/sbin/mysqld: Shutdown complete [--] 2) 170601 23:11:22 [Note] /usr/sbin/mysqld: Shutdown complete [--] 3) 170601 23:09:53 [Note] /usr/sbin/mysqld: Shutdown complete [--] 4) 170601 23:09:49 [Note] /usr/sbin/mysqld: Shutdown complete [--] 5) 170601 23:08:34 [Note] /usr/sbin/mysqld: Shutdown complete [--] 6) 170601 23:08:28 [Note] /usr/sbin/mysqld: Shutdown complete [--] 7) 170601 23:08:22 [Note] /usr/sbin/mysqld: Shutdown complete [--] 8) 170601 23:07:40 [Note] /usr/sbin/mysqld: Shutdown complete [--] 9) 170601 23:07:34 [Note] /usr/sbin/mysqld: Shutdown complete [--] 10) 170601 23:07:28 [Note] /usr/sbin/mysqld: Shutdown complete -------- Storage Engine Statistics ----------------------------------------------------------------- [--] Status: +ARCHIVE +Aria +BLACKHOLE +CSV +FEDERATED +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA [--] Data in MyISAM tables: 317M (Tables: 105) [--] Data in InnoDB tables: 1G (Tables: 72) [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 is no basic password file list! -------- CVE Security Recommendations -------------------------------------------------------------- [--] Skipped due to --cvefile option undefined -------- Performance Metrics ----------------------------------------------------------------------- [--] Up for: 1d 1h 14m 45s (10M q [119.176 qps], 49K conn, TX: 153G, RX: 5G) [--] Reads / Writes: 94% / 6% [--] Binary logging is disabled [--] Physical Memory : 49.0G [--] Max MySQL memory : 836.0M [--] Other process memory: 1.1G [--] Total buffers: 416.0M global + 2.8M per thread (151 max threads) [--] P_S Max memory usage: 0B [--] Galera GCache Max memory usage: 0B [OK] Maximum reached memory usage: 435.5M (0.87% of installed RAM) [OK] Maximum possible memory usage: 836.0M (1.67% of installed RAM) [OK] Overall possible memory usage with other process is compatible with memory available [OK] Slow queries: 0% (7/10M) [OK] Highest usage of available connections: 4% (7/151) [OK] Aborted connections: 0.02% (10/49095) [!!] 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 / 9M selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (3K temp sorts / 1M sorts) [OK] No joins without indexes [!!] Temporary tables created on disk: 76% (1M on disk / 1M total) [!!] Thread cache is disabled [OK] Table cache hit rate: 95% (298 open / 312 opened) [OK] Open file limit used: 2% (280/10K) [OK] Table locks acquired immediately: 99% (14M immediate / 14M 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: 10 thread(s). [--] Using default value is good enough for your version (10.0.31-MariaDB) -------- MyISAM Metrics ---------------------------------------------------------------------------- [!!] Key buffer used: 19.8% (26M used / 134M cache) [OK] Key buffer size / total MyISAM indexes: 128.0M/17.7M [OK] Read Key buffer hit rate: 100.0% (13M cached / 773 reads) [!!] Write Key buffer hit rate: 67.9% (314K cached / 213K writes) -------- InnoDB Metrics ---------------------------------------------------------------------------- [--] InnoDB is enabled. [--] InnoDB Thread Concurrency: 0 [OK] InnoDB File per table is activated [!!] InnoDB buffer pool / data size: 128.0M/1.6G [!!] Ratio InnoDB log file size / InnoDB Buffer pool size (75 %): 48.0M * 2/128.0M should be equal 25% [!!] InnoDB buffer pool <= 1G and Innodb_buffer_pool_instances(!=1). [--] InnoDB Buffer Pool Chunk Size not used or defined in your version [OK] InnoDB Read buffer efficiency: 98.28% (20202356856 hits/ 20556730428 total) [!!] InnoDB Write Log efficiency: 47.23% (354056 hits/ 749676 total) [OK] InnoDB log waits: 0.00% (0 waits / 395620 writes) -------- AriaDB Metrics ---------------------------------------------------------------------------- [--] AriaDB is enabled. [OK] Aria pagecache size / total Aria indexes: 128.0M/1B [OK] Aria pagecache hit rate: 99.8% (176M cached / 324K 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/vmi116126.contaboserver.net.err file Control error line(s) into /var/lib/mysql/vmi116126.contaboserver.net.err file Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1 When making adjustments, make tmp_table_size/max_heap_table_size equal Reduce your SELECT DISTINCT queries which have no LIMIT clause Set thread_cache_size to 4 as a starting value Performance should be activated for better diagnostics Consider installing Sys schema from GitHub - mysql/mysql-sys: The MySQL sys schema Variables to adjust: query_cache_size (=0) query_cache_type (=0) query_cache_limit (> 1M, or use smaller result sets) tmp_table_size (> 16M) max_heap_table_size (> 16M) thread_cache_size (start at 4) performance_schema = ON enable PFS innodb_buffer_pool_size (>= 1G) if possible. innodb_log_file_size * innodb_log_files_in_group should be equal to 1/4 of buffer pool size (=64M) if possible. innodb_buffer_pool_instances (=1)