MySQL and Serverload Problems, Urgent
AMD Athlon XP 2000+, 384K Cache
768MB DDR-RAM
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)
Files:
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?
