WC_order_stats table index size keeps growing to GBs

Hi,

I am having some issue in 1 of my site. The indexes of WC_order_stats table keeps growing in GBs.

If I am optimising the database then it behave normally. After some time the table index size is growing in 1-2GB.

I am getting the solutions to fix this issue. But I am not getting the exact solution of this issue. Can you please guide me in this.

I already created a ticket for this. This is the link of the created ticket : https://www.ads-software.com/support/topic/wc_order_stats-table-index-size-keeps-growing-to-gbs/

I shared the report that you guys asked me to share with you but I didn’t hear anything back from you.

I have to optimise it daily as it goes to 33gb and slows the site down.

Please help me with this.

Looking forward a fast response.

Thanks & Regards,
Aman

The page I need help with: [log in to see the link]