Slows down my site
-
My site suddenly got too slowed and my host checked what happened and heres what they found.
Query
Execution Time (in sec)
DELETE lm FROM wp_gamipress_logs_meta lm LEFT JOIN wp_gamipress_logs l ON l.log_id = lm.log_id WHERE l.log_id IS NULL;
323
SELECT DISTINCT meta_key FROM wp_postmeta WHERE meta_key NOT BETWEEN ‘_’ AND ‘_z’ HAVING meta_key NOT LIKE ‘\\_%’ ORDER BY meta_key LIMIT 30;
14
SELECT option_value FROM wp_options WHERE option_name = ‘woocommerce_updated_instance_ids’ LIMIT 1;
13
SELECT type, COUNT( * ) AS num_entries FROM wp_gamipress_logs GROUP BY type;
13
SELECT t.type FROM wp_automatorwp_triggers AS t GROUP BY t.type;
9
SELECT l.* FROM wp_gamipress_logs AS l LEFT JOIN wp_gamipress_logs_meta AS lm0 ON ( l.log_id = lm0.log_id AND lm0.meta_key = ‘_gamipress_post_id’ ) WHERE ( l.user_id = ‘18909’ ) AND ( l.type = ‘time_based_reward’ ) AND ( lm0.meta_value = ‘1613’ ) ORDER BY l.date DESC LIMIT 1;
9
SELECT post_type, COUNT( * ) AS num_entries FROM wp_gamipress_user_earnings GROUP BY post_type;
8
SET SESSION sql_mode=’NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’;
7
SELECT l.* FROM wp_gamipress_logs AS l LEFT JOIN wp_gamipress_logs_meta AS lm0 ON ( l.log_id = lm0.log_id AND lm0.meta_key = ‘_gamipress_post_id’ ) WHERE ( l.user_id = ‘18914’ ) AND ( l.type = ‘time_based_reward’ ) AND ( lm0.meta_value = ‘1613’ ) ORDER BY l.date DESC LIMIT 1;
7
SELECT option_value FROM wp_options WHERE option_name = ‘woocommerce_force_ssl_checkout’ LIMIT 1;
7`They told me that you need to optimize this.
- The topic ‘Slows down my site’ is closed to new replies.
