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.

 

[xemaps]

first see with your host company how much real bandwith and speed U/D you have.
How much domain do you host ?
Have you soon stats ?

One my DA host is similar and runs perfectly.

 

[existenz]

First what OS are you running?

Then you need to look at the entire picture and figure out what you need to tune.

Some basics:

Look to see various times of the day what the load avarage is. `top`

Look at iostat and vmstat and get a idea how the system performs, including disk access, possibly you need a faster drive.

Look at dmesg for any errors

Look at netstat for more about how the network if configured, you can quickly get a idea how many connections are being connected to a service like this (keep in mind this is not the number of unique connections). sub the number with the port you want to check 80, 3306, 25, 53

netstat -nt | grep 80 | wc

You will need to get a idea what mysql is doing, so check with mysqladmin and run the processlist looks for any waits.

Do you have many php or perl process and what are they doing, when you see one possibly in top do a strace -p (process number )

Give back some of that information during different times and we can give you a better idea of what is going on.

Tuning requires a great deal of knowledge about the os, just like security don't be fooled by all these guys out their that can do it, especially if they think they can go in once and fix all your problems. It takes time to tweak the system properly. I administer servers that have 2,500 website with loads around a .4 most of the time.