Hi,
I have a P4 system with 1GB Ram and 512MB Swap (a little low I know).
I'm running a multi threaded MySQL installation on it. With a bit of shock, I realised today that I ran completely out of swap space!!! Each MySQL thread is consuming about 160MB of ram, and I had close to 40 threads running. All my databases currently are approximately 1.5GB as far as file size goes, so it's not *that* much really. The biggest table is MyISAM (for delayed inserts), holding approximately 2million records currently.
Is there a way to limit the amount of threads that MySQL can start, and to "manage" the pool of threads? I.E. min servers, max servers, idle servers, etc....
And, can someone point me to a good side regarding getting optimum values for my.cnf? I'm running MySQL 4.1.11
my.cnf: [mysqld] log-queries-not-using-indexes skip-name-resolve skip-show-database skip-external-locking
port = 3306 socket = /tmp/mysql.sock key_buffer_size = 8M max_allowed_packet = 4M bind-address = x.x.x.x.122 server-id = 100
set-variable = back_log=10 set-variable = connect_timeout=10 set-variable = interactive_timeout=28800 set-variable = interactive_timeout=20 set-variable = join_buffer=256000 set-variable = key_buffer_size=64M
set-variable = max_allowed_packet=1M set-variable = max_connect_errors=512 set-variable = max_connections=64 set-variable = max_user_connections=64
set-variable = myisam_sort_buffer_size=16M
set-variable = net_buffer_length=32K set-variable = net_read_timeout=30 set-variable = net_retry_count=10000 set-variable = net_write_timeout=60
set-variable = query_cache_size=16M set-variable = query_cache_limit=1M set-variable = query_cache_type=1
set-variable = read_buffer_size=2M set-variable = sort_buffer=2M set-variable = table_cache=64
set-variable = thread_stack=64k set-variable = thread_cache=16 set-variable = thread_concurrency=2
set-variable = tmp_table_size=200000 set-variable = wait_timeout=28800
set-variable = delayed_insert_limit=2000 set-variable = delayed_insert_timeout=1800 set-variable = delayed_queue_size=8000 set-variable = max_delayed_threads=32
-- Chris.
I love deadlines. I especially love the whooshing sound they make as they fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
