Hourly - MySQL client ran out of memory

[mickmel]

Once an hour I get the following message:
Invalid SQL:
SELECT user.joindate, user.userid, user.membergroupids, user.posts, user.reputation,
user.usergroupid, user.displaygroupid, user.customtitle, user.username,
userpromotion.joinusergroupid, userpromotion.reputation AS jumpreputation, userpromotion.posts AS jumpposts,
userpromotion.date AS jumpdate, userpromotion.type, userpromotion.strategy,
usergroup.title, usergroup.usertitle AS ug_usertitle
FROM user AS user
LEFT JOIN userpromotion AS userpromotion ON (user.usergroupid = userpromotion.usergroupid)
LEFT JOIN usergroup AS usergroup ON (userpromotion.joinusergroupid = usergroup.usergroupid)
WHERE user.lastactivity >= -3593
mysql error: MySQL client ran out of memory

mysql error number: 2008

However, other than that things are running very well. My host has tweaked the server and it runs well. However, they can't seem to isolate what setting would resolve this particular issue.

The forum has about 80,000 members, and the database server is a dedicated dual-processor server with 2 gigs of memory.

What should I recommend they do to resolve this issue?

[jason|xoxide]

Once an hour I get the following message:


However, other than that things are running very well. My host has tweaked the server and it runs well. However, they can't seem to isolate what setting would resolve this particular issue.

The forum has about 80,000 members, and the database server is a dedicated dual-processor server with 2 gigs of memory.

What should I recommend they do to resolve this issue?

According to the page below, that error is coming from your web server, not the DB server. What do your web server specs look like? How many simultaneous users do you have?

http://dev.mysql.com/doc/refman/5.0/en/out-of-memory.html

[eva2000]

Please provide info asked at http://www.vbulletin.com/forum/showthread.php?t=70117