Everything functioning normal. Just sending this for reference.
[root@Filter ~]# perl mysqltuner.pl
>> MySQLTuner 1.7.13 - 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.1.30-MariaDB
[OK] Operating on 64-bit architecture
-------- Log file Recommendations ------------------------------------------------------------------
[--] Log file: /var/lib/mysql/Filter.globalvision.net.err(0B)
[OK] Log file /var/lib/mysql/Filter.globalvision.net.err exists
[OK] Log file /var/lib/mysql/Filter.globalvision.net.err is readable.
[!!] Log file [root@Filter ~]# perl mysqltuner.pl
>> MySQLTuner 1.7.13 - 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.1.30-MariaDB
[OK] Operating on 64-bit architecture
-------- Log file Recommendations ------------------------------------------------------------------
[--] Log file: /var/lib/mysql/Filter.globalvision.net.err(0B)
[OK] Log file /var/lib/mysql/Filter.globalvision.net.err exists
[OK] Log file /var/lib/mysql/Filter.globalvision.net.err is readable.
[!!] Log file /var/lib/mysql/Filter.globalvision.net.err is empty
[OK] Log file /var/lib/mysql/Filter.globalvision.net.err is smaller than 32 Mb
[OK] /var/lib/mysql/Filter.globalvision.net.err doesn't contain any warning.
[OK] /var/lib/mysql/Filter.globalvision.net.err doesn't contain any error.
[--] 0 start(s) detected in /var/lib/mysql/Filter.globalvision.net.err
[--] 0 shutdown(s) detected in /var/lib/mysql/Filter.globalvision.net.err
-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE
[--] Data in MyISAM tables: 66.6M (Tables: 14)
[--] Data in InnoDB tables: 11.6G (Tables: 21)
[!!] Total fragmented tables: 2
-------- Analysis Performance Metrics --------------------------------------------------------------
[--] innodb_stats_on_metadata: OFF
[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: 6d 0h 47m 1s (11M q [21.422 qps], 87K conn, TX: 89G, RX: 2G)
[--] Reads / Writes: 31% / 69%
[--] Binary logging is disabled
[--] Physical Memory : 15.6G
[--] Max MySQL memory : 1.7G
[--] Other process memory: 3.6G
[--] Total buffers: 1.2G global + 3.2M per thread (151 max threads)
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 1.3G (8.17% of installed RAM)
[OK] Maximum possible memory usage: 1.7G (10.96% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (76K/11M)
[OK] Highest usage of available connections: 6% (10/151)
[OK] Aborted connections: 0.00% (1/87417)
[OK] Query cache is disabled by default due to mutex contention on multiprocessor machines.
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 353 sorts)
[!!] Joins performed without indexes: 4496
[!!] Temporary tables created on disk: 64% (2K on disk / 3K total)
[OK] Thread cache hit rate: 99% (10 created / 87K connections)
[OK] Table cache hit rate: 89% (190 open / 212 opened)
[OK] Open file limit used: 3% (131/4K)
[OK] Table locks acquired immediately: 99% (10M immediate / 10M 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: 8 thread(s).
[--] Using default value is good enough for your version (10.1.30-MariaDB)
-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 64.2% (32M used / 50M cache)
[OK] Key buffer size / total MyISAM indexes: 48.0M/35.4M
[OK] Read Key buffer hit rate: 100.0% (26M cached / 1K reads)
[!!] Write Key buffer hit rate: 4.8% (6M cached / 299K writes)
-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[!!] InnoDB buffer pool / data size: 1.0G/11.6G
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 125.0M * 2/1.0G should be equal 25%
[OK] InnoDB buffer pool instances: 1
[--] InnoDB Buffer Pool Chunk Size not used or defined in your version
[OK] InnoDB Read buffer efficiency: 100.00% (438537348780 hits/ 438552853575 total)
[!!] InnoDB Write Log efficiency: 82.1% (34144027 hits/ 41586679 total)
[OK] InnoDB log waits: 0.00% (0 waits / 7442652 writes)
-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is enabled.
[OK] Aria pagecache size / total Aria indexes: 128.0M/1B
[OK] Aria pagecache hit rate: 99.8% (915K cached / 2K 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: STATEMENT
[--] XA support enabled: ON
[--] Semi synchronous replication Master: Not Activated
[--] Semi synchronous replication Slave: Not Activated
[--] This is a standalone server
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
OPTIMIZE TABLE `mailscanner`.`maillog`; -- can free 7015 MB
OPTIMIZE TABLE `sa_bayes`.`bayes_seen`; -- can free 7413 MB
Total freed space after theses OPTIMIZE TABLE : 14428 Mb
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 schema should be activated for better diagnostics
Consider installing Sys schema from
https://github.com/mysql/mysql-sys
Variables to adjust:
join_buffer_size (> 512.0K, or always use indexes with JOINs)
tmp_table_size (> 32M)
max_heap_table_size (> 32M)
performance_schema = ON enable PFS
innodb_buffer_pool_size (>= 11.6G) if possible.
is empty
[OK] Log file /var/lib/mysql/Filter.globalvision.net.err is smaller than 32 Mb
[OK] /var/lib/mysql/Filter.globalvision.net.err doesn't contain any warning.
[OK] /var/lib/mysql/Filter.globalvision.net.err doesn't contain any error.
[--] 0 start(s) detected in /var/lib/mysql/Filter.globalvision.net.err
[--] 0 shutdown(s) detected in /var/lib/mysql/Filter.globalvision.net.err
-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE
[--] Data in MyISAM tables: 66.6M (Tables: 14)
[--] Data in InnoDB tables: 11.6G (Tables: 21)
[!!] Total fragmented tables: 2
-------- Analysis Performance Metrics --------------------------------------------------------------
[--] innodb_stats_on_metadata: OFF
[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: 6d 0h 47m 1s (11M q [21.422 qps], 87K conn, TX: 89G, RX: 2G)
[--] Reads / Writes: 31% / 69%
[--] Binary logging is disabled
[--] Physical Memory : 15.6G
[--] Max MySQL memory : 1.7G
[--] Other process memory: 3.6G
[--] Total buffers: 1.2G global + 3.2M per thread (151 max threads)
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 1.3G (8.17% of installed RAM)
[OK] Maximum possible memory usage: 1.7G (10.96% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (76K/11M)
[OK] Highest usage of available connections: 6% (10/151)
[OK] Aborted connections: 0.00% (1/87417)
[OK] Query cache is disabled by default due to mutex contention on multiprocessor machines.
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 353 sorts)
[!!] Joins performed without indexes: 4496
[!!] Temporary tables created on disk: 64% (2K on disk / 3K total)
[OK] Thread cache hit rate: 99% (10 created / 87K connections)
[OK] Table cache hit rate: 89% (190 open / 212 opened)
[OK] Open file limit used: 3% (131/4K)
[OK] Table locks acquired immediately: 99% (10M immediate / 10M 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: 8 thread(s).
[--] Using default value is good enough for your version (10.1.30-MariaDB)
-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 64.2% (32M used / 50M cache)
[OK] Key buffer size / total MyISAM indexes: 48.0M/35.4M
[OK] Read Key buffer hit rate: 100.0% (26M cached / 1K reads)
[!!] Write Key buffer hit rate: 4.8% (6M cached / 299K writes)
-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[!!] InnoDB buffer pool / data size: 1.0G/11.6G
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 125.0M * 2/1.0G should be equal 25%
[OK] InnoDB buffer pool instances: 1
[--] InnoDB Buffer Pool Chunk Size not used or defined in your version
[OK] InnoDB Read buffer efficiency: 100.00% (438537348780 hits/ 438552853575 total)
[!!] InnoDB Write Log efficiency: 82.1% (34144027 hits/ 41586679 total)
[OK] InnoDB log waits: 0.00% (0 waits / 7442652 writes)
-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is enabled.
[OK] Aria pagecache size / total Aria indexes: 128.0M/1B
[OK] Aria pagecache hit rate: 99.8% (915K cached / 2K 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: STATEMENT
[--] XA support enabled: ON
[--] Semi synchronous replication Master: Not Activated
[--] Semi synchronous replication Slave: Not Activated
[--] This is a standalone server
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
OPTIMIZE TABLE `mailscanner`.`maillog`; -- can free 7015 MB
OPTIMIZE TABLE `sa_bayes`.`bayes_seen`; -- can free 7413 MB
Total freed space after theses OPTIMIZE TABLE : 14428 Mb
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 schema should be activated for better diagnostics
Consider installing Sys schema from
https://github.com/mysql/mysql-sys
Variables to adjust:
join_buffer_size (> 512.0K, or always use indexes with JOINs)
tmp_table_size (> 32M)
max_heap_table_size (> 32M)
performance_schema = ON enable PFS
innodb_buffer_pool_size (>= 11.6G) if possible.