BuddyPress.org

It sounds to me like a bot is hitting your registration hard, and keeps attempting to refresh a page or is getting stuck on the creation reload or activation email, and is overloading the server with requests.

It’s kinda one of those situations now, where all those plugins start to muck up our ability to figure out if this is BP’s fault or not. Usually the recommended plan of attack is to disable all plugins now, try to create a test user yourself, and see what happens.

Even if you upgrade to the most recent trunk, and a bot or an unruly plugin are to blame, rather than creating tons of new tables, you’re still getting the overload of requests which is causing all sorts of havoc.