mysql Ver 14.14 Distrib 5.6.22, for Linux (i686) using EditLine wrapper
14.14 müş hocam.
merhaba
5.6 mysql versiyonunuz.ssh bilgilerini pm ile atarmısınız
--R10.NET; Flood Engellendi -->-> Yeni yazılan mesaj 16:10:03 -->-> Daha önceki mesaj 15:57:00 --
mysql Ver 14.14 Distrib 5.6.22, for Linux (i686) using EditLine wrapper
14.14 müş hocam.
merhaba
innodb_buffer_pool_size değerini gözümden kaçmış düzelttim.şuan sorunsuz çalışıyor mysql stabil şekilde
ilgili cnf
[mysqld]
local-infile=0
bind-address=127.0.0.1
skip-networking
key_buffer_size = 512M
myisam_sort_buffer_size = 64M
read_buffer_size = 1M
table_open_cache = 5000
thread_cache_size = 384
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 256M
max_heap_table_size = 256M
max_allowed_packet=268435456
net_buffer_length = 16384
concurrent_insert = 2
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 5M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65535
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
innodb_buffer_pool_size = 1G
max_write_lock_count = 8
external-locking=FALSE
open_files_limit=250000
[mysqld_safe]
[mysqldump]
quick
max_allowed_packet = 16M
[isamchk]
key_buffer = 384M
sort_buffer = 384M
read_buffer = 256M
write_buffer = 256M
[myisamchk]
key_buffer = 128M
sort_buffer = 128M
read_buffer = 128M
write_buffer = 128M
#### Per connection configuration ####
sort_buffer_size = 1M
join_buffer_size = 1M
thread_stack = 192K