Hello,
We have currently tuned MySQL for a high rate of traffic. But, now we are seeing issues with memory usage. It reaches about 2GB and the server becomed wildly unstable. Below is our my.cnf file. Can anyone point out any glarring errors? We are running this on a Dell 2650 with Red Had Advanced Server v2.1 with Kernel 2.4.9-e.25smp and Hyper threading. Thanks a lot! [client] port = 3306 # The MySQL server [mysqld] datadir = /var/lib/mysql port = 3306 skip-locking set-variable = max_connections=800 set-variable = key_buffer=1500M set-variable = max_allowed_packet=1M set-variable = table_cache=16384 set-variable = sort_buffer=256k set-variable = record_buffer=256k set-variable = record_rnd_buffer=256k set-variable = thread_cache=64 set-variable = thread_concurrency=32 set-variable = myisam_sort_buffer_size=64M set-variable = interactive_timeout=300 set-variable = open_files_limit=60000 set-variable = wait_timeout=300 set-variable = long_query_time=5 set-variable = tmp_table_size=16M server-id = 0 # Adding bin log for PIT recovery log-bin #set-variable = bdb_cache_size=768M #set-variable = bdb_max_lock=100000 log-slow-queries=/var/log/slowqueries.log [safe_mysqld] open-files-limit=60000 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable = key_buffer=512M set-variable = sort_buffer=512M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=512M set-variable = sort_buffer=512M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout