Merhaba arkadaşlar 1 adet 2CORE - 4GB VPS aldım. Hazır plesk+ngix haliyle kullanıyorum ani işlemci ve ram artışları meydana geliyor.
my.cnf dosyası
[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
innodb_buffer_pool_size=2M
innodb_additional_mem_pool_size=500K
innodb_log_buffer_size=500K
innodb_thread_concurrency=2
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
innodb_buffer_pool_size=2M
innodb_additional_mem_pool_size=500K
innodb_log_buffer_size=500K
innodb_thread_concurrency=2
mysqltuner.pl çıktısı
>> MySQLTuner 1.3.0 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
[OK] Currently running supported MySQL version 5.1.73
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +CSV +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: 14M (Tables: 283)
[--] Data in InnoDB tables: 5M (Tables: 356)
[!!] Total fragmented tables: 391
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 1d 11h 55m 32s (959K q [7.422 qps], 31K conn, TX: 3B, RX: 147M)
[--] Reads / Writes: 96% / 4%
[--] Total buffers: 27.0M global + 2.7M per thread (151 max threads)
[OK] Maximum possible memory usage: 442.2M (10% of installed RAM)
[OK] Slow queries: 0% (0/959K)
[OK] Highest usage of available connections: 7% (12/151)
[OK] Key buffer size / total MyISAM indexes: 8.0M/5.4M
[OK] Key buffer hit rate: 99.3% (13M cached / 95K reads)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 213K sorts)
[!!] Joins performed without indexes: 8407
[!!] Temporary tables created on disk: 45% (99K on disk / 220K total)
[!!] Thread cache is disabled
[!!] Table cache hit rate: 0% (64 open / 27K opened)
[OK] Open file limit used: 11% (120/1K)
[OK] Table locks acquired immediately: 99% (946K immediate / 946K locks)
[!!] InnoDB buffer pool / data size: 2.0M/5.9M
[OK] InnoDB log waits: 0
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Enable the slow query log to troubleshoot bad queries
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 without LIMIT clauses
Set thread_cache_size to 4 as a starting value
Increase table_open_cache gradually to avoid file descriptor limits
Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
Variables to adjust:
query_cache_size (>= 8M)
join_buffer_size (> 128.0K, or always use indexes with joins)
tmp_table_size (> 16M)
max_heap_table_size (> 16M)
thread_cache_size (start at 4)
table_open_cache (> 64)
innodb_buffer_pool_size (>= 5M)Galiba ipyi daha önce başka biri sitelerinde kullanmış log dosyalarını baya şişiriyor. Acaba bunları başka bir yere yönlendirme gibi bir olay varmıdır. Yardımlarınız için şimdiden teşekkür ederim.