I have one server with below info. can you please help me to tune this server this server is very slow. i hosted three website in this server m
Ther is no load on this server but all the websites are very slow.

I am using Default my.cnf and http.conf ( didn't tune this server )
Please help me to tune this serverr



RAM 2GB
Intel® Xeon™ CPU 2.80GHz


apache 2
5.0.45-community
PHP-5.2.5


--------------------------------------------------
root@apple [~]# free -m
total used free shared buffers cached
Mem: 2026 1964 61 0 69 1582
-/+ buffers/cache: 313 1713
Swap: 1992 0 1992
--------------------------
root@apple [~]# ps aux | grep -c http
31
root@apple [~]#

---------------------------
TOP
-------
top - 03:46:40 up 23 days, 22:13, 6 users, load average: 0.03, 0.04, 0.00
Tasks: 194 total, 1 running, 193 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.2%us, 0.1%sy, 0.0%ni, 99.3%id, 0.5%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 2075060k total, 2018932k used, 56128k free, 71276k buffers
Swap: 2040212k total, 92k used, 2040120k free, 1636656k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
7040 mysql 18 0 122m 26m 4564 S 0 1.3 254:39.87 mysqld
17814 nobody 24 0 19560 8688 2676 S 0 0.4 0:00.27 httpd
18448 root 15 0 2300 1064 800 R 0 0.1 0:00.04 top
1 root 15 0 2040 592 512 S 0 0.0 0:03.37 init
2 root RT 0 0 0 0 S 0 0.0 0:00.32 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.02 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/0
5 root RT 0 0 0 0 S 0 0.0 0:01.39 migration/1
6 root 38 19 0 0 0 S 0 0.0 0:00.09 ksoftirqd/1
7 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/1
8 root RT 0 0 0 0 S 0 0.0 0:00.36 migration/2
9 root 39 19 0 0 0 S 0 0.0 0:00.06 ksoftirqd/2
10 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/2
11 root RT 0 0 0 0 S 0 0.0 0:00.49 migration/3
12 root 34 19 0 0 0 S 0 0.0 0:00.11 ksoftirqd/3
13 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/3
14 root 10 -5 0 0 0 S 0 0.0 0:00.08 events/0
-----------------------



my.cnf.
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
#old_passwords=1

[mysql.server]
user=mysql
#basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


Regards
Dxbee

The default configurations are ideal for the sufficient real-world performance in most situations. Since the server is showing almost no load, I believe the problem lies within the software or network.

1. Try network testing both with large files and many small files (concurrent download)
2. Check your software for the number of queries being executed for a single request. A faulty plugin/mod of forums is often a cause of trouble.

If you want to monitor MySQL queries, google for mytop.