Query 0 removing tmp table SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE EVENT_OBJECT_SCHEMA = DATABASE() AND EVEN 0 0

Query 139 Waiting for table level lock UPDATE xxxxx SET option_value = ‘1492781502’ WHERE option_name = ‘_transient_timeout_ 0 0

Query 139 Waiting for table level lock INSERT INTO xxxx (option_name, option_value, autoload) VALUES (‘_transient_doing_c 0 0

Query 138 Waiting for table level lock INSERT INTO xxxxx (option_name, option_value, autoload) VALUES (‘_transient_doing_c 0 0

Query 137 Waiting for table level lock UPDATE xxxxxx SET option_value = ‘1492781504’ WHERE option_name = ‘_transient_timeout_ 0
0

Query 134 Waiting for table level lock INSERT INTO xxxxxx (option_name, option_value, autoload) VALUES (‘_transient_is_mult 0 0

Query 126 Waiting for table level lock INSERT INTO xxxxxx (option_name, option_value, autoload) VALUES (‘_transient_timeout 0 0

Query 118 Waiting for table level lock INSERT INTO xxxxxx (option_name, option_value, autoload) VALUES (‘_transient_is_mult 0 0

Query 109 Waiting for table level lock UPDATE xxxxxx SET option_value = ‘1492781532’ WHERE option_name = ‘_transient_timeout_ 0
0

Query 104 Waiting for table level lock UPDATE xxxxxx SET option_value = ‘1492781537’ WHERE option_name = ‘_transient_timeout_ 0
0

Query 90 Waiting for table level lock UPDATE xxxxxx SET option_value = ‘1492781551’ WHERE option_name = ‘_transient_timeout_ 0
0

Query 81 Waiting for table level lock UPDATE xxxxxx SET option_value = ‘1492781560’ WHERE option_name = ‘_transient_timeout_ 0
0

Query 79 Waiting for table level lock UPDATE xxxxxx SET option_value = ‘1492781562’ WHERE option_name = ‘_transient_timeout_ 0
0

Query 75 Waiting for table level lock UPDATE xxxxxx SET option_value = ‘1492781566’ WHERE option_name = ‘_transient_timeout_ 0 0

Read more here: Does wp db export cause/produce this behavior


Solution:

If you know the solution of this issue, please leave us a reply in Comment section, to update the question.


Wordpress related questions and answers: