Arkadaşlar uzun zamandır MySQL problemi yaşıyorum kendi kendine gidiyor problem nedir çözemedim. Bilen birileri yardımcı olursa sevinirim.
SSH'dan restart ederken aldığım ekran;
gerek görülürse my.cnf ayarlarım;
SSH'dan restart ederken aldığım ekran;
mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/ip-5-39-119-19.netsunucu.net.pid) running as root with PID 5725 (process table check method)
mysqld (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/ip-5-39-119-19.netsunucu.net.err --open-files-limit=20000 --pid-file=/var/lib/mysql/ip-5-39-119-19.netsunucu.net.pid --socket=/var/lib/mysql/mysql.sock --port=3306) running as mysql with PID 6125 (pidfile check method)
gerek görülürse my.cnf ayarlarım;
[mysqld]
port= 3306
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-name-resolve
#safe-show-database
max_connections = 250
key_buffer = 256M
query_cache_type = 1
query_cache_size = 16M
query_cache_limit = 16M
long_query_time = 4
join_buffer_size = 2M
read_buffer_size = 3M
read_rnd_buffer_size= 6M
sort_buffer_size = 2M
max_allowed_packet=268435456
table_cache = 10000
open_files_limit= 20000
thread_cache_size = 256
tmp_table_size = 15000M
log-queries-not-using-indexes
wait_timeout = 28800
low_priority_updates = 1
concurrent_insert=2
default-storage-engine = MyISAM
#set-variable=local-infile
[mysql]
no-auto-rehash
[mysqldump]
quick
quote-names
max_allowed_packet = 1000M
[myisamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout