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.

 

[Webcart]

It is impossible to tune a server you know nothing about

What OS is that? What's it used for?
What can you tell us about memory, CPU and I/O utilization?

 

[adrissaty]

Server Configuration & purpose

The server is user to host web sites based on the open source cms JOOMLA and for advertisment unsing PhpAdsNew.

The server is powered by the last version of debian.

 

[Webcart]

Re: Server Configuration & purpose

The server is user to host web sites based on the open source cms JOOMLA and for advertisment unsing PhpAdsNew.

The server is powered by the last version of debian.

That's a good start, but there is still long way to go.

What about memory, CPU and I/O utilization?

There are might be quite a few reasons for slow MySQL performance. Next time you experience a slowdown, check how much free RAM is available, how swap is used, IO stats, list of processes and MySQL queries running at that time.
If your database is large enough, a single MySQL query might cause all that. In that case tuning MySQL will probably have a very limited effect. You will have to optimize the database structure and/or tweak your CMS's source code.

Now, that's all a general info. Here is a couple of more practical tips:
1. Install some monitoring utilities. sysstat is a must. I would suggest also installing mytop though you could get a way with phpMyAdmin.
2. Check forums/some other resources related to your CMS. It might be a known problem. No need to reinvent the wheel here.

 

[adrissaty]

Thanks a lot

Thank you very much. I founded the problème. A turquish hacker used a vulnerability in a component of the cms joomla and used it to run a lot of perl script.

Every thing seems to be ok now.

I have Mytop installed and i will install other monitoring system.

Thanks a lot ans sorry if my english is so bad.