Home > Technical & Creative Skills > Tracking Campaigns

Mysql out of resources error (7)

12-23-2013 03:53 PM #1 sarsap (Member)
Mysql out of resources error

I'm using STM tracker and whenever I get a burst of clicks sometimes I check the link for myself and get the following error:

Warning: mysql_query(): Unable to save result set in /home/username/public_html/trackingdomain.com/public/tracking202/redirect/tracker.php on line 317
SELECT COUNT(*) FROM 202_summary_overview WHERE user_id='1' AND aff_campaign_id='35' AND ppc_account_id='27' AND click_time='1387792800'

Out of resources when opening file './STMTracker/202_summary_overview#P#p66.MYD' (Errcode: 24)

Anyone solved something like this before?

12-23-2013 09:30 PM #2 kamaleon (Member)

Have you tried repairing the table with phpmyadmin for example?

Here are more details

http://textpattern.com/faq/36/warnin...ave-result-set

And here is the mysql info http://dev.mysql.com/doc/refman/5.1/...air-table.html --> mysql 5.1

Of course, before doing anything I recommend that you do a backup.

Hope that helps.

12-24-2013 09:40 AM #3 bbrock32 (Administrator)

Yep , basically you need a better server

12-24-2013 10:10 AM #4 kamaleon (Member)

Quote Originally Posted by bbrock32 View Post
Yep , basically you need a better server
Hummmmm, not really, why is that? This could happen to any server... Even the best one If a table is really corrupted.

12-24-2013 11:17 AM #5 bbrock32 (Administrator)

Well actually I supposed he ran already a repair after your reply.

And anyway , looking better into it might also be an issue with maximum number of files that the OS allows.

So you would need to increase the file open limit here /etc/security/limits.conf .

For a better idea read the link below or just submit a ticket to your host and they will increase it.

http://stackoverflow.com/questions/5...on-ubuntu-8-04

12-24-2013 12:05 PM #6 caurmen (Administrator)

Yep, I'd definitely recommend talking to your hosts on this one. There could be a number of explanations, and they're in the best place to advise you further.

01-19-2014 11:28 PM #7 getzlaf15 (Member)

EDIT***

Found a fix for this

Edit /etc/security/limits.conf

add


mysql soft nofile 24000
mysql hard nofile 32000

at the bottom

then

Edit /etc/my.cnf

Add

open_files_limit=20000

restart mysql

Then type ... mysqladmin var | grep open_files_limit
see if it shows 20000

So far no issues...

Home > Technical & Creative Skills > Tracking Campaigns