Not the answer you need?
Register and ask your own question!

Getting Help with MySQL Query

justin_bjustin_b EntrantInactive User Role Beginner
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

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.