Oplossen Slow Queries Database
Opdracht ID: 28310
Budget: € 25 tot € 100
Geplaatst: 07-03-2017
Reacties: 4
Locatie: Kortenhoef, Noord-Holland
Laatst gewijzigd: 15-03-2017
Status: Gesloten
Beste freelancers,
Wie o wie kan mij helpen om onderstaand probleem voor mij oplossen.
Ik zie jullie reacties graag tegemoet.
=== TOP 10 of 21 (total) Slow Queries for the past 24 hours ==========
1. Executed 1h 54m 28s ago for 10.749763 sec on Database --> plankto9_wp703
Date: 2017-03-06 13:34:33 Query_time: 10.749763 Rows_examined: 1: Rows_sent 1 Lock_time: 0.000109
# Schema: plankto9_wp703 Last_errno: 0 Killed: 0 SELECT option_value FROM wpix_options WHERE option_name = 'wpseo_redirect';
-------------------------------------------------------------------------------------------------
2. Executed 38m 5s ago for 7.799736 sec on Database --> plankto9_wp227
Date: 2017-03-06 14:50:56 Query_time: 7.799736 Rows_examined: 552: Rows_sent 377 Lock_time: 0.051176
# Schema: plankto9_wp227 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wpsb_options WHERE autoload = 'yes';
----------------------------------------------------------------------------------------------------
3. Executed 1h 8m 51s ago for 4.5291 sec on Database --> plankto9_wp703
Date: 2017-03-06 14:20:10 Query_time: 4.529100 Rows_examined: 1740: Rows_sent 1625 Lock_time: 0.050098
# Schema: plankto9_wp703 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wpix_options WHERE autoload = 'yes';
------------------------------------------------------------------------------------------------------
4. Executed 23h 19m 35s ago for 4.310714 sec on Database --> plankto9_wp555
Date: 2017-03-05 16:09:26 Query_time: 4.310714 Rows_examined: 391: Rows_sent 322 Lock_time: 0.050990
# Schema: plankto9_wp555 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wpjc_options WHERE autoload = 'yes';
----------------------------------------------------------------------------------------------------
5. Executed 1h 43m 23s ago for 3.683271 sec on Database --> Unknown (NOT FOUND / DELETED)
Date: 2017-03-06 13:45:38 Query_time: 3.683271 Rows_examined: 1740: Rows_sent 1625 Lock_time: 0.050223
# Schema: plankto9_wp703 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wpix_options WHERE autoload = 'yes';
------------------------------------------------------------------------------------------------------
6. Executed 53m 42s ago for 2.968867 sec on Database --> plankto9_wp703
Date: 2017-03-06 14:35:19 Query_time: 2.968867 Rows_examined: 1740: Rows_sent 1625 Lock_time: 0.050259
# Schema: plankto9_wp703 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wpix_options WHERE autoload = 'yes';
------------------------------------------------------------------------------------------------------
7. Executed 1h 16m 41s ago for 2.041666 sec on Database --> plankto9_wp703
Date: 2017-03-06 14:12:20 Query_time: 2.041666 Rows_examined: 1740: Rows_sent 1625 Lock_time: 0.050944
# Schema: plankto9_wp703 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wpix_options WHERE autoload = 'yes';
------------------------------------------------------------------------------------------------------
8. Executed 1h 16m 41s ago for 1.962554 sec on Database --> plankto9_wp703
Date: 2017-03-06 14:12:20 Query_time: 1.962554 Rows_examined: 1740: Rows_sent 1625 Lock_time: 0.050135
# Schema: plankto9_wp703 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wpix_options WHERE autoload = 'yes';
------------------------------------------------------------------------------------------------------
9. Executed 1h 16m 44s ago for 1.686104 sec on Database --> plankto9_wp703
Date: 2017-03-06 14:12:17 Query_time: 1.686104 Rows_examined: 1740: Rows_sent 1625 Lock_time: 0.000158
# Schema: plankto9_wp703 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wpix_options WHERE autoload = 'yes';
------------------------------------------------------------------------------------------------------
10. Executed 1h 16m 44s ago for 1.678041 sec on Database --> Unknown (NOT FOUND / DELETED)
Date: 2017-03-06 14:12:17 Query_time: 1.678041 Rows_examined: 1740: Rows_sent 1625 Lock_time: 0.000214
# Schema: plankto9_wp703 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wpix_options WHERE autoload = 'yes';
----------------------------------------------------------------------------------------------