Problems with making changes to cnf file I have an !includedir setup and it has a timezone in it and that
works. So I know the myopt.cnf is getting parsed.
I have a 16GB dedicated server to mysql and I am tweaking mysql. I
have the following in the myopt.cnf:
[mysqld]
default-time-zone = +00:00
# added below
interactive_timeout = 120
wait_timeout = 120
connect_timeout = 20
innodb_buffer_pool_size = 4G
innodb_additional_mem_pool_size = 20M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
sort_buffer_size = 64M
max_connect_errors = 1000
Once I restart mysql (and it does restart) and I bounce my Apache
servers they can no longer get to the mysql instance. I remove
everything under the # above and restart mysql and the Apache servers
are fine.
Maybe I am not specifying the memory correctly or something. I could
not find anything definitive on that subject.
Any help would be appreciated.
Robert |