sql running hot | WordPress.org

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]

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Your Advertisement Here