p202 errors, cleaning out DB

Spades

Spades

New member
Mar 19, 2007
660
5
0
Florida
Just got done getting rid of the first 1.5mil click records from the various click tables in my 202 install after getting the below error. Thought it might fix the issue but it seems like it didn't.

INSERT INTO 202_clicks_spy SET click_id='2017050', user_id = '1', aff_campaign_id = '133', ppc_account_id = '12', click_cpc = '0.11000', click_payout = '1.95', click_filtered = '1', click_alp = '0', click_time = '1247087933'

The table '202_clicks_spy' is full
Click to expand...
The 202_clicks_spy table only has ~ 144,000 records. Anyone else ever come across this?
 


Go ahead and empty out the table.

DELETE FROM 202_clicks_spy;

this will empty the spy table, which runs on memory. Tt looks like you have so many clicks it maxed out the memory table.

We need to increase the size of your memory table by editing the my.cnf file

set the

max_heap_table_size = 104857600

then restart mysql in order for this to be the new default, and to start running with the new settings.

now your memory table limit size is 100mb, instead of the standard I believe 16 or 8MB size.
 
  • Like
Reactions: cardine
Wes you rock. How many other companies provide tech support for their (free) products in other peoples forums?

People if you use Prosper you need to go donate. I pay monthly for prosper pro and I don't even use it (need to track more than the big 3). That was easiest way I could come up with to make a donation every month, automatically.

Cheshire
 
reply

Hey I appreciate that Cheshire! Thats really kind of you.

I'm not sure how many people go to other forums and respond to tech tickets. But in general, I really like the wickedfire community. I'm on the WF forum almost every day. Although the forum may seem crazy sometimes, there is alot of good people here. I think everyone has some of their roots tied to WF sometime during their internet marketing career.
 
WesMahler said:
Hey I appreciate that Cheshire! Thats really kind of you.

I'm not sure how many people go to other forums and respond to tech tickets. But in general, I really like the wickedfire community. I'm on the WF forum almost every day. Although the forum may seem crazy sometimes, there is alot of good people here. I think everyone has some of their roots tied to WF sometime during their internet marketing career.
Click to expand...

word up
 
You must log in or register to reply here.
Top Bottom