sql running hot
-
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 <code>group</code> 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 QuitThe page I need help with: [log in to see the link]
-
I found the problem using the F12 in chrome. It was a script refreshing the cart that was made by our partner who made the theme.
Thank you for your intrest in the problem.
It was hard to bug hunt cos the script was running on the clients machines even after i turned of the theme.
The topic ‘sql running hot’ is closed to new replies.
