On Tuesday 23 September 2008 12:13:58 Sam Nilsson wrote: > DB Servers: One Master, Two Read Only (replication) > 4 GB of Memory on each server > FreeBSD 6.3-RELEASE-p3 FreeBSD 6.3-RELEASE-p3 > MySQL 5.0.1
> Here are some relevent items from my.cnf: > - set-variable = max_connections=1000 > - set-variable = key_buffer_size=384M > - set-variable = read_buffer_size=64M > - set-variable = read_rnd_buffer_size=32M > - set-variable = thread_cache_size=20 You're shooting yourself in the foot: 1000*2MB=2G for thread stack + 384M + 1000 * (sort_buffer_size+64M+binlog_cache_size_innodb) You don't have that much memory. http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html There's a similar formula for MyISAM, but can't seem to find it at the moment. -- Mel Problem with today's modular software: they start with the modules and never get to the software part. _______________________________________________ email@example.com mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"