Hi James, Your key_buffer is using tons of memory at 1.5 GB! table_cache is probably too big, too.
Matt ----- Original Message ----- From: "James Kelty" Sent: Saturday, February 14, 2004 3:03 AM Subject: Massive memory utiliazation > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
