Wishlist DB Issues

Wishlist causes very long database queries, extremely high memory usage, and causes products export to fail. Deactivating wishlist resolves the product export issue.

SQL Logs below:

# Time: 2024-05-20T02:08:09.809219Z
# User@Host: uaxpldxtqfusp[uaxpldxtqfusp] @ localhost [127.0.0.1]  Id: 3146351
# Schema: dba77jplhwf636  Last_errno: 0  Killed: 0
# Query_time: 4.294070  Lock_time: 0.395767  Rows_sent: 1  Rows_examined: 1  Rows_affected: 0  Bytes_sent: 160
SET timestamp=1716170889;
SELECT option_value FROM wp_yefkxr_options WHERE option_name = 'action_scheduler_lock_async-request-runner';
# Time: 2024-05-20T02:08:09.809300Z
# User@Host: uaxpldxtqfusp[uaxpldxtqfusp] @ localhost [127.0.0.1]  Id: 3146346
# Schema: dba77jplhwf636  Last_errno: 0  Killed: 0
# Query_time: 4.295258  Lock_time: 0.396809  Rows_sent: 1  Rows_examined: 1  Rows_affected: 0  Bytes_sent: 160
SET timestamp=1716170889;
SELECT option_value FROM wp_yefkxr_options WHERE option_name = 'action_scheduler_lock_async-request-runner';
# Time: 2024-05-20T04:29:58.576377Z
# User@Host: uaxpldxtqfusp[uaxpldxtqfusp] @ localhost [127.0.0.1]  Id: 3153678
# Schema: dba77jplhwf636  Last_errno: 0  Killed: 0
# Query_time: 21.221612  Lock_time: 0.000168  Rows_sent: 30  Rows_examined: 15640886  Rows_affected: 0  Bytes_sent: 9477
SET timestamp=1716179398;
SELECT SQL_CALC_FOUND_ROWS  wp_yefkxr_posts.*, COUNT(um.meta_value) + IFNULL(pm.meta_value, 0) AS wl_total
			 FROM wp_yefkxr_posts  LEFT JOIN wp_yefkxr_postmeta as pm ON pm.post_id = wp_yefkxr_posts.ID AND pm.meta_key = '_alg_wc_wl_added_by_unregistered_users_count' LEFT JOIN wp_yefkxr_usermeta as um ON um.meta_key = '_alg_wc_wl_item' AND um.meta_value = wp_yefkxr_posts.ID
--
			 ORDER BY wp_yefkxr_posts.post_date DESC
			 LIMIT 0, 30;
# Time: 2024-05-20T04:30:12.434214Z
# User@Host: uaxpldxtqfusp[uaxpldxtqfusp] @ localhost [127.0.0.1]  Id: 3153729
# Schema: dba77jplhwf636  Last_errno: 0  Killed: 0
# Query_time: 2.891121  Lock_time: 0.000491  Rows_sent: 30  Rows_examined: 2062622  Rows_affected: 0  Bytes_sent: 66921
SET timestamp=1716179412;
SELECT SQL_CALC_FOUND_ROWS  wp_yefkxr_posts.*, COUNT(um.meta_value) + IFNULL(pm.meta_value, 0) AS wl_total
			 FROM wp_yefkxr_posts  LEFT JOIN wp_yefkxr_postmeta as pm ON pm.post_id = wp_yefkxr_posts.ID AND pm.meta_key = '_alg_wc_wl_added_by_unregistered_users_count' LEFT JOIN wp_yefkxr_usermeta as um ON um.meta_key = '_alg_wc_wl_item' AND um.meta_value = wp_yefkxr_posts.ID
[email protected]:~$ 
[email protected]:~$ date
Mon May 20 05:42:03 UTC 2024