Website wegen langsamer Abfragen abstürzen

Meine Website geht weiter und der Host sagt, dass einige langsame Abfragen den Server überlasten. Sie haben eine Liste von langsamen Abfragen geliefert, irgendwelche Hinweise darauf, was ich tun sollte, um sie loszuwerden oder zu optimieren?

Slow queries were found: Executed 583 min ago for 3 sec on Database --> . DELETE FROM `wp_options` WHERE `option_name` = 'rewrite_rules Executed 548 min ago for 1 sec on Database --> . SELECT meta_key FROM wp_postmeta GROUP BY meta_key HAVING meta_key NOT LIKE '\\_%' ORDER BY meta_key LIMIT 30 Executed 545 min ago for 1 sec on Database --> . SELECT DISTINCT meta_key FROM wp_postmeta ORDER BY meta_key LIMIT 1000 Executed 539 min ago for 1 sec on Database --> . SELECT DISTINCT meta_key FROM wp_postmeta ORDER BY meta_key LIMIT 1000 Executed 539 min ago for 1 sec on Database --> . SELECT meta_key FROM wp_postmeta GROUP BY meta_key HAVING meta_key NOT LIKE '\\_%' ORDER BY meta_key LIMIT 30 Executed 490 min ago for 2 sec on Database --> . SELECT DISTINCT meta_key FROM wp_postmeta ORDER BY meta_key LIMIT 1000 Executed 484 min ago for 1 sec on Database --> . SELECT DISTINCT meta_key FROM wp_postmeta ORDER BY meta_key LIMIT 1000 Executed 484 min ago for 1 sec on Database --> . SELECT meta_key FROM wp_postmeta GROUP BY meta_key HAVING meta_key NOT LIKE '\\_%' ORDER BY meta_key LIMIT 30 Executed 434 min ago for 4 sec on Database --> wp_wpdb_st1. SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 0 AND wp_posts.post_type = 'edd_payment' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'refunded' OR wp_posts.post_status = 'failed' OR wp_posts.post_status = 'revoked' OR wp_posts.post_status = 'abandoned')) ORDER BY wp_posts.ID DESC LIMIT 0, 30 Executed 77 min ago for 1 sec on Database --> wp_wpdb. SELECT post_id, SLEEP(RAND()*0.20) AS junk FROM wp_postmeta WHERE meta_key = '_edd_sl_key' AND meta_value = '1ad95d156f086772053a8acebd0270aa' LIMIT 1 Executed 77 min ago for 10 sec on Database --> wp_wpdb. SELECT post_id, SLEEP(RAND()*0.20) AS junk FROM wp_postmeta WHERE meta_key = '_edd_sl_key' AND meta_value = 'f3fe4e10fb2625f1faea3cc0b373dc66' LIMIT 1 Executed 77 min ago for 2 sec on Database --> wp_wpdb. SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('section') AND tr.object_id IN (12060, 24940, 27706, 35346, 40867, 40977, 124168) ORDER BY t.name ASC Executed 77 min ago for 4 sec on Database --> wp_wpdb. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 77 min ago for 14 sec on Database --> wp_wpdb. SELECT post_modified_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page', 'attachment', 'download', 'thirstylink', 'question', 'testimonials', 'wp_feed', 'wp_feed_item', 'wysijap', 'docs', 'websites') ORDER BY post_modified_gmt DESC LIMIT 1 Executed 77 min ago for 10 sec on Database --> wp_wpdb. SELECT post_id, SLEEP(RAND()*0.20) AS junk FROM wp_postmeta WHERE meta_key = '_edd_sl_key' AND meta_value = '635c45fbc3de79dc952337873852a409' LIMIT 1 Executed 77 min ago for 25 sec on Database --> wp_wpdb. SELECT post_id, SLEEP(RAND()*0.20) AS junk FROM wp_postmeta WHERE meta_key = '_edd_sl_key' AND meta_value = '8b9759fe31d19e37c1f589c52c0bd5c8' LIMIT 1 Executed 77 min ago for 18 sec on Database --> wp_wpdb. SELECT post_date_gmt FROM wp_posts WHERE post_status = 'publish' AND post_type IN ('post', 'page', 'attachment', 'download', 'thirstylink', 'question', 'testimonials', 'wp_feed', 'wp_feed_item', 'wysijap', 'docs', 'websites') ORDER BY post_date_gmt DESC LIMIT 1 Executed 76 min ago for 3 sec on Database --> wp_wpdb. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 76 min ago for 1 sec on Database --> wp_wpdb_st1. SHOW FULL COLUMNS FROM `wp_options Executed 76 min ago for 6 sec on Database --> wp_wpdb. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 76 min ago for 4 sec on Database --> wp_wpdb. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 76 min ago for 3 sec on Database --> wp_wpdb. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 76 min ago for 1 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 76 min ago for 1 sec on Database --> utf8. SELECT @@SESSION.sql_mode Executed 76 min ago for 6 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 76 min ago for 2 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 76 min ago for 1 sec on Database --> utf8. SELECT @@SESSION.sql_mode Executed 76 min ago for 6 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 76 min ago for 1 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 76 min ago for 2 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 76 min ago for 2 sec on Database --> utf8. SELECT CURRENT_TIMESTAMP Executed 76 min ago for 1 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 75 min ago for 4 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 75 min ago for 6 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 75 min ago for 4 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 75 min ago for 10 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 74 min ago for 1 sec on Database --> utf8. SELECT @@SESSION.sql_mode Executed 74 min ago for 7 sec on Database --> utf8. SELECT post_id, SLEEP(RAND()*0.20) AS junk FROM wp_postmeta WHERE meta_key = '_edd_sl_key' AND meta_value = '5fcc7aa22234df6b24f5e855afe90498' LIMIT 1 Executed 74 min ago for 1 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 74 min ago for 5 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 74 min ago for 1 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 73 min ago for 4 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 73 min ago for 2 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 73 min ago for 4 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 73 min ago for 1 sec on Database --> utf8. SELECT @@SESSION.sql_mode Executed 73 min ago for 1 sec on Database --> utf8. Init DB none - System Command Executed 73 min ago for 1 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes Executed 73 min ago for 1 sec on Database --> utf8. SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes 

Solutions Collecting From Web of "Website wegen langsamer Abfragen abstürzen"

Vielleicht helfen Infos auf dieser Seite: http://codex.wordpress.org/Class_Reference/wpdb

Ansonsten würde ich die übliche Fehlersuche starten.

Alles sichern.

Schalte alle Plugins aus.

Wechseln Sie zu einem WordPress-Standardthema wie 2015.

Dann sehen Sie, welche Fehler Sie jetzt bekommen, dass Sie Ihre Installation reduziert haben.

Dann schalte die Dinge langsam wieder ein, bis du alles, was lästig ist, isoliert und loswirst.

Wenn Sie davon überzeugt sind, dass Ihr Code vernünftig ist, schauen Sie sich einen VPS, einen dedizierten Server oder einen Premium-WordPress-Host an, da es sich um ein Speicher- oder Ressourcenproblem handeln könnte.

Sie können auch überprüfen, dass Ihre Website nicht angegriffen wird oder dass bösartiger Code Unheil anrichtet.