loccom Posted October 9, 2007 Share Posted October 9, 2007 I have 4gb on my box running Dual Xeons and find my server slows down a little. I usually have around 500 - 700 at one time (mostly bots i think) Here is my config[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-locking skip-innodb query_cache_limit=1M query_cache_size=64M query_cache_type=1 max_connections=500 interactive_timeout=100 wait_timeout=100 connect_timeout=10 thread_cache_size=128 key_buffer=256M join_buffer=1M max_allowed_packet=16M table_cache=2048 record_buffer=1M sort_buffer_size=2M read_buffer_size=2M max_connect_errors=10 # Try number of CPU's*2 for thread_concurrency thread_concurrency=4 myisam_sort_buffer_size=64M #log-bin server-id=1 log-slow-queries [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout Is there any tweaks i could do?? thanks Link to comment Share on other sites More sharing options...
bfarber Posted October 9, 2007 Share Posted October 9, 2007 query_cache_limit=2M key_buffer=768M join_buffer=2M record_buffer=2M What version of mysql is this? record_buffer changed to read_rnd_buffer or something like that in 4.1 as I recall. Link to comment Share on other sites More sharing options...
CFGuru Posted October 16, 2007 Share Posted October 16, 2007 query_cache_limit=2M key_buffer=768M join_buffer=2M record_buffer=2M What version of mysql is this? record_buffer changed to read_rnd_buffer or something like that in 4.1 as I recall. bfarber, Are there any similar types of performance tuning parameters for MSSQL? Link to comment Share on other sites More sharing options...
bfarber Posted October 16, 2007 Share Posted October 16, 2007 I'm not as familiar with MSSQL unfortunately. I'll see if Wizzy can reply to this. Link to comment Share on other sites More sharing options...
loccom Posted October 18, 2007 Share Posted October 18, 2007 query_cache_limit=2M key_buffer=768M join_buffer=2M record_buffer=2M What version of mysql is this? record_buffer changed to read_rnd_buffer or something like that in 4.1 as I recall. thanks for your reply 4.4.1 is the version i have Link to comment Share on other sites More sharing options...
bfarber Posted October 18, 2007 Share Posted October 18, 2007 bfarber, Are there any similar types of performance tuning parameters for MSSQL? There are, apparently, though the default config is usually pretty good apparently. We haven't done extensive testing, so it's hard to give recommendations. I'd recommend checking a database site like this one for better advice for MSSQL: http://www.sqlteam.com/forums/ Link to comment Share on other sites More sharing options...
CFGuru Posted October 19, 2007 Share Posted October 19, 2007 There are, apparently, though the default config is usually pretty good apparently. We haven't done extensive testing, so it's hard to give recommendations. I'd recommend checking a database site like this one for better advice for MSSQL: http://www.sqlteam.com/forums/ bfarber, Thanks. I thought maybe there were some tuning recommendations specific to IPB and MSSQL. But it sounds like its set up find out of the box. Thanks for getting back to me. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.