STM Tracker Slow (25)
My Tracker is mega slow these days when logging in. Does this affect redirect speeds too?
Apart from optimising tables, what other safe and non-techie optimisations can I do to speed up my tracker?
Cheers
What sort of server do you have?
Specs?
Ram, CPU, HD's
VPS 1024MB, 50GB RAID-10 Disk Space. Not really techie, so not sure if that's sufficient info. I'm not running that much volume through it.
How many clicks so far?
Around 100,000. So not much. Only around 2k a day.
Hmm, that shouldn't be enough to start slowing your tracker down. The first safe, non-techie optimisation I'd suggest would be asking your hosts what's slowing everything down 
What hosting company are you with?
Redirect speeds: it could do, depends what the problem is. I'd recommend running a speed test on your tracker: you can just take one of your tracking links and run it through Pingdom to get an approximate idea of how fast your tracker's redirecting.
Check the redirect speeds with one of the tools online and post the results here.
Stats loading generally depends on the DB size while redirect speeds shouldn't be affected much.
Honestly I think with those server specs can't expect too much.
At worst make a backup of the db and clean it. That will help for sure.
I'm with Knownhost. Redirect takes 751 ms. Total load time is 986 ms. I had nginx installed a while ago and that seemed to help the problem.
Server support tells me there aren't any issues. It's weird, some days it's retardedly slow when analyzing stats, other days it's not too bad.
Worth upgrading my VPS?
Is there a way to keep a month of stats and delete anything over that?
Unfortunately not.
The way I usually do it is just install a new prosper and dump the old database there.
This way I can clean the "normal" prosper and use the 2nd install to check past stats.
Could just be the vps node you are on.. ask your host.. I have a good spec vps that was running slow now and again.. when host looked into it someone else on the same server was eating up all the resources. They suspended them and all was fine again..
You could hire someone to set up a function to delete or archive all stats over a month old. You'd need to run it on a cron job - shouldn't be super-complicated, but it's not something that you can do without a bit of coding.
But I'd definitely investigate another hosting provider or another node first. Even given your reasonably low specs, Prosper shouldn't be slowing down much with only 100k rows of data.
I've not heard of Knownhost, but a quick search on Web Hosting Talk shows that you're not the only person complaining of slow performance.
I sent them another email and they said that the server is running fine and that it could be my local connection that's causing the slow down. Weird because all other sites are loading fine.
@kai - you've checked the loading time with Pingdom, right?
"Oh, it's probably your local connection" is a pretty classic hosting provider excuse - don't let 'em get away with it, point out you've checked the load time with external testers.
Originally Posted by kai1
My suggestion is to find a new host, how much are they charging you a month?
As I said , try having a separate prosper install just for checking past stats.
If I remove campaigns from the dashboard does this automatically clear the data for that particular campaign?
I think I will probably go dedi soon rather than try another vps or hosting solution.
Nope, you'll have to actually remove the data from the database.
You can do that using PHP-MyAdmin, or through the command line via SSH, or you can get someone to write a script for you - extending 202-cronjobs/index.php would probably be the easiest way to do it.
Can anyone give us a walkthrough on how to safely backup and delete a database in STMs Tracker? I'm sure it will benefit a lot of tech retards like me.
Much appreciated!
It's super easy , just login via ssh and run this command :
mysqldump -u username -p --databases yourdbname > backup.sql
Replace username and yourdbname with the user that has access to the database and the name of the database.
Also you will be promted to enter a password. That's it.
To clean data from your prosper install just go to administration and click on "Delete All Click Data ".
via ssh? How about via php-myadmin?
Originally Posted by kai1
I seem to recall later versions of PHP-MyAdmin have put some features in to help with that. I'll add it to the Tutorials Needed list
If you're going to be doing this frequently, though, I'd definitely recommend just getting a coder to put it on a cron job instead - that way your stats get silently backed up to your server and you can just download them whenever.
Actually, you know what, that might be a good one for a tutorial too. Anyone want a tutorial on setting up automatic stats backup and cleaning from Prosper?
I do! 
Yes caurmen
I'm tired of manually mysqldump and looking for some automation that will save us time
OK, I'm on it.
Home > Technical & Creative Skills > Tracking Campaigns