Tuning MySQL & Apache, your help is needed

[adrissaty]

Hi every body, i have the configuration below:

Processor Name Intel(R) Celeron(R) CPU 2.00GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 1980.365
Total Memory 1028396 kB
Free Memory 11048 kB
Total Swap Memory 979924 kB
Free Swap Memory 979924 kB
System Uptime 5 Days, 17 Hours and 15 Minutes
Apache 1.3.36
DirectAdmin
Exim 4.54
MySQL
Named 9.2.4
ProFTPd 1.2.10
sshd
vm-Pop3d 1.1.7f-T6-DA

Can you tell me please what's the best configuration for Apache and MySQL ?

I think i must tune my server because operation on MySQL are very slow and i have every time out connectoin problems.

Please i need your help.

Tnhank you.

 

[either]

go to New Server Checklist

 

[existenz]

Their is a ton of information we would need to give you a real idea on how to tune your server. If you think you are having wait problems with mysql. Check mysqladmin or mysql

#mysql -u root -p
#(enter pwd)
mysql> show processlist;

Check to see if you see a bunch of stuff sleeping. If you do creat a my.cnf in /etc. You will need to set a option for the timeout, my default it is very high and causes problems.

 

[Webcart]

Just came across this thread and noticed it looked familiar.

Apparently, it was x-posted http://www.directadmin.com/forum/showthread.php?s=&threadid=14177