MySQL Forums
Forum List  »  InnoDB

MySQL query suck in NULL state
Posted by: Vitaly Gomenyuk
Date: April 09, 2019 08:46AM

Hello,
I'm using Oracle MySQL 5.6.26, Running the query which stuck in the "NULL" state. Time to time it changes the state to "Opening tables" and then back to "NULL" state. Have tried to double size "table_open_cache" parameter, but that doesn't help. No locks or deadlocks related to the code. Nothing strange in logs or inside innodb status. Query just keeps running with "NULL" state infinitely.
Please help.
Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL query suck in NULL state
32
April 09, 2019 08:46AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.