Hi! The mySQL process loaded the processor at 100% for a week. Server’s LA reached 1.9, the delay when opening the site reached 15 sec. But just one query was actually executed: DELETE wyi FROM wp_yoast_indexable wyi INNER JOIN wp_yoast_indexable wyi2 WHERE wyi2.object_id = wyi.object_id AND wyi2.object_type = wyi.object_type AND wyi2.id < wyi.id;
Restart plugin was no effect, after reactivate plugin query loaded my server again.
So I need to execute TRUNCATE TABLE
wp_yoast_indexable
in phpMyadmin.
Guys, 400000 records in table! For personal blog with ~200 pages it’s original way to speed up the site.
I have LA just 0.25 now and page loading speed less then 1 sec. That’s how you need to optimize the speed of the site.
-
This reply was modified 4 years, 10 months ago by valeriovych.
-
This reply was modified 4 years, 10 months ago by valeriovych.
-
This reply was modified 4 years, 10 months ago by valeriovych.