Re[4]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database
| От | nobody nowhere |
|---|---|
| Тема | Re[4]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database |
| Дата | |
| Msg-id | 1357333670.666306657@f14.mail.ru обсуждение исходный текст |
| Ответ на | SMP on a heavy loaded database (nobody nowhere <devnull@mail.ua>) |
| Ответы |
Re: Re[2]: [PERFORM] SMP on a heavy loaded database
Re: Re[4]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database |
| Список | pgsql-performance |
>Oh... and you can also tell top to show the "last used processor". I >guess I should have said this first ;-) Even if do not fix it, I'll know a new feature of top :) Certainly sure 14 CPU Total DISK READ: top - 21:54:38 up 453 days, 23:34, 1 user, load average: 0.56, 0.55, 0.48 Tasks: 429 total, 1 running, 428 sleeping, 0 stopped, 0 zombie Cpu0 : 0.2%us, 0.1%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu1 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu2 : 0.1%us, 0.1%sy, 0.0%ni, 99.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu3 : 0.7%us, 0.1%sy, 0.0%ni, 99.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu4 : 1.5%us, 0.4%sy, 0.0%ni, 98.0%id, 0.0%wa, 0.0%hi, 0.1%si, 0.0%st Cpu5 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu6 : 2.1%us, 0.2%sy, 0.0%ni, 97.4%id, 0.2%wa, 0.0%hi, 0.1%si, 0.0%st Cpu7 : 2.4%us, 0.4%sy, 0.0%ni, 97.0%id, 0.0%wa, 0.0%hi, 0.2%si, 0.0%st Cpu8 : 1.4%us, 0.4%sy, 0.0%ni, 98.1%id, 0.0%wa, 0.0%hi, 0.1%si, 0.0%st Cpu9 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu10 : 0.1%us, 0.0%sy, 0.0%ni, 99.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu11 : 1.2%us, 0.5%sy, 0.0%ni, 97.9%id, 0.0%wa, 0.0%hi, 0.5%si, 0.0%st Cpu12 : 0.1%us, 0.0%sy, 0.0%ni, 99.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu13 : 0.1%us, 0.0%sy, 0.0%ni, 99.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu14 : 20.5%us, 0.9%sy, 0.0%ni, 78.1%id, 0.4%wa, 0.0%hi, 0.1%si, 0.0%st Cpu15 : 1.2%us, 0.1%sy, 0.0%ni, 98.5%id, 0.0%wa, 0.0%hi, 0.2%si, 0.0%st Mem: 16426540k total, 16173980k used, 252560k free, 219348k buffers Swap: 4194232k total, 147296k used, 4046936k free, 14482096k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ P COMMAND 47 root RT -5 0 0 0 S 0.0 0.0 0:34.84 15 [migration/15] 48 root 34 19 0 0 0 S 0.0 0.0 0:01.42 15 [ksoftirqd/15] 49 root RT -5 0 0 0 S 0.0 0.0 0:00.00 15 [watchdog/15] 65 root 10 -5 0 0 0 S 0.0 0.0 0:00.03 15 [events/15] 238 root 10 -5 0 0 0 S 0.0 0.0 0:03.76 15 [kblockd/15] 406 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 15 [cqueue/15] 601 root 15 0 0 0 0 S 0.0 0.0 88:52.30 15 [pdflush] 620 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 15 [aio/15] 964 root 17 -5 0 0 0 S 0.0 0.0 0:00.00 15 [ata/15] 2684 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 15 [kmpathd/15] 2914 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 15 [rpciod/15] 3270 root 19 -5 0 0 0 S 0.0 0.0 0:00.00 15 [ib_cm/15] 5906 rpc 15 0 8072 688 552 S 0.0 0.0 0:00.00 15 portmap 14979 postgres 15 0 4316m 104m 103m S 0.0 0.6 6:54.39 15 /usr/pgsql-9.1/bin/postmaster -p 5432 -D /var/lib/pgsql/9.1/data 44 root RT -5 0 0 0 S 0.0 0.0 0:40.50 14 [migration/14] 45 root 34 19 0 0 0 S 0.0 0.0 0:03.51 14 [ksoftirqd/14] 46 root RT -5 0 0 0 S 0.0 0.0 0:00.00 14 [watchdog/14] 64 root 10 -5 0 0 0 S 0.0 0.0 0:00.04 14 [events/14] 237 root 10 -5 0 0 0 S 0.0 0.0 9:51.44 14 [kblockd/14] 405 root 13 -5 0 0 0 S 0.0 0.0 0:00.00 14 [cqueue/14] 619 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 14 [aio/14] 963 root 16 -5 0 0 0 S 0.0 0.0 0:00.00 14 [ata/14] 1092 root 10 -5 0 0 0 S 0.0 0.0 52:21.12 14 [kjournald] 2683 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 14 [kmpathd/14] 2724 root 10 -5 0 0 0 S 0.0 0.0 2:15.40 14 [kjournald] 2726 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 14 [kjournald] 2913 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 14 [rpciod/14] 3269 root 18 -5 0 0 0 S 0.0 0.0 0:00.00 14 [ib_cm/14] 8970 postgres 16 0 4327m 205m 197m S 0.2 1.3 0:01.33 14 postgres: user user_db [local] idle 8973 postgres 15 0 4327m 199m 191m S 0.1 1.2 0:00.37 14 postgres: user user_db [local] idle 8977 postgres 16 0 4328m 48m 40m S 0.7 0.3 0:00.76 14 postgres: user user_db [local] idle 8980 postgres 16 0 4328m 51m 43m S 0.1 0.3 0:00.50 14 postgres: user user_db [local] idle 8981 postgres 15 0 4327m 203m 195m S 0.0 1.3 0:00.72 14 postgres: user user_db [local] idle 8985 postgres 15 0 4327m 43m 36m S 0.1 0.3 0:00.29 14 postgres: user user_db [local] idle 8988 postgres 16 0 4328m 205m 196m S 0.0 1.3 0:00.91 14 postgres: user user_db [local] idle 8991 postgres 15 0 4327m 205m 197m S 0.1 1.3 0:00.79 14 postgres: user user_db [local] idle 8993 postgres 15 0 4328m 207m 199m S 1.9 1.3 0:00.99 14 postgres: user user_db [local] idle 8996 postgres 15 0 4328m 205m 196m S 1.1 1.3 0:00.93 14 postgres: user user_db [local] idle 9000 postgres 16 0 4328m 207m 199m S 0.7 1.3 0:00.82 14 postgres: user user_db [local] idle 9004 postgres 16 0 4329m 204m 194m S 0.1 1.3 0:00.69 14 postgres: user user_db [local] idle 9005 postgres 15 0 4327m 200m 193m S 0.7 1.2 0:00.63 14 postgres: user user_db [local] idle 9007 postgres 15 0 4327m 199m 192m S 0.1 1.2 0:00.49 14 postgres: user user_db [local] idle 9010 postgres 15 0 4327m 202m 195m S 0.2 1.3 0:00.65 14 postgres: user user_db [local] idle 9016 postgres 15 0 4326m 34m 28m S 0.1 0.2 0:00.15 14 postgres: user user_db [local] idle 9018 postgres 16 0 4327m 203m 195m S 1.0 1.3 0:00.72 14 postgres: user user_db [local] idle 9020 postgres 15 0 4327m 45m 37m S 0.1 0.3 0:00.49 14 postgres: user user_db [local] idle 9022 postgres 15 0 4327m 42m 35m S 0.1 0.3 0:00.20 14 postgres: user user_db [local] idle 9025 postgres 16 0 4328m 201m 193m S 0.3 1.3 0:00.75 14 postgres: user user_db [local] idle 9026 postgres 16 0 4327m 47m 40m S 0.1 0.3 0:00.49 14 postgres: user user_db [local] idle 9038 postgres 16 0 4327m 201m 193m S 0.1 1.3 0:00.70 14 postgres: user user_db [local] idle 9042 postgres 15 0 4327m 201m 193m S 1.8 1.3 0:00.71 14 postgres: user user_db [local] idle 9046 postgres 15 0 4327m 201m 193m S 0.1 1.3 0:00.65 14 postgres: user user_db [local] idle 9048 postgres 15 0 4327m 200m 193m S 1.4 1.2 0:00.52 14 postgres: user user_db [local] idle 9049 postgres 15 0 4328m 200m 192m S 0.1 1.2 0:00.50 14 postgres: user user_db [local] idle 9053 postgres 15 0 4327m 44m 37m S 0.1 0.3 0:00.34 14 postgres: user user_db [local] idle 9054 postgres 16 0 4327m 46m 40m S 0.1 0.3 0:00.43 14 postgres: user user_db [local] idle 9055 postgres 16 0 4328m 200m 192m S 0.0 1.3 0:00.39 14 postgres: user user_db [local] idle 9056 postgres 16 0 4328m 201m 192m S 0.7 1.3 0:00.75 14 postgres: user user_db [local] idle 9057 postgres 16 0 4327m 200m 192m S 0.2 1.3 0:00.72 14 postgres: user user_db [local] idle 9061 postgres 15 0 4328m 200m 192m S 0.0 1.2 0:00.49 14 postgres: user user_db [local] idle 9065 postgres 15 0 4328m 204m 196m S 0.3 1.3 0:00.80 14 postgres: user user_db [local] idle 9067 postgres 15 0 4327m 43m 35m S 0.0 0.3 0:00.30 14 postgres: user user_db [local] idle 9071 postgres 15 0 4327m 48m 40m S 0.1 0.3 0:00.53 14 postgres: user user_db [local] idle 9076 postgres 15 0 4326m 43m 36m S 0.0 0.3 0:00.61 14 postgres: user user_db [local] idle 9078 postgres 15 0 4328m 206m 198m S 0.0 1.3 0:00.64 14 postgres: user user_db [local] idle 9079 postgres 15 0 4327m 45m 38m S 0.0 0.3 0:00.37 14 postgres: user user_db [local] idle 9080 postgres 16 0 4327m 200m 193m S 0.0 1.3 0:00.62 14 postgres: user user_db [local] idle 9082 postgres 16 0 4328m 202m 193m S 1.5 1.3 0:00.84 14 postgres: user user_db [local] idle 9084 postgres 15 0 4327m 46m 38m S 0.0 0.3 0:00.54 14 postgres: user user_db [local] idle 9086 postgres 15 0 4328m 203m 194m S 0.0 1.3 0:00.38 14 postgres: user user_db [local] idle 9087 postgres 16 0 4327m 199m 192m S 1.0 1.2 0:00.63 14 postgres: user user_db [local] idle 9089 postgres 16 0 4328m 205m 196m S 0.2 1.3 0:00.87 14 postgres: user user_db [local] idle 9091 postgres 15 0 4327m 45m 38m S 0.1 0.3 0:00.41 14 postgres: user user_db [local] idle 9092 postgres 16 0 4326m 41m 34m S 0.0 0.3 0:00.27 14 postgres: user user_db [local] idle 9098 postgres 16 0 4329m 203m 194m S 3.5 1.3 0:00.65 14 postgres: user user_db [local] idle 9099 postgres 16 0 4327m 45m 38m S 0.0 0.3 0:00.41 14 postgres: user user_db [local] idle 13629 root 18 0 65288 280 140 S 0.0 0.0 0:00.00 14 rpc.rquotad
В списке pgsql-performance по дате отправления: