January 17, 2010 in Classic self-hosted technical help
Hello I want to optimise my server for my invision forum... I'm fairly new to this and would some helpful easy to use advice...
Heres some of my forum statistics
Posts - 1,207,095
Users Online last 30 mins - 387 members, 660 guests
The server is AMD x2 5000+ processor with 4GB of DDR2 ram.
Heres details from my.cnf, not sure if they help, but I'm a newbie to this, do these setting look ok for my forum size, the databse is around 1.3gb when backed up?
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
max_connections = 500
key_buffer = 384M
max_allowed_packet = 3M
table_cache = 512
sort_buffer_size = 3M
read_buffer_size = 3M
read_rnd_buffer_size = 3M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
thread_concurrency = 8
wait_timeout = 30
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 4M
write_buffer = 4M
I had a board almost exactly the size of yours running quite comfortably on a 2.6 MHz Celeron with 512MB RAM, using only the output of tuning-primer.sh as a guide. Your rig should easily handle your load using that tool (but your traffic levels are higher, so I'd suggest making sure that the mysql DB is running on a second drive, not the one that runs everything else, including swapfile -- especially during routine daily/weekly maintenance jobs, where disk thrashing was a bit of an issue)
tuning-primer.sh observes your mysql in actual use for 48 hours or longer, and then makes specific recommendations based on the actual performance of *your* site under *your* real world traffic.
These days, Mysqltuner.pl is also highly regarded, but I haven't gotten around to trying it. I keep meaning to. Both are free.
I don't have source links, but this thread has links and sample output.
This topic is now archived and is closed to further replies.
Started Tuesday at 01:15 AM
Started 4 hours ago
Started 16 hours ago