• These started all at once, broke de site. I have no idea what is the cause:

    # Time: 161020 14:57:56
    # User@Host: username[username] @ localhost []
    # Query_time: 230.587284 Lock_time: 123.157563 Rows_sent: 2141 Rows_examined: 4518
    SET timestamp=1476964676;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # Time: 161020 14:58:01
    # User@Host: username[username] @ localhost []
    # Query_time: 227.499450 Lock_time: 114.900787 Rows_sent: 2141 Rows_examined: 4518
    SET timestamp=1476964681;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # Time: 161020 14:58:10
    # User@Host: username[username] @ localhost []
    # Query_time: 15.700940 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
    SET timestamp=1476964690;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 121.369129 Lock_time: 112.395874 Rows_sent: 0 Rows_examined: 1
    SET timestamp=1476964690;
    UPDATE dan_options SET option_value = ‘1476964599’ WHERE option_name = ‘_transient_timeout__redux_activation_redirect’;
    # Time: 161020 14:58:24
    # User@Host: username[username] @ localhost []
    # Query_time: 121.132230 Lock_time: 0.860651 Rows_sent: 1 Rows_examined: 3858
    SET timestamp=1476964704;
    SELECT COUNT(*) FROM dan_term_relationships, dan_posts WHERE dan_posts.ID = dan_term_relationships.object_id AND post_status = ‘publish’ AND post_type IN (‘post’) AND term_taxonomy_id = 2596;
    # Time: 161020 14:58:27
    # User@Host: username[username] @ localhost []
    # Query_time: 128.035769 Lock_time: 110.866842 Rows_sent: 0 Rows_examined: 0
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 50.444723 Lock_time: 0.000345 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 50.611468 Lock_time: 0.000400 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 51.005349 Lock_time: 0.000113 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 51.105955 Lock_time: 0.000116 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 50.888373 Lock_time: 0.000267 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 50.916246 Lock_time: 0.000135 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 51.090708 Lock_time: 0.000247 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 50.999744 Lock_time: 0.070962 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 50.617925 Lock_time: 0.000286 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 42.647202 Lock_time: 3.311189 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # Time: 161020 15:01:00
    # User@Host: username[username] @ localhost []
    # Query_time: 6.093890 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
    # User@Host: username[username] @ localhost []
    # Query_time: 42.732220 Lock_time: 3.506544 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 51.174762 Lock_time: 0.026269 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 50.773177 Lock_time: 0.000210 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 50.777335 Lock_time: 0.000239 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 50.702747 Lock_time: 0.000302 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 51.079761 Lock_time: 0.029046 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964867;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # Time: 161020 15:01:13
    # User@Host: username[username] @ localhost []
    # Query_time: 22.755586 Lock_time: 0.070338 Rows_sent: 4 Rows_examined: 1464
    SET timestamp=1476964873;
    SELECT SQL_CALC_FOUND_ROWS dan_posts.ID FROM dan_posts LEFT JOIN dan_term_relationships ON (dan_posts.ID = dan_term_relationships.object_id) WHERE 1=1 AND (
    dan_term_relationships.term_taxonomy_id IN (7097)
    ) AND dan_posts.post_type = ‘post’ AND (dan_posts.post_status = ‘publish’ OR dan_posts.post_status = ‘closed’) GROUP BY dan_posts.ID ORDER BY dan_posts.post_date DESC LIMIT 0, 4;
    # Time: 161020 15:01:16
    # User@Host: username[username] @ localhost []
    # Query_time: 59.716651 Lock_time: 0.000289 Rows_sent: 424 Rows_examined: 437
    SET timestamp=1476964876;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # Time: 161020 15:01:37
    # User@Host: username[username] @ localhost []
    # Query_time: 80.837758 Lock_time: 0.029910 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964897;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 68.660920 Lock_time: 1.124937 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964897;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # Time: 161020 15:01:38
    # User@Host: username[username] @ localhost []
    # Query_time: 81.700443 Lock_time: 0.027973 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964898;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # User@Host: username[username] @ localhost []
    # Query_time: 82.521286 Lock_time: 0.029824 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964898;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # Time: 161020 15:01:39
    # Time: 161020 15:01:39
    # User@Host: username[username] @ localhost []
    # Query_time: 82.834236 Lock_time: 0.029782 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964899;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # Time: 161020 15:01:43
    # User@Host: username[username] @ localhost []
    # Query_time: 87.165581 Lock_time: 0.015799 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964903;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # Time: 161020 15:01:45
    # User@Host: username[username] @ localhost []
    # Query_time: 89.441485 Lock_time: 0.029422 Rows_sent: 562 Rows_examined: 584
    SET timestamp=1476964905;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # Time: 161020 15:01:47
    # User@Host: username[username] @ localhost []
    # Query_time: 71.545709 Lock_time: 0.313747 Rows_sent: 2199 Rows_examined: 6496
    SET timestamp=1476964907;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # Time: 161020 15:01:57
    # User@Host: username[username] @ localhost []
    # Query_time: 7.027376 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
    SET timestamp=1476964917;
    SELECT option_name, option_value FROM dan_options WHERE autoload = ‘yes’;
    # Time: 161020 15:02:01
    # User@Host: username[username] @ localhost []

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Uncknown Mysql queries – what can be the cause?’ is closed to new replies.