Server Optimization request

[loccom]

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

[bfarber]

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.

[CFGuru]

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?

[bfarber]

I'm not as familiar with MSSQL unfortunately. I'll see if Wizzy can reply to this.

[loccom]

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

[bfarber]

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/

[CFGuru]

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.