Testing Prosper202 latency?

[AffApprentice]

Hey guys,

I've added a lot of clicks to my Prosper202 instance over the last couple months, and I'm starting to worry that I may have added some redirect latency that's costing me conversions. I remember reading a long time ago about ways to optimize P202 and/or clean up DBs, but after spending some time navigating through P202's new support section, I'm not coming up with anything good.

Can anyone point me to a) a good way to test the latency on my P202 links, and/or b) information about how to clean up P202 DBs / tables to optimize performance?

Much appreciated, thanks.

 

[Hurr-Durr]

I'd like to know that as well - about what tables are safe to clear and what tables should be preserved.

 

[MistorToker]

if you run on POF affapprentice (im pretty sure you do) ive seen an absolutely retarded drop in LP CTR which i believed was due to the same issue. guess not

 

[heavyt]

really? really? ok here we go

to speed some things up ssh into your box and run these three commands in this order, should be done once a day anyway on a prosper box

mysqlcheck -r --all-databases
mysqlcheck -f --all-databases
mysqlcheck -o --all-databases

If that doesn't speed things up somewhat try editing your my.cnf and httpd.conf file

And if you want to speed it up even more and don't care about knowing the domains peopel came from empty in phpmyadmin
202_site_urls
202_site_domains

But if you want to dump stuff and start all over but keep links/offers/lp's/etc empty

202_site_domains
202_clicks
202_clicks_advance
202_clicks_counter
202_clicks_record
202_clicks_site
202_ips
202_site_urls

 

[Butta]

Clearing the referer tables will also help.

 

[AffApprentice]

Thanks, guys. I have to believe Wes or someone else from Prosper202 has posted some documentation to help with this? I'm nervous about just running commands and clearing tables, as I still have traffic going through P202. I want to make sure I do this right so I don't mess everything up

 

[Hurr-Durr]

Thanks Heavyt!

 

[heavyt]

no documentation bro just know wes and was looking to do what you want to do a long time ago.

 

[ImagesAndWords]

Good info, heavyt +rep

Regarding redirect latency / lowered actual CTR due to clogged DBs....is there any proof to support this?

 

[bbrock32]

+rep heavyt , I will test these on my p202 setup

 

[heavyt]

And for those that doubt me I accidentally ran for an hour with google and yahoo on my prosper setup on trafficvance, blew through 1k like a fat chick eating choclate exlax and it handleded it fine but that was also due to my config and httpd and my.cnf

 

[bbrock32]

Hey , can you post what changes did you do to httpd.conf and my.cnf to increase performance?

 

[DomboCom]

Hey , can you post what changes did you do to httpd.conf and my.cnf to increase performance?

+rep heavyt

Would like to see what you did to these files as well. Mind sharing?

 

[imkazu]

thanks for the optimization tips heavyt