tunnel

>>  MySQLTuner 1.7.14 - 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.3.12-MariaDB
[OK] Operating on 64-bit architecture

-------- Log file Recommendations ------------------------------------------------------------------
[--] Log file: /var/lib/mysql/vps213680.vps.ovh.ca.err(309K)
[OK] Log file /var/lib/mysql/xxxexists
[OK] Log file /var/lib/mysql/xxxis readable.
[OK] Log file /var/lib/mysql/xxxis not empty
[OK] Log file /var/lib/mysql/xxxis smaller than 32 Mb
[!!] /var/lib/mysql/xxxcontains 1556 warning(s).
[!!] /var/lib/mysql/xxxcontains 1184 error(s).
[--] 30 start(s) detected in /var/lib/mysql/vps213680.vps.ovh.ca.err
[--] 1) 2019-02-18 15:57:47 0 [Note] /usr/sbin/mysqld: ready for connections.
[--] 2) 2019-02-18 15:56:29 0 [Note] /usr/sbin/mysqld: ready for connections.
[--] 3) 2019-02-18 15:54:23 0 [Note] /usr/sbin/mysqld: ready for connections.
[--] 4) 2019-02-18 15:53:56 0 [Note] /usr/sbin/mysqld: ready for connections.
[--] 5) 2019-02-18 15:50:35 0 [Note] /usr/sbin/mysqld: ready for connections.
[--] 6) 2019-02-18 15:49:40 0 [Note] /usr/sbin/mysqld: ready for connections.
[--] 7) 2019-02-18 11:36:26 0 [Note] /usr/sbin/mysqld: ready for connections.
[--] 8) 2019-02-18 10:00:11 0 [Note] /usr/sbin/mysqld: ready for connections.
[--] 9) 2019-02-18  9:59:35 0 [Note] /usr/sbin/mysqld: ready for connections.
[--] 10) 2019-02-18  9:56:30 0 [Note] /usr/sbin/mysqld: ready for connections.
[--] 29 shutdown(s) detected in /var/lib/mysql/vps213680.vps.ovh.ca.err
[--] 1) 2019-02-18 15:57:44 0 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 2) 2019-02-18 15:56:26 0 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 3) 2019-02-18 15:54:21 0 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 4) 2019-02-18 15:53:53 0 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 5) 2019-02-18 15:50:33 0 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 6) 2019-02-18 15:49:38 0 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 7) 2019-02-18 10:14:23 0 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 8) 2019-02-18 10:00:09 0 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 9) 2019-02-18  9:59:33 0 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 10) 2019-02-18  9:56:28 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: 56.0M (Tables: 19)
[--] Data in InnoDB tables: 1.5M (Tables: 1)
[OK] Total fragmented tables: 0

-------- 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: 27m 6s (206K q [126.798 qps], 17K conn, TX: 109M, RX: 15M)
[--] Reads / Writes: 96% / 4%
[--] Binary logging is disabled
[--] Physical Memory     : 7.5G
[--] Max MySQL memory    : 11.9G
[--] Other process memory: 0B
[--] Total buffers: 4.4G global + 10.2M per thread (700 max threads)
[--] P_S Max memory usage: 550M
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 5.8G (77.98% of installed RAM)
[!!] Maximum possible memory usage: 11.9G (158.63% of installed RAM)
[!!] Overall possible memory usage with other process exceeded memory
[OK] Slow queries: 0% (0/206K)
[OK] Highest usage of available connections: 13% (92/700)
[OK] Aborted connections: 0.01%  (2/17179)
[OK] Query cache is disabled by default due to mutex contention on multiprocessor machines.
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 953 sorts)
[OK] No joins without indexes
[!!] Temporary tables created on disk: 89% (15K on disk / 16K total)
[OK] Thread cache hit rate: 99% (92 created / 17K connections)
[OK] Table cache hit rate: 96% (160 open / 166 opened)
[OK] Open file limit used: 0% (154/60K)
[OK] Table locks acquired immediately: 98% (132K immediate / 134K locks)

-------- Performance schema ------------------------------------------------------------------------
[--] Memory used by P_S: 550.8M
[--] Sys schema is installed.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is enabled.
[--] Thread Pool Size: 2 thread(s).
[--] Using default value is good enough for your version (10.3.12-MariaDB)

-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 35.5% (1M used / 5M cache)
[OK] Key buffer size / total MyISAM indexes: 5.0M/2.3M
[OK] Read Key buffer hit rate: 99.9% (962K cached / 825 reads)
[OK] Write Key buffer hit rate: 96.6% (3K cached / 3K writes)

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 1
[OK] InnoDB File per table is activated
[OK] InnoDB buffer pool / data size: 4.0G/1.5M
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 512.0M * 2/4.0G should be equal 25%
[OK] InnoDB buffer pool instances: 4
[--] Number of InnoDB Buffer Pool Chunk : 32 for 4 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.81% (192906 hits/ 193275 total)
[!!] InnoDB Write Log efficiency: 366.67% (22 hits/ 6 total)
[OK] InnoDB log waits: 0.00% (0 waits / 28 writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is enabled.
[OK] Aria pagecache size / total Aria indexes: 128.0M/1B
[!!] Aria pagecache hit rate: 94.1% (253K cached / 15K 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:
    Control warning line(s) into /var/lib/mysql/xxxfile
    Control error line(s) into /var/lib/mysql/xxxfile
    MySQL was started within the last 24 hours - recommendations may be inaccurate
    Reduce your overall MySQL memory footprint for system stability
    Dedicate this server to your database for highest performance.
    Temporary table size is already large - reduce result set size
    Reduce your SELECT DISTINCT queries without LIMIT clauses