CPU WooCommerce Updates
Budget: €30 – €250 EUR
My Website is slow, I got follow feedback from the hosting Server:
I have carefully reviewed the case and it appears that there are lots of slow database queries which are slowing down your website and also increase the CPU usage.
= TOP 10 of 597 (total) Slow Queries for the past 24 hours =
1. Executed 5h 11m 3s ago for 26.685767 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 08:10:26 Query_time: 26.685767 Rows_examined: 9: Rows_sent 0 Lock_time: 0.000141 Query_chars: 590
UPDATE `wab_postmeta` SET `meta_value` = 'a:5:{s:5:\"width\";i:1708;s:6:\"height\";i:2560;s:4:\"file\";s:31:\"2020/10/dearmini_301-scaled.jpg\";s:5:\"sizes\";a:0:{}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"0\";s:6:\"credit\";s:0:\"\";s:6:\"cam
..
ht\";s:0:\"\";s:12:\"focal_length\";s:1:\"0\";s:3:\"iso\";s:1:\"0\";s:13:\"shutter_speed\";s:1:\"0\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"0\";s:8:\"keywords\";a:0:{}}}' WHERE `post_id` = 41072 AND `meta_key` = '_wp_attachment_metadata';
-
2. Executed 7h 56m 38s ago for 23.993902 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 05:24:51 Query_time: 23.993902 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000121 Query_chars: 284
INSERT INTO `wab_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1651209867.2730989456176757812500', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
----
3. Executed 5h 11m 3s ago for 23.589287 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 08:10:26 Query_time: 23.589287 Rows_examined: 1695: Rows_sent 1695 Lock_time: 0.050366 Query_chars: 74
SELECT option_name, option_value FROM wab_options WHERE autoload = 'yes';
----------
4. Executed 10h 55m 31s ago for 20.201622 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 02:25:58 Query_time: 20.201622 Rows_examined: 1695: Rows_sent 1695 Lock_time: 0.050287 Query_chars: 74
SELECT option_name, option_value FROM wab_options WHERE autoload = 'yes';
----------
5. Executed 5h 11m 3s ago for 19.967824 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 08:10:26 Query_time: 19.967824 Rows_examined: 1695: Rows_sent 1695 Lock_time: 0.050359 Query_chars: 74
SELECT option_name, option_value FROM wab_options WHERE autoload = 'yes';
----------------
6. Executed 10h 55m 31s ago for 15.544219 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 02:25:58 Query_time: 15.544219 Rows_examined: 1695: Rows_sent 1695 Lock_time: 0.050186 Query_chars: 74
SELECT option_name, option_value FROM wab_options WHERE autoload = 'yes';
--------------------
7. Executed 22h 36m 47s ago for 12.432337 sec on Database --> dba8weayqc38ng
Date: 2022-04-28 14:44:42 Query_time: 12.432337 Rows_examined: 1697: Rows_sent 1697 Lock_time: 0.002552 Query_chars: 74
SELECT option_name, option_value FROM wab_options WHERE autoload = 'yes';
---------------
8. Executed 18h 4m 37s ago for 11.089768 sec on Database --> dba8weayqc38ng
Date: 2022-04-28 19:16:52 Query_time: 11.089768 Rows_examined: 95: Rows_sent 0 Lock_time: 0.050160 Query_chars: 104
SELECT file_path FROM wab_icl_mo_files_domains WHERE domain = 'wordfence' and file_path LIKE '%de_DE%';
---------------
9. Executed 22h 36m 48s ago for 10.634241 sec on Database --> dba8weayqc38ng
Date: 2022-04-28 14:44:41 Query_time: 10.634241 Rows_examined: 1: Rows_sent 1 Lock_time: 0.050229 Query_chars: 86
SELECT option_value FROM wab_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
---------
10. Executed 10h 55m 31s ago for 10.535799 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 02:25:58 Query_time: 10.535799 Rows_examined: 1695: Rows_sent 1695 Lock_time: 0.050348 Query_chars: 74
SELECT option_name, option_value FROM wab_options WHERE autoload = 'yes';
For your convenience, I will provide you with a great tutorial for the task.
https://wpmudev.com/blog/optimizing-your-wordpress-database-a-complete-guide/
I have carefully reviewed the case and it appears that there are lots of slow database queries which are slowing down your website and also increase the CPU usage.
= TOP 10 of 597 (total) Slow Queries for the past 24 hours =
1. Executed 5h 11m 3s ago for 26.685767 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 08:10:26 Query_time: 26.685767 Rows_examined: 9: Rows_sent 0 Lock_time: 0.000141 Query_chars: 590
UPDATE `wab_postmeta` SET `meta_value` = 'a:5:{s:5:\"width\";i:1708;s:6:\"height\";i:2560;s:4:\"file\";s:31:\"2020/10/dearmini_301-scaled.jpg\";s:5:\"sizes\";a:0:{}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"0\";s:6:\"credit\";s:0:\"\";s:6:\"cam
..
ht\";s:0:\"\";s:12:\"focal_length\";s:1:\"0\";s:3:\"iso\";s:1:\"0\";s:13:\"shutter_speed\";s:1:\"0\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"0\";s:8:\"keywords\";a:0:{}}}' WHERE `post_id` = 41072 AND `meta_key` = '_wp_attachment_metadata';
-
2. Executed 7h 56m 38s ago for 23.993902 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 05:24:51 Query_time: 23.993902 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000121 Query_chars: 284
INSERT INTO `wab_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1651209867.2730989456176757812500', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
----
3. Executed 5h 11m 3s ago for 23.589287 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 08:10:26 Query_time: 23.589287 Rows_examined: 1695: Rows_sent 1695 Lock_time: 0.050366 Query_chars: 74
SELECT option_name, option_value FROM wab_options WHERE autoload = 'yes';
----------
4. Executed 10h 55m 31s ago for 20.201622 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 02:25:58 Query_time: 20.201622 Rows_examined: 1695: Rows_sent 1695 Lock_time: 0.050287 Query_chars: 74
SELECT option_name, option_value FROM wab_options WHERE autoload = 'yes';
----------
5. Executed 5h 11m 3s ago for 19.967824 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 08:10:26 Query_time: 19.967824 Rows_examined: 1695: Rows_sent 1695 Lock_time: 0.050359 Query_chars: 74
SELECT option_name, option_value FROM wab_options WHERE autoload = 'yes';
----------------
6. Executed 10h 55m 31s ago for 15.544219 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 02:25:58 Query_time: 15.544219 Rows_examined: 1695: Rows_sent 1695 Lock_time: 0.050186 Query_chars: 74
SELECT option_name, option_value FROM wab_options WHERE autoload = 'yes';
--------------------
7. Executed 22h 36m 47s ago for 12.432337 sec on Database --> dba8weayqc38ng
Date: 2022-04-28 14:44:42 Query_time: 12.432337 Rows_examined: 1697: Rows_sent 1697 Lock_time: 0.002552 Query_chars: 74
SELECT option_name, option_value FROM wab_options WHERE autoload = 'yes';
---------------
8. Executed 18h 4m 37s ago for 11.089768 sec on Database --> dba8weayqc38ng
Date: 2022-04-28 19:16:52 Query_time: 11.089768 Rows_examined: 95: Rows_sent 0 Lock_time: 0.050160 Query_chars: 104
SELECT file_path FROM wab_icl_mo_files_domains WHERE domain = 'wordfence' and file_path LIKE '%de_DE%';
---------------
9. Executed 22h 36m 48s ago for 10.634241 sec on Database --> dba8weayqc38ng
Date: 2022-04-28 14:44:41 Query_time: 10.634241 Rows_examined: 1: Rows_sent 1 Lock_time: 0.050229 Query_chars: 86
SELECT option_value FROM wab_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
---------
10. Executed 10h 55m 31s ago for 10.535799 sec on Database --> dba8weayqc38ng
Date: 2022-04-29 02:25:58 Query_time: 10.535799 Rows_examined: 1695: Rows_sent 1695 Lock_time: 0.050348 Query_chars: 74
SELECT option_name, option_value FROM wab_options WHERE autoload = 'yes';
For your convenience, I will provide you with a great tutorial for the task.
https://wpmudev.com/blog/optimizing-your-wordpress-database-a-complete-guide/