Hi, we have around 150K registered user into our blog thats why database is over 1GB so i want to clean up my inactive user with user meta to optimize the database… any help please? any plugins or SQL solution?
There is no out of box solution. Frist my advice is to protect site from making fake accounts and spam comments.
When you protect site you can clean fake accounts by different combinations .
If you don’t know how you can hire me.
As Zaccc suggested, you may use some spam protection features as well but you may just need database optimization as well. You may not even need to clean the users. If you’re interested in, I can offer you a paid support.
you can set it to delete users who haven’t logged in for X amount of time e.g. 3 months
i know this plugins but problem is you just cant install the plugins and remove the inactive user… you have to wait for few months to take the analytics… thats why cant use it.
All of our user are 100% verified from last 3 years… so we have protection for spam user…
All of our user are 100% verified from last 3 years… so we have protection for spam user.
Than you can delete all users older from 3 years.