İnnodb buffer size 900 üzeri bir rakam yazmıştım zaten query cache 64 yeterli mi?
Ek Olarak: My.cnf dosyamda bu:
[mysqld]
key_buffer=256M
myisam_sort_buffer_size=512M
join_buffer=64M
sort_buffer=22M
table_open_cache=10000
table_definition_cache=10000
thread_cache_size=512
connect_timeout=60
wait_timeout=500
interactive_timeout=500
max_allowed_packet=1024M
tmp_table_size=256M
max_heap_table_size=256M
query_cache_limit=64M
query_cache_size=64M
query_cache_type=1
open_files_limit=30000
thread_concurrency=16
max_connections=500
local-infile=0
connect_timeout=45
default-storage-engine=MyISAM
log-slow-queries=/var/lib/mysql/slow_queries.log
low_priority_updates=1
long_query_time = 1
innodb_buffer_pool_size=983
innodb_file_per_table=1
[mysqld_safe]
nice=-5
[mysqldump]
quick
max_allowed_packet=1024M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
Ek Olarak: Acaba şimdi anladım da
innodb_buffer_pool_size=983 olan en sonuna M eklemediğimden mi çalışmadı?