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.
Sweet deal! I love it. This fix will make my life a bit easier… now if only I could figure out how to track across multiple pages correctly.
Awesome. Thanks for the heads up!
How much traffic do you have to run through P202 for this to be an issue?
Thanks for the heads up! I’ve had a few pubs with this issue. I’ll let them know 🙂
@ken you have to run a pretty sizeable amount of traffic to 202. if you’re running 5-20k clicks a day you probably want to do this and think about running it on a dedicated server with memcached.
Hi Wes, Could you guys put out a new Prosper 1.33 version
with the new table types plus some other goodies,
so we don’t have to make the change on every install ?