Re: High %SYS CPU usage
| От | Cesar Martin |
|---|---|
| Тема | Re: High %SYS CPU usage |
| Дата | |
| Msg-id | CAMAsR=5ZnTtEzUw+X6kwCMdc4kDZYL2YVmzq_=ZoHQ8dTRKMmw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: High %SYS CPU usage (Cesar Martin <cmartinp@gmail.com>) |
| Список | pgsql-performance |
Finally I resolv the problem setting /sys/kernel/mm/redhat_transparent_hugepage/enabled to "never"
2012/11/2 Cesar Martin <cmartinp@gmail.com>
Hi Josh,Today is not the worse day for this issue, because Fridays DB have little workload... But I have this output:I don't have updated OS server from the install.I also begin to think that the problem is OS misconfiguration (Kernel parameters??) or Hardware problem...Thanks for your help.2012/10/30 Josh Berkus <josh@agliodbs.com>Cesar,Hmmm. Have you updated Linux any time recently? I'm wondering if this
> On this server I have only one database with 312GB of data. The database
> had run fine during 4 months, but from two months ago, during high work
> load periods, the server is collapsed by "%sys" type load.
is a PostgreSQL problem at all. It sounds like an OS issue.
Can you give us the results of mpstat -P ALL 3 ? The dstat output
doesn't tell me much.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
César Martín Pérez
cmartinp@gmail.com
В списке pgsql-performance по дате отправления: