Merhaba,
arkadaşlar rica etsem bu çıktıda düzeltilmesi, iyileştirilmesi gereken ya da dikkate alınması gereken uyarılar var mıdır? İnceleyebilirseniz sevinirim.
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 10.2.31-MariaDB
[OK] Operating on 64-bit architecture
-------- Log file Recommendations ------------------------------------------------------------------
[OK] Log file /var/lib/mysql/SERVERİSMİ.err exists
[--] Log file: /var/lib/mysql/SERVERİSMİ.err(486K)
[OK] Log file /var/lib/mysql/SERVERİSMİ.err is readable.
[OK] Log file /var/lib/mysql/SERVERİSMİ.err is not empty
[OK] Log file /var/lib/mysql/SERVERİSMİt.err is smaller than 32 Mb
[!!] /var/lib/mysql/SERVERİSMİ.err contains 2305 warning(s).
[!!] /var/lib/mysql/SERVERİSMİ.err contains 1427 error(s).
[--] 32 start(s) detected in /var/lib/mysql/SERVERİSMİ.err
[--] 1) 2020-03-19 23:45:32 140402689394880 [Note] /usr/sbin/mysqld: ready for connections.
[--] 2) 2020-03-19 23:41:00 139891196106944 [Note] /usr/sbin/mysqld: ready for connections.
[--] 3) 2020-03-20 2:34:50 140015769295040 [Note] /usr/sbin/mysqld: ready for connections.
[--] 4) 2020-03-19 2:54:45 140663743191232 [Note] /usr/sbin/mysqld: ready for connections.
[--] 5) 2020-03-19 2:47:48 140395669461184 [Note] /usr/sbin/mysqld: ready for connections.
[--] 6) 2020-03-15 0:28:20 139789523908800 [Note] /usr/sbin/mysqld: ready for connections.
[--] 7) 2020-03-15 0:20:56 140536443009216 [Note] /usr/sbin/mysqld: ready for connections.
[--] 8) 2020-03-14 23:51:26 140143821351104 [Note] /usr/sbin/mysqld: ready for connections.
[--] 9) 2020-03-14 23:51:15 140207545981120 [Note] /usr/sbin/mysqld: ready for connections.
[--] 10) 2020-03-14 23:43:40 140070683568320 [Note] /usr/sbin/mysqld: ready for connections.
[--] 19 shutdown(s) detected in /var/lib/mysql/SERVERİSMİ.err
[--] 1) 2020-03-20 2:40:06 140012919236352 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 2) 2020-03-20 2:34:47 140660919768832 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 3) 2020-03-19 2:54:44 140395435316992 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 4) 2020-03-19 2:47:44 139786291066624 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 5) 2020-03-15 0:28:19 140533480494848 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 6) 2020-03-15 0:20:53 140140828886784 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 7) 2020-03-14 23:51:25 140204579313408 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 8) 2020-03-14 23:51:13 140067288573696 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 9) 2020-03-14 23:43:38 139722870683392 [Note] /usr/sbin/mysqld: Shutdown complete
[--] 10) 2020-03-14 23:22:48 139696838493952 [Note] /usr/sbin/mysqld: Shutdown complete
-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE
[--] Data in MyISAM tables: 143.4M (Tables: 226)
[--] Data in InnoDB tables: 490.8M (Tables: 568)
[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: 4d 12h 54m 35s (5M q [14.718 qps], 99K conn, TX: 41G, RX: 2G)
[--] Reads / Writes: 95% / 5%
[--] Binary logging is disabled
[--] Physical Memory : 58.8G
[--] Max MySQL memory : 41.0G
[--] Other process memory: 0B
[--] Total buffers: 2.5G global + 260.7M per thread (151 max threads)
[--] P_S Max memory usage: 93M
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 18.1G (30.83% of installed RAM)
[OK] Maximum possible memory usage: 41.0G (69.78% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (3/5M)
[OK] Highest usage of available connections: 40% (61/151)
[OK] Aborted connections: 0.05% (54/99499)
[OK] Query cache is disabled by default due to mutex contention on multiprocessor machines.
[OK] Sorts requiring temporary tables: 0% (2 temp sorts / 908K sorts)
[OK] No joins without indexes
[!!] Temporary tables created on disk: 80% (749K on disk / 932K total)
[OK] Thread cache hit rate: 99% (108 created / 99K connections)
[OK] Table cache hit rate: 99% (1K open / 1K opened)
[OK] table_definition_cache(1200) is upper than number of tables(952)
[OK] Open file limit used: 6% (616/10K)
[OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)
-------- Performance schema ------------------------------------------------------------------------
[--] Memory used by P_S: 93.6M
[--] 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.2.31-MariaDB)
-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 21.9% (29M used / 134M cache)
[OK] Key buffer size / total MyISAM indexes: 128.0M/30.9M
[OK] Read Key buffer hit rate: 100.0% (82M cached / 3K reads)
[OK] Write Key buffer hit rate: 99.7% (44K cached / 44K writes)
-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[OK] InnoDB buffer pool / data size: 2.0G/490.8M
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 256.0M * 2/2.0G should be equal to 25%
[OK] InnoDB buffer pool instances: 2
[--] Number of InnoDB Buffer Pool Chunk : 16 for 2 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: 100.00% (1321680914 hits/ 1321710965 total)
[OK] InnoDB Write log efficiency: 90.20% (2658379 hits/ 2947077 total)
[OK] InnoDB log waits: 0.00% (0 waits / 288698 writes)
-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is enabled.
[OK] Aria pagecache size / total Aria indexes: 128.0M/1B
[OK] Aria pagecache hit rate: 99.6% (70M cached / 267K 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: Not Activated
[--] Semi synchronous replication Slave: Not Activated
[--] This is a standalone server
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
Control warning line(s) into /var/lib/mysql/SERVERİSMİ.err file
Control error line(s) into /var/lib/mysql/SERVERİSMİ.err file
Temporary table size is already large - reduce result set size
Reduce your SELECT DISTINCT queries without LIMIT clauses
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