Problems with Tracking202

B

Ben89

New member
Mar 30, 2007
670
4
0
Hey guys,

I don't know what the deal is with tracking202, either it takes a very long time to load my data after multiple requests or I get some sort of error message. This error message here appears to be the most frequent one.

Code: 
SELECT  COUNT(*)  FROM 202_cronjobs WHERE cronjob_type='secon' AND cronjob_time='1295431621'

MySQL server has gone away

By the way, I'm on a level 7 Hostgator VPS.

Any ideas what the issue may be here? Thanks.
 


Your deff hitting your timeout on the MySQL server.

Do you have any other apps using that MySQL server, and if so are they working?
 
1.reboot mysql
2.reboot vps container
3.ring up and ask for a hard reset.

"Good afternoon technical support, have you tried turning it off then on again?"

Just kidding. It sounds like a mysql problem though. You sure there aren't any other sites on that vps using mysql?? Wordpress uses mysql, do you have any blogs or other apps on it?

My first guess would be you are missing a mysql_close($x); somewhere.

First place to look would be custom add_ons etc. Also there will be an error log somewhere. My VPS with webfusion sends me an email bitching about too many open conections.
 
I mean, aside from loading slowly, mostly all the features of prosper202 load aside fromwhen I want to analyze the keywords...thats when I get the sql error.
 
you need to modify your my.cnf file, or get off of fucking hostgator and go to liquidweb and get a better system. fuck vps and go to cloud, why buy a Ferrari and cheap out on tires?
 
heavyt said:
you need to modify your my.cnf file, or get off of fucking hostgator and go to liquidweb and get a better system. fuck vps and go to cloud, why buy a Ferrari and cheap out on tires?
Click to expand...

what would I need to do to that file?
 
for my friends I do it for free, for you it would be how much it is worth to you and how much money did you lose today cause it wasn't right?
 
I paused the campaign because I'm trying to optimize it and there is no point in running it if I can't pull the keyword data to see what keywords are/aren't converting.
 
restarting mysql server usually fixes things for the short term. But you need to address the bigger problem of GETTING A BETTER SERVER!!!!!!!!!!
 
If you still need help, hit me on AIM in the morning "tnowcoder". More than likely, you have too many stored clicks in your db, combined with a couple of upgrades from previous versions that didnt add partitioning to some of the 202_clicks tables. This causes weird things to happen with the cronjobs and other tables.

Yes, happy to help for free.

One of the other guys I helped, might chime in and vouch for me.

Good Luck.
 
Ben89 said:
what would I need to do to that file?
Click to expand...

Well some queries are taking ages so log these. Add this to your my.cnf if you can even, I've no idea on Hostgator but they sound crap and they wouldn't allow this. But if you can:

log_slow_queries=/var/log/mysqld.slow.log
long_query_time=2

Then check /var/log/mysqld.slow.log and take it from there. This doesn't fix the problem, just helps you better diagnose it.
 
You must log in or register to reply here.
Top Bottom