SEO

#1 (**permalink**) 03-17-2008, 06:13 AM

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

#2 (**permalink**) 03-17-2008, 06:13 AM

Yikes...I found it. 4GB on a 32-bit system...not good. :-)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Problems with making changes to cnf file