• Resolved jjantunen

    (@jjantunen)


    My website in having some strange action in the mariadb.
    Disabling addons and changing the theme has no effect on the problem.

    This is one of the sections that comes up several times a second. There are others too when it finds images to batch or ones with a different payload in the end than the image batch thing.

    The problem is that these query packets amount into a wopping 900 queries per second constantly. The server is running really hot.

    I tried replicating it on a staging server to test it out in a more deep manner but i am unable to replicate this.

    Does anyone know what could be causing this. This happens when all the addons except woocommerce are disabled and theme is set to unedited StoreFront. Its worse when all the addons are enabled as they make their own actions adding to this.

    Section of the troublesome sql:
    140371 Connect shopname@localhost on using Socket
    140371 Query SET NAMES utf8mb4
    140371 Query SET NAMES ‘utf8mb4’ COLLATE ‘utf8mb4_unicode_ci’
    140371 Query SELECT @@SESSION.sql_mode
    140371 Query SET SESSION sql_mode=’ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’
    140371 Init DB shopname
    140371 Query SELECT * FROM wp_posts WHERE ID = 7 LIMIT 1
    140371 Query SELECT post_status, COUNT( * ) AS num_posts FROM wp_posts WHERE post_type = ‘product’ GROUP BY post_status
    140371 Query SELECT autoload FROM wp_options WHERE option_name = ‘woocommerce_admin_notice_redirect_download_method’
    140371 Query SELECT autoload FROM wp_options WHERE option_name = ‘woocommerce_admin_notice_redirect_download_method’
    140371 Query SELECT note_id FROM wp_wc_admin_notes WHERE type = ‘survey’ ORDER BY note_id ASC
    140371 Query SELECT * FROM wp_wc_admin_notes WHERE note_id = 14 LIMIT 1
    140371 Query SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name FROM wp_wc_admin_note_actions WHERE note_id = 14
    140371 Query SELECT * FROM wp_wc_admin_notes WHERE note_id = 42 LIMIT 1
    140371 Query SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name FROM wp_wc_admin_note_actions WHERE note_id = 42
    140371 Query SELECT * FROM wp_wc_admin_notes WHERE note_id = 89 LIMIT 1
    140371 Query SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name FROM wp_wc_admin_note_actions WHERE note_id = 89
    140371 Query SELECT * FROM wp_wc_admin_notes WHERE note_id = 92 LIMIT 1
    140371 Query SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name FROM wp_wc_admin_note_actions WHERE note_id = 92
    140371 Query SELECT * FROM wp_wc_admin_notes WHERE note_id = 93 LIMIT 1
    140371 Query SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name FROM wp_wc_admin_note_actions WHERE note_id = 93
    140371 Query SELECT * FROM wp_wc_admin_notes WHERE note_id = 113 LIMIT 1
    140371 Query SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name FROM wp_wc_admin_note_actions WHERE note_id = 113
    140371 Query SELECT * FROM wp_wc_admin_notes WHERE note_id = 114 LIMIT 1
    140371 Query SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name FROM wp_wc_admin_note_actions WHERE note_id = 114
    140371 Query SELECT * FROM wp_wc_admin_notes WHERE note_id = 115 LIMIT 1
    140371 Query SELECT action_id, name, label, query, status, actioned_text, nonce_action, nonce_name FROM wp_wc_admin_note_actions WHERE note_id = 115
    140371 Query SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-connection’ ORDER BY note_id ASC
    140371 Query SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘surface_cart_checkout’ ORDER BY note_id ASC
    140371 Query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’woocommerce_cleanup_draft_orders’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1
    140371 Query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’woocommerce_cleanup_draft_orders’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1
    140371 Query SELECT a.*, g.slug AS group FROM wp_actionscheduler_actions a LEFT JOIN wp_actionscheduler_groups g ON a.group_id=g.group_id WHERE a.action_id=129186
    140371 Query SELECT COUNT(*) FROM wp_options WHERE option_name LIKE ‘wp\\_1\\_wc\\_regenerate\\_images\\_batch\\_%’
    140371 Quit

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

The topic ‘sql running hot’ is closed to new replies.