Replies: 1
Recently, there are 2 queries suddenly ate up most of our Database CPU:
SELECT * FROM wp_rank_math_redirections_cache WHERE BINARY from_url = ? LIMI…
And
SELECT * FROM wp_rank_math_redirections_cache WHERE object_id = ? AND object_type = ? LIMIT ?, …
For example:
select * from wp_rank_math_redirections_cache where BINARY from_url = ‘apple-touch-icon-120×120-precomposed.png’ limit 0, 1
select * from wp_rank_math_redirections_cache where object_id = 13696 and object_type = ‘post’ limit 0, 1
I am planning to add index for the table. But I don’t know if update the plugin can solve it. I’m using version 1.0.42.3
And should we clear that cache table? There are a lot of junk from_url, like: echo wthcrq$ ... or $(nslookup .... Those look like from hackers