[iyinet]

Holokost´isimli üyeden Alıntı

merhaba iyinet yeni sunucumun mysql optimizasyonunda yardımcı olur musunuz

AMD Athlon 64 X2 5200+
4096 DDR2 Ram
Centos 4.x
cPanel


Top

top - 08:05:19 up 1 day, 57 min,  1 user,  load average: 12.57, 8.79, 7.26
Tasks: 222 total,  21 running, 197 sleeping,   0 stopped,   4 zombie
Cpu(s): 58.0%us,  7.4%sy,  0.2%ni, 33.7%id,  0.4%wa,  0.0%hi,  0.2%si,  0.0%st
Mem:   3500440k total,  3293824k used,   206616k free,   195588k buffers
Swap:  2031608k total,       80k used,  2031528k free,  1850356k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 2617 mysql     15   0 53732  27m 2732 S   86  0.8 988:22.30 mysqld
18616 nobody    16   0 23820  14m 2168 R   34  0.4   1:45.20 httpd
28699 nobody    16   0 23820  14m 2168 R   11  0.4   1:18.40 httpd
 1609 nobody    16   0 18332 9492 1844 R   10  0.3   0:01.30 httpd
18747 nobody    15   0 23872  15m 2564 S   10  0.4   2:49.81 httpd
21716 nobody    15   0 23400  14m 2164 S    8  0.4   0:26.61 httpd
  339 nobody    15   0 23156  14m 1852 S    6  0.4   0:01.99 httpd
 1189 nobody    16   0 19752  10m 1932 S    6  0.3   0:00.36 httpd
 2141 nobody    16   0 16916 8036 1784 R    6  0.2   0:00.10 httpd
 8360 nobody    15   0 23912  14m 2164 S    6  0.4   1:19.82 httpd
24567 nobody    17   0 24872  15m 1936 R    6  0.5   0:08.04 httpd
25081 nobody    25   0  6548 2612 1108 R    6  0.1  14:11.80 perl
 2295 root      16   0 19640 9592 1576 S    2  0.3   0:00.01 cpsrvd-ssl
 2298 root      18   0 15656 6328 3220 R    2  0.2   0:00.01 xml-api
19791 root      15   0 19628 8936 1004 S    2  0.3   0:00.04 cpsrvd-ssl
    1 root      15   0  2044  640  552 S    0  0.0   0:01.06 init
    2 root      RT   0     0    0    0 S    0  0.0   0:00.15 migration/0
    3 root      34  19     0    0    0 R    0  0.0   0:01.06 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:00.17 migration/1
    6 root      34  19     0    0    0 R    0  0.0   0:00.00 ksoftirqd/1
    7 root      RT   0     0    0    0 S    0  0.0   0:00.00 watchdog/1
    8 root      10  -5     0    0    0 S    0  0.0   0:00.01 events/0
    9 root      10  -5     0    0    0 S    0  0.0   0:00.00 events/1
   10 root      10  -5     0    0    0 S    0  0.0   0:00.00 khelper
   11 root      10  -5     0    0    0 S    0  0.0   0:00.00 kthread
   15 root      10  -5     0    0    0 S    0  0.0   0:00.28 kblockd/0
   16 root      10  -5     0    0    0 S    0  0.0   0:00.05 kblockd/1
   17 root      15  -5     0    0    0 S    0  0.0   0:00.00 kacpid
  122 root      15  -5     0    0    0 S    0  0.0   0:00.00 cqueue/0
  123 root      15  -5     0    0    0 S    0  0.0   0:00.00 cqueue/1
  126 root      10  -5     0    0    0 S    0  0.0   0:00.00 khubd
  128 root      10  -5     0    0    0 S    0  0.0   0:00.00 kseriod
  196 root      19   0     0    0    0 S    0  0.0   0:08.85 pdflush
  197 root      10  -5     0    0    0 S    0  0.0   0:01.47 kswapd0
  198 root      17  -5     0    0    0 S    0  0.0   0:00.00 aio/0
  199 root      17  -5     0    0    0 S    0  0.0   0:00.00 aio/1

my.cnf

[mysqld]
safe-show-database
skip-locking
skip-innodb
skip-name-resolve

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

Teşekkürler

http://forum.iyinet.com/mysql-verita...g-scripti.html çıktısını da alabilirmiyim.