Böyle bu kullanımın çözümü nedir ?

sunucum

Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(R) CPU X3220 @ 2.40GHz
Processor #1 speed: 2400.000 MHz
Processor #1 cache size: 4096 KB

4 çekirdekli


Ram 4 GB



My.cnf dosyam


[mysqld]
safe-show-database
back_log = 75
skip-innodb
max_connections = 500
key_buffer = 512M
myisam_sort_buffer_size = 128M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 4M
table_cache = 8192
thread_cache_size = 1024
wait_timeout = 15
connect_timeout = 10
tmp_table_size = 1M
max_heap_table_size = 128M
max_allowed_packet = 128M
max_connect_errors = 1000
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 16M
query_cache_limit = 4M
query_cache_size = 256M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM
old-passwords = 1

[mysqld_safe]
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M



ve top -c çıktısı

2653 mysql 10 -5 884m 249m 3436 S 19.6 6.4 153:23.96 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/ser
1848 root 0 -20 0 0 0 R 14.0 0.0 23:19.54 [loop0]
27148 genckoli 16 0 53732 14m 9164 S 3.3 0.4 0:01.14 lsphp5
27164 genckoli 18 0 54260 13m 8948 S 2.7 0.4 0:00.08 lsphp5
27166 genckoli 17 0 54140 13m 8940 S 2.7 0.4 0:00.08 lsphp5
27167 genckoli 17 0 53020 12m 8756 S 2.7 0.3 0:00.08 lsphp5
27168 genckoli 22 0 52312 11m 8240 S 2.0 0.3 0:00.06 lsphp5
1849 root 10 -5 0 0 0 S 1.0 0.0 1:57.62 [kjournald]
2963 nobody 0 -19 10528 8432 716 S 1.0 0.2 1:05.01 lshttpd
27165 kocaelim 17 0 50824 6988 4860 S 1.0 0.2 0:00.03 lsphp5
27147 genckoli 16 0 54564 14m 8788 S 0.7 0.4 0:00.15 lsphp5
442 root 10 -5 0 0 0 S 0.3 0.0 0:02.68 [ata/2]
485 root 10 -5 0 0 0 D 0.3 0.0 1:39.87 [kjournald]
2919 root 0 -19 6640 4644 516 S 0.3 0.1 0:04.97 lshttpd
2964 nobody 0 -19 6688 4488 340 S 0.3 0.1 0:07.17 lshttpd
27152 genckoli 15 0 54260 15m 9592 S 0.3 0.4 0:00.51 lsphp5
27157 root 15 0 0 0 0 S 0.3 0.0 0:00.21 [pdflush]
27159 root 15 0 2332 1084 808 R 0.3 0.0 0:00.06 top -c
27161 root 15 0 0 0 0 S 0.3 0.0 0:00.07 [pdflush]
1 root 15 0 2068 628 540 S 0.0 0.0 0:00.90 init [3]
2 root RT -5 0 0 0 S 0.0 0.0 0:00.05 [migration/0]
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 [ksoftirqd/0]
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 [watchdog/0]
5 root RT -5 0 0 0 S 0.0 0.0 0:00.02 [migration/1]
6 root 34 19 0 0 0 S 0.0 0.0 0:00.00 [ksoftirqd/1]
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 [watchdog/1]
8 root RT -5 0 0 0 S 0.0 0.0 0:00.07 [migration/2]
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 [ksoftirqd/2]
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 [watchdog/2]
11 root RT -5 0 0 0 S 0.0 0.0 0:00.02 [migration/3]
12 root 34 19 0 0 0 S 0.0 0.0 0:00.00 [ksoftirqd/3]
13 root RT -5 0 0 0 S 0.0 0.0 0:00.00 [watchdog/3]
14 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [events/0]
15 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [events/1]
16 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 [events/2]
17 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [events/3]
18 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [khelper]
19 root 10 -5 0 0 0 S 0.0 0.0 0:00.02 [kthread]
25 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 [kblockd/0]
root@server [~]#


Sunucu üzerinde litespeed bile kurduk ama oranlarda degişme olmadı ... içerisinde vbulletin forumvar yaklaşık 3 gb veri tabanı olan bu konuda ne yapmalıyım yada optimize edebilecek arkadaş varmı ( ücretli) vbulletin üzerinde vbseo da kurulu.

site okadar yavaşladıki anlatamam.