AMD Athlon XP 2000+, 384K Cache
80GB Hard Drive / 7200 RPM
700GB Bandwidth Included
Dazzling Fast Tier-1-Network
99.999% Network Uptime
RedHat Linux 9.0
And i have some domains on this dedicate server running, 2 main domains. alizee-fanpage.com and alizee-forum.com (big forum database)
The forum is phpbb 2.0.8 modded... lots of mods...
I disabled gzip compression too... but mod_gzip? where do i disable that?php.ini? does this speed up my server?
and does zend or any php optimization speeds up my mysql?
I seems that mysql uses very much cpu and causes high serverload. How can i improve the settings?
Sometimes goes up to 10 and more...(the time when my server gets hard visited)
my.cnf > www . alizee-forum . com / my.cnf.txt
httpd.conf > www . alizee-forum . com / httpd.conf.txt
need andything more? and if yes, please provide how to get teh infos, i mean the command.
btw how do i get the top stats written in a txt file?
deos it helps to let mysql restart via crontab? from time to time?
Which version of mysql are you using? The newer versions allow for query cache and other features that improves performance.
Which DB backend are you using? MyISAM or InnoDB?
Also, it shouldn't help if you reset the DB regularly, since a long-running server process actually increases performance as it has a warmed-up cache (assuming that it doesn't have any memory leaks).
::. www.diginode.net : Dedicated Servers : Virtual Machine Servers .::
::. Industry-Leading Remote Server Management .::
::. Automatic OS Re-image : Instant Server Reboot : Remote Serial Console .::
::. Over 20 OSes to choose from : Install a new OS every day .::
i PMed you.. you should be able to handle the load.. I went to the forum.. you don't have a ton of current users at the time i saw.. i know phpbb is slow more so with mods added on. It does some really bad sql queries.. but you should be faster then you are..
i dont have so many online cause i did a restart due to modifications of mysql, ok talk to ya lateri hope you can help me out, but please answer, would it be better to get rid of those mods, it was a fully modded phpbb forum, tons of mods...
thanks man thats great that u try to help ppl, cause im a pupil not habving much time and money...
that forum and the website is very improtant for me...