[root@server ~]# ./mysqltuner.pl >> MySQLTuner 2.8.28 * Jean-Marie Renouard * 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 ℹ Using mysql to check login ✘ System command failed: /usr/bin/mariadb -Nrs -e 'select "mysqld is alive"' --connect-timeout=3 ℹ ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded Please enter your MySQL administrative login: root Please enter your MySQL administrative password: ✔ Operating on 64-bit architecture -------- Storage Engine Statistics ----------------------------------------------------------------- ℹ Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE ℹ Data in Aria tables: 32.0K (Tables: 1) ℹ Data in InnoDB tables: 4.1G (Tables: 201) ✔ Total fragmented tables: 0 ✔ Currently running supported MySQL/MariaDB version 11.4.9(LTS) -------- Log file Recommendations ------------------------------------------------------------------ ✔ Log file /var/log/mysql.log exists ℹ Log file: /var/log/mysql.log (6K) ✔ Log file /var/log/mysql.log is not empty ✔ Log file /var/log/mysql.log is smaller than 32 MB ✔ Log file /var/log/mysql.log is readable. ✘ /var/log/mysql.log contains 5 warning(s). ✔ /var/log/mysql.log doesn't contain any error. ℹ 2 start(s) detected in /var/log/mysql.log ℹ 1) 2026-01-17 20:23:33 0 [Note] /usr/sbin/mariadbd: ready for connections. ℹ 2) 2025-12-31 18:45:21 0 [Note] /usr/sbin/mariadbd: ready for connections. ℹ 2 shutdown(s) detected in /var/log/mysql.log ℹ 1) 2026-01-17 20:21:48 0 [Note] /usr/sbin/mariadbd: Shutdown complete ℹ 2) 2025-12-31 18:45:21 0 [Note] /usr/sbin/mariadbd: Shutdown complete -------- Analysis Performance Metrics -------------------------------------------------------------- ℹ innodb_stats_on_metadata: OFF ✔ No stat updates during querying INFORMATION_SCHEMA. -------- Views Metrics ----------------------------------------------------------------------------- -------- Triggers Metrics -------------------------------------------------------------------------- -------- Routines Metrics -------------------------------------------------------------------------- -------- Security Recommendations ------------------------------------------------------------------ ℹ MariaDB Server - 11.4.9 ✔ There are no anonymous accounts for any database users ✔ 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: 4d 14h 56m 7s (68M q [172.768 qps], 201K conn, TX: 188G, RX: 8G) ℹ Reads / Writes: 96% / 4% ℹ Binary logging is disabled ℹ Physical Memory : 31.0G ℹ Max MySQL memory : 4.0G ℹ Other process memory: 0B ℹ Total buffers: 3.6G global + 2.9M per thread (151 max threads) ℹ Performance_schema Max memory usage: 0B ℹ Galera GCache Max memory usage: 0B ✔ Maximum reached memory usage: 3.8G (12.12% of installed RAM) ✔ Maximum possible memory usage: 4.0G (12.92% of installed RAM) ✔ Overall possible memory usage with other process is compatible with memory available ✔ Slow queries: 0% (0/68M) ✔ Highest usage of available connections: 42% (64/151) ✔ Aborted connections: 0.00% (3/201878) ℹ Skipped name resolution test due to skip_networking=ON in system variables. ✔ Query cache is disabled by default due to mutex contention on multiprocessor machines. ✔ Sorts requiring temporary tables: 0% (0 temp sorts / 1M sorts) ✘ Joins performed without indexes: 376931 ✔ Temporary tables created on disk: 11% (539K on disk / 4M total) ✔ Thread cache hit rate: 99% (73 created / 201K connections) ✔ Table cache hit rate: 99% (135M hits / 135M requests) ✔ table_definition_cache (620) is greater than number of tables (496) ✔ Open file limit used: 0% (30/32K) ✔ Table locks acquired immediately: 100% (476 immediate / 476 locks) -------- Performance schema ------------------------------------------------------------------------ ✘ Performance_schema should be activated. ℹ Sys schema is installed. -------- MyISAM Metrics ---------------------------------------------------------------------------- ℹ General MyIsam metrics: ℹ +-- Total MyISAM Tables : 0 ℹ +-- Total MyISAM indexes : 0B ℹ +-- KB Size :64.0K ℹ +-- KB Used Size :19.0K ℹ +-- KB used :29.7% ℹ +-- Read KB hit rate: 0% (0 cached / 0 reads) ℹ +-- Write KB hit rate: 0% (0 cached / 0 writes) ℹ No MyISAM table(s) detected .... -------- InnoDB Metrics ---------------------------------------------------------------------------- ℹ InnoDB is enabled. ✔ InnoDB File per table is activated ✔ InnoDB Buffer Pool size ( 3.1G ) under limit for 64 bits architecture: (17179869184.0G ) ✘ InnoDB buffer pool / data size: 3.1G / 4.1G ✔ Ratio InnoDB log file size / InnoDB Buffer pool size: 800.0M * 1/3.1G should be equal to 25% ℹ innodb_buffer_pool_chunk_size is set to 'autosize' (0) in MariaDB >= 10.8. Skipping chunk size checks. ✔ InnoDB Read buffer efficiency: 100.00% (1264550277 hits / 1264609228 total) ✘ InnoDB Write Log efficiency: 84.31% (11440016 hits / 13568286 total) ✔ InnoDB log waits: 0.00% (0 waits / 2128270 writes) -------- Query Cache Information ------------------------------------------------------------------- ℹ QUERY_CACHE_INFO plugin is not active or not installed. -------- Aria Metrics ------------------------------------------------------------------------------ ℹ Aria Storage Engine is enabled. ✔ Aria pagecache size / total Aria indexes: 128.0M/336.0K ✔ Aria pagecache hit rate: 100.0% (48M cached / 10K 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 is a standalone server -------- Recommendations --------------------------------------------------------------------------- General recommendations: Check warning line(s) in /var/log/mysql.log file We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found. See https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_join_buffer_size Performance schema should be activated for better diagnostics Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU Variables to adjust: join_buffer_size (> 256.0K, or always use indexes with JOINs) performance_schema=ON innodb_buffer_pool_size (>= 4.1G) if possible. innodb_log_buffer_size (> 16M) [root@server ~]#