Re: [GENERAL] core system is getting unresponsive because over 300cpu load

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: [GENERAL] core system is getting unresponsive because over 300cpu load
Дата
Msg-id CAGnEboj64WH_zGVmiN=UE9ekLc1d4Z8MbSMrS=8cXTt3qOsBsQ@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] core system is getting unresponsive because over 300 cpu load  (pinker <pinker@onet.eu>)
Ответы Re: [GENERAL] core system is getting unresponsive because over 300 cpu load  (pinker <pinker@onet.eu>)
Список pgsql-general
Дерево обсуждения
2017-10-10 23:40 GMT+03:00 pinker <pinker@onet.eu>:
We've got problem with a very serious repetitive incident on our core
system. Namely, cpu load spikes to 300-400 and the whole db becomes
unresponsive. From db point of view nothing special is happening, memory
looks fine, disks io's are ok and the only problem is huge cpu load. Kernel
parameters that are increasing with load are always the same:

Can you provide output of `iostat -myx 10` at the “peak” moments, please?

Also, it'd be good to look in more detailed bgwriter/checkpointer stats.
(You might want to reset 'shared' stats here.)
 

--
Victor Yegorov

В списке pgsql-general по дате отправления:

Предыдущее
От: pinker
Дата:
Сообщение: Re: [GENERAL] core system is getting unresponsive because over 300 cpu load
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: [GENERAL] core system is getting unresponsive because over 300cpu load