A log of challenges and findings in the pursuit of optimizing and scaling MySQL with large databases and thousands of users.
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?