Advertisement:

Author Topic: optimize my.cnf ?  (Read 24106 times)

Offline Flat-Jack

  • Semi-Newbie
  • *
  • Posts: 58
  • Gender: Male
  • :-)
optimize my.cnf ?
« on: May 12, 2004, 06:16:46 PM »
Hi there,

(I hope, it's not too much offtopic... :))
I got a new server last days...
Now my yabbse-Forum runs a little bit faster than before, but I have about 800MB free RAM, so I want to optimize my sql-settings, to get the maximum speed!  :D
  Which buffers/variables  are important for yabbse / SMF (i will upgrade soon) ?
here a few settings: P4 has 2GB RAM, we have about 400 Users online, 25000 Topics

As newbie, I tried to increase some variables...

my.cnf:

skip-locking
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 1024M
sort_buffer_size = 4M
record_buffer = 4M
net_buffer_length = 8K
myisam_sort_buffer_size = 64M
thread_concurrency = 4
thread_cache_size = 20
wait_timeout = 1800

no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 8M
write_buffer = 8M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 8M
write_buffer = 8M

[mysqlhotcopy]
interactive-timeout


Do you have any good hints for me?
Thank you - and excuse my bad english...

Flat-Jack

Offline Ben_S

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,708
  • xxx
Re: optimize my.cnf ?
« Reply #1 on: May 12, 2004, 07:37:37 PM »
Do a search on http://www.webhostingtalk.com & http://forum.ev1servers.net theres lots of optimisation guides there. A lot of it is trial and error too, tweak something and see how it runs etc.

You say you are running YaBB SE, you might want to try SMF, it will perform a whole lot better.
Liverpool FC Forum with 14 million+ posts.