2014-06-25 23:11 GMT+03:00 Alex Samorukov <m...@os2.kiev.ua>: > On 06/25/2014 02:35 PM, Vladislav V. Prodan wrote: >> >> >> my.cnf >> [client] >> user = root >> port = 3306 >> socket = /tmp/mysql.sock >> [mysqld] >> port = 3306 >> bind-address = 127.0.0.1 >> socket = /tmp/mysql.sock >> skip-external-locking >> key_buffer = 14M >> max_connections = 50 >> thread_concurrency = 4 >> tmp_table_size = 24M >> max_allowed_packet = 1M >> max_tmp_tables = 128 >> sort_buffer_size = 512K >> net_buffer_length = 8K >> read_buffer_size = 256K >> read_rnd_buffer_size = 512K >> myisam_sort_buffer_size = 8M >> myisam-recover=backup,force >> query_cache_size = 8M >> query_cache_limit = 8M >> thread_cache_size = 64 > > 1) query_cache_type отсутствует включил > 2) 8М query_cache_size мало, поставтье хоть 128. увеличил
ничего не изменилось на соседнем сервере query_cache_type | OFF и cache заполнен :( -- Vladislav V. Prodan System & Network Administrator support.od.ua