Ram 3 GB, Çok hitli site yok. En fazlası şuan için 1K günlük. Opencart ve Wordpress ağırlıklı siteler.


Baktım oranın çok yararı oldu olmasına ama bu sefer pid error'lar vermeye başladı. Ordan burdan kırpıp birşeyler yapmaya çalıştım. Ama yine de %110'larda geziyor fakat load avareges düştü.

my.cnf'im bu; sizin yardımınızı istesem imkan olur mu bi düzenleme yapsanız hocam.

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
skip-name-resolve
max_connections=200
max_user_connections=200
key_buffer = 128M
query_cache_type = 1
query_cache_size = 16M
query_cache_limit = 16M
long_query_time = 4
join_buffer_size = 2M
sort_buffer_size = 2M
key_buffer_size = 16K
table_cache = 5000
open_files_limit = 10000
thread_cache_size = 256
tmp_table_size = 1024M
log-queries-not-using-indexes
wait_timeout = 28800
max_allowed_packet = 32M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 1M
read_rnd_buffer_size = 2M
net_buffer_length = 2K
thread_stack = 128K
default-storage-engine = MyISAM

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
skip-networking
server-id = 1

# Uncomment the following if you want to log updates
#log-bin=mysql-bin

# binary logging format - mixed recommended
#binlog_format=mixed

# Causes updates to non-transactional engines using statement format to be
# written directly to binary log. Before using this option make sure that
# there are no dependencies between transactional and non-transactional
# tables such as in the statement INSERT INTO t_myisam SELECT * FROM
# t_innodb; otherwise, slaves may diverge from the master.
#binlog_direct_non_transactional_updates=TRUE

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 1G
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M
quote-names

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer = 32M
key_buffer_size = 8M
sort_buffer_size = 32M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout