Hello steve,

Thank you for your information.
It says that a long query help to acceralate shortage of semaphoes.
I try to check that these is a long query in the same situation.

--- Steve Wiser <steve@...> からのメッセージ：

> Hello,
>
> I just saw this happening on one of my servers a few weeks ago. We
> traced it to a 20 minute long select query that was creating temp files
> that in turn were filling up the /tmp partition. We ended up changing
> the query because it obviously was not the most efficient thing to look
> at and it now runs in 5 minutes (still kind of long) but barely uses a
> sort file. By the way this server had plenty of RAM (8 GB) and a lot of
> it was free.
>
> -steve

(snip)

Regards,
KIMURA, Meiji(FAMILY, Given)
Tokyo, JAPAN