>> MySQLTuner 1.7.20 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.pl/ >> Run with '--help' for additional options and output filtering [--] Skipped version check for MySQLTuner script [OK] Logged in using credentials from Debian maintenance account. [OK] Currently running supported MySQL version 10.3.32-MariaDB-0ubuntu0.20.04.1-log [OK] Operating on 64-bit architecture -------- Log file Recommendations ------------------------------------------------------------------ [OK] Log file /var/log/mysql/error.log exists [--] Log file: /var/log/mysql/error.log(2K) [OK] Log file /var/log/mysql/error.log is readable. [OK] Log file /var/log/mysql/error.log is not empty [OK] Log file /var/log/mysql/error.log is smaller than 32 Mb [!!] /var/log/mysql/error.log contains 4 warning(s). [!!] /var/log/mysql/error.log contains 3 error(s). [--] 1 start(s) detected in /var/log/mysql/error.log [--] 1) 2022-01-12 14:25:00 0 [Note] /usr/sbin/mysqld: ready for connections. [--] 1 shutdown(s) detected in /var/log/mysql/error.log [--] 1) 2022-01-12 14:24:55 0 [Note] /usr/sbin/mysqld: Shutdown complete -------- Storage Engine Statistics ----------------------------------------------------------------- [--] Status: +Aria +CSV -InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE [--] Data in MyISAM tables: 4.1G (Tables: 46) [OK] Total fragmented tables: 0 -------- Analysis Performance Metrics -------------------------------------------------------------- [OK] No stat updates during querying INFORMATION_SCHEMA. -------- 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: 26m 31s (935 q [0.588 qps], 327 conn, TX: 1M, RX: 367M) [--] Reads / Writes: 0% / 100% [--] Binary logging is enabled (GTID MODE: OFF) [--] Physical Memory : 7.7G [--] Max MySQL memory : 5.8G [--] Other process memory: 0B [--] Total buffers: 384.0M global + 546.6M per thread (10 max threads) [--] P_S Max memory usage: 79M [--] Galera GCache Max memory usage: 0B [OK] Maximum reached memory usage: 1.5G (19.63% of installed RAM) [OK] Maximum possible memory usage: 5.8G (74.77% of installed RAM) [OK] Overall possible memory usage with other process is compatible with memory available [!!] Slow queries: 13% (127/935) [OK] Highest usage of available connections: 20% (2/10) [OK] Aborted connections: 0.00% (0/327) [OK] Query cache is disabled by default due to mutex contention on multiprocessor machines. [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 66 sorts) [!!] Joins performed without indexes: 66 [OK] Temporary tables created on disk: 14% (330 on disk / 2K total) [OK] Thread cache hit rate: 99% (2 created / 327 connections) [OK] Table cache hit rate: 64% (131 open / 204 opened) [OK] table_definition_cache(400) is upper than number of tables(228) [OK] Open file limit used: 1% (162/8K) [OK] Table locks acquired immediately: 99% (526K immediate / 526K locks) [OK] Binlog cache memory access: 0% (0 Memory / 0 Total) -------- Performance schema ------------------------------------------------------------------------ [--] Memory used by P_S: 79.4M [--] Sys schema isn't installed. -------- ThreadPool Metrics ------------------------------------------------------------------------ [--] ThreadPool stat is enabled. [--] Thread Pool Size: 4 thread(s). [--] Using default value is good enough for your version (10.3.32-MariaDB-0ubuntu0.20.04.1-log) -------- MyISAM Metrics ---------------------------------------------------------------------------- [!!] Key buffer used: 36.3% (48M used / 134M cache) [OK] Key buffer size / total MyISAM indexes: 128.0M/706.1M [OK] Read Key buffer hit rate: 99.8% (14M cached / 23K reads) [!!] Write Key buffer hit rate: 92.4% (265K cached / 245K writes) -------- InnoDB Metrics ---------------------------------------------------------------------------- [--] InnoDB is disabled. [!!] InnoDB Storage engine is disabled. InnoDB is the default storage engine -------- AriaDB Metrics ---------------------------------------------------------------------------- [--] AriaDB is enabled. [OK] Aria pagecache size / total Aria indexes: 128.0M/1B [OK] Aria pagecache hit rate: 100.0% (186K cached / 6 reads) -------- TokuDB Metrics ---------------------------------------------------------------------------- [--] TokuDB is disabled. -------- XtraDB Metrics ---------------------------------------------------------------------------- [--] XtraDB is disabled. -------- Galera Metrics ---------------------------------------------------------------------------- [--] Galera is disabled. -------- Replication Metrics ----------------------------------------------------------------------- [--] Galera Synchronous replication: NO [--] No replication slave(s) for this server. [--] Binlog format: MIXED [--] XA support enabled: ON [--] Semi synchronous replication Master: OFF [--] Semi synchronous replication Slave: OFF [!!] This replication slave is running with the read_only option disabled. [OK] This replication slave is up to date with master. -------- Recommendations --------------------------------------------------------------------------- General recommendations: Control warning line(s) into /var/log/mysql/error.log file Control error line(s) into /var/log/mysql/error.log file MySQL was started within the last 24 hours - recommendations may be inaccurate We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found. See https://dev.mysql.com/doc/internals/en/join-buffer-size.html (specially the conclusions at the bottom of the page). Consider installing Sys schema from https://github.com/mysql/mysql-sys for MySQL Consider installing Sys schema from https://github.com/FromDual/mariadb-sys for MariaDB Variables to adjust: join_buffer_size (> 512.0M, or always use indexes with JOINs)