Quite some time ago I wrote a post called How To Fix Prosper202 If Spy/Analyze Stops Working. If you run a lot of traffic to your Prosper202 setup you probably find yourself having to dump the databases often.
Yesterday, the one and only Wes Mahler left a comment on that post stating:
Updated so you don’t have to manually do it each time, we just change the MYSQL TABLE type so it’s no longer a memory table, which removes having any limit at all.
the issue with the above post is it dose clears it, but it’ll fill up again if you have lots of traffic. this fix changes the table type so it won’t have a memory limit any more and will never happen again
The fix can be found at the Prosper202 forums but I’ll copy it here just to make your life easier:
To fix this problem, run this command in your phpmyadmin
ALTER TABLE `202_clicks_spy` ENGINE = MYISAM
ALTER TABLE `202_last_ips` ENGINE = MYISAM
The discussion thread can be found here. Hopefully this saves you from having to dump your databases on a regular basis.