I currently run a Website which gets around 100,000 hits a day. The CMS software is Joomla, I run Coppermine Photo Gallery, and PHPBB. The messageboard has around 280,000 posts… and on average it’s around 300 users online.
For some reason MYSQL performs very very slow. I have two servers. I use one as a dedicated Web Server, and the other as a dedicated database server. The specs for both servers identical:
Each Server Has:
2 X Dual Core Xeon 5110 /4MB Cache
4 Gigs Of Ram
2 X 300GB SAS Drives
The load on the webserver never reaches more than 10%. I use Apache/ Windows Server 2003, and MYSQL 5.037 . Database server frequently uses 700mb of memory and load fluctuates between 20-50%. Sometimes the site runs fast, and at other times it runs very very slow. I was wondering if someone could assist me in optimizing MYSQL so my site could be blazing fast like it should be.
Here is my my.ini file:
The TCP/IP Port the MySQL Server will listen on
basedir=“C:/Program Files/MySQL/MySQL Server 5.0/”
datadir=“C:/Program Files/MySQL/MySQL Server 5.0/Data/”
#*** INNODB Specific options ***
If you are willing to help me then private message me some contact information. E-Mail/AOL/YAhoo/ICQ is fine. I prefer instant message though.