# Getting Help with MySQL Query

**URL:** <https://forums.percona.com/t/getting-help-with-mysql-query/3328>\
**Category:** Other MySQL® Questions\
**Created:** [March 11, 2014, 9:55am UTC](https://forums.percona.com/t/getting-help-with-mysql-query/3328 "2014-03-11T09:55:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![justin\_b](https://avatars.discourse-cdn.com/v4/letter/j/f04885/32.png) [@justin\_b](https://forums.percona.com/u/justin_b)\
**Post date:** [March 11, 2014, 9:55am UTC](https://forums.percona.com/t/getting-help-with-mysql-query/3328/1 "2014-03-11T09:55:15Z")

</div>

Hello,

I’m having some trouble with query #PTsgIv0J.

Whenever this query is called, the CPU drives up on the server - and the site that calls the query hangs. It isn’t until I kill the PID that the site recovers. Any advice is greatly appreciated!

Thanks,  
Justin

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [March 13, 2014, 1:26am UTC](https://forums.percona.com/t/getting-help-with-mysql-query/3328/2 "2014-03-13T01:26:27Z")

</div>

Hi,

I can’t able to check your query. can you provide the explain plan of that query and show table status of those tables which are involved in query?  
MySQL/Percona version will also help. Thanks.