Jump to content

Server Optimization request


Guest loccom

Recommended Posts

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

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

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

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...