GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Getting Help with MySQL Query

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Getting Help with MySQL Query

    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

  • #2
    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.

    Comment

    Working...
    X