• 24-03-2020, 12:56:11
    #1
    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
  • 25-03-2020, 17:14:40
    #2
    ⚡⭐SUNUCU OPTİMİZASYONU⭐🚀
    Merhaba,

    Ek olarak tuning primer kullanmanızı öneririm ek öneriler çıkabilir.

    benz :https://www.ayhanarda.com/blog/2018/...-ve-kullanimi/