Is it safe to run the following query to clean up my wp_commentmeta table of my database?
DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments)
Would it cause any problem or is it safe to run this query?
My Akismet plugin continues to add statistical data to this table and so my database has grown large and my web host is throttling my account multiple hours a day, being on a pro account.
So, I thought of firstly cleaning the database, and I found the above query. Please, let me know, if it is safe to run the above query on my database?