I have a quad processor server, with 4 gigs of memory. It is only running MySQL right now and seems really slow. Can someone give me a few suggestions on optimizing My.cnf file for this system. We are running mysql-standard-4.0.23-pc-linux-i68, on it. Here is the my.cnf file
# The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 2M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size = 32M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 user=mysql basedir=/usr/local/mysql datadir=/usr2/mysql/data max_connections=400 max_connect_errors=300 interactive_timeout=2400 wait_timeout=60 back_log=100 #skip-networking server-id = 2 [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
