Mariadb/mysql hangs when you search for user to add to journal

[marc]

Are those 10.000 users real? Sounds like… a lot for a regular journal.

If your OJS was attacked in past by spammers you will like to read this post and apply some of the patterns to clean your user list:

Collaborative list of spam user patterns

Whether you’ve inherited a new magazine or it’s time to put your house in order, in the forum you can find several good threads on how to deal with spam users but I miss an unified and updated list of spam patterns like the one @jmacgreg started in How do I combat spam?, so, here you have a forum-wiki-page here with an initial compilation that could be collectively extended/enriched. I tried to make it compact and with same structure to facilitate the reading and are numbered for an easy refere…

Cheers,
m.