Originariamente Scritto da
ibanez89
manda un top mentre fai le query, probabilmente vedrai un i/o wait, gli rps hanno dei dischi molto lenti... ad utilizzo di ram come sei messo?
Ciao Ecco il Top durante un operazione su database.
Purtroppo non me ne intendo..
top - 10:08:19 up 15:28, 2 users, load average: 1.13, 1.25, 1.17
Tasks: 154 total, 3 running, 150 sleeping, 0 stopped, 1 zombie
Cpu(s): 12.6% us, 4.5% sy, 0.0% ni, 48.9% id, 33.4% wa, 0.2% hi, 0.5% si
Mem: 499872k total, 494324k used, 5548k free, 2024k buffers
Swap: 1986552k total, 2732k used, 1983820k free, 189680k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
30316 mysql 20 0 661m 147m 4388 S 20 30.3 0:06.56 mysqld
3274 prezzone 20 0 25496 14m 3592 R 12 3.0 0:00.42 php
27954 mysql 20 0 661m 147m 4388 D 2 30.3 0:12.68 mysqld
254 root 15 -5 0 0 0 S 1 0.0 0:14.80 kswapd0
2630 root 20 0 2892 836 644 S 1 0.2 1:24.30 collectd
3276 root 20 0 2120 1124 828 R 1 0.2 0:00.04 top
1132 root 15 -5 0 0 0 S 0 0.0 1:03.42 scsi_wq_2
1 root 20 0 1480 500 448 S 0 0.1 0:01.56 init
2 root 15 -5 0 0 0 S 0 0.0 0:00.00 kthreadd
3 root RT -5 0 0 0 S 0 0.0 0:00.32 migration/0
4 root 15 -5 0 0 0 S 0 0.0 0:03.70 ksoftirqd/0
5 root RT -5 0 0 0 S 0 0.0 0:00.30 migration/1
6 root 15 -5 0 0 0 S 0 0.0 0:09.18 ksoftirqd/1
7 root 15 -5 0 0 0 S 0 0.0 0:03.36 events/0
8 root 15 -5 0 0 0 S 0 0.0 0:03.42 events/1
9 root 15 -5 0 0 0 S 0 0.0 0:00.88 khelper
114 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/0
115 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/1
116 root 15 -5 0 0 0 S 0 0.0 0:00.38 kblockd/0
117 root 15 -5 0 0 0 S 0 0.0 0:00.04 kblockd/1
118 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpid
119 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpi_notify
192 root 15 -5 0 0 0 S 0 0.0 0:00.00 ata/0
193 root 15 -5 0 0 0 S 0 0.0 0:00.00 ata/1
194 root 15 -5 0 0 0 S 0 0.0 0:00.00 ata_aux
195 root 15 -5 0 0 0 S 0 0.0 0:00.00 ksuspend_usbd
200 root 15 -5 0 0 0 S 0 0.0 0:00.00 khubd
203 root 15 -5 0 0 0 S 0 0.0 0:00.00 kseriod
252 root 20 0 0 0 0 S 0 0.0 0:00.00 pdflush
253 root 20 0 0 0 0 S 0 0.0 0:07.10 pdflush
255 root 15 -5 0 0 0 S 0 0.0 0:00.00 aio/0
256 root 15 -5 0 0 0 S 0 0.0 0:00.00 aio/1
259 root 15 -5 0 0 0 S 0 0.0 0:00.00 nfsiod
260 root 15 -5 0 0 0 S 0 0.0 0:00.00 cifsoplockd
261 root 15 -5 0 0 0 S 0 0.0 0:00.00 cifsdnotifyd
263 root 15 -5 0 0 0 S 0 0.0 0:00.00 xfs_mru_cache
264 root 15 -5 0 0 0 S 0 0.0 0:00.00 xfslogd/0
265 root 15 -5 0 0 0 S 0 0.0 0:00.00 xfslogd/1
266 root 15 -5 0 0 0 S 0 0.0 0:00.00 xfsdatad/0
267 root 15 -5 0 0 0 S 0 0.0 0:00.00 xfsdatad/1
268 root 15 -5 0 0 0 S 0 0.0 0:15.04 gfs2_scand
269 root 15 -5 0 0 0 S 0 0.0 0:00.00 glock_workqueue