Tuesday, January 24, 2012

The Never Ending Query

Last night, I got a page from zabbix warning me of a thread count threshold hit. I was cooking dinner, left the stovetop and walked over into my home office. I run innotop pretty much all of the time on our master server.

Here is a small screenshot of what I saw:

These three queries were running for over 5 hours, and I would be willing to bet that these queries would NEVER finish.  But why?

More to come.

No comments:

Post a Comment