database error

[geevest.com]

i get this database error message :

Database error in vBulletin 3.7.3:

Invalid SQL:

				SELECT smilieid, smilietext, smiliepath, smilie.title,
					imagecategory.title AS category
				FROM smilie AS smilie
				LEFT JOIN imagecategory AS imagecategory USING(imagecategoryid)
				ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder;

MySQL Error   : Out of memory (Needed 322122456 bytes)
Error Number  : 5
Request Date  : Monday, January 19th 2009 @ 07:13:57 AM
Error Date    : Monday, January 19th 2009 @ 07:13:57 AM
Script        : http://abc.com/forum/newreply.php?do=newreply&noquote=1&p=242779
Referrer      : http://abc.com/forum/showthread.php?p=242779
IP Address    : 
Username      : name
Classname     : vB_Database
MySQL Version : 5.0.67-community

how i can fixed this issue? tq

[SEOvB]

Upgrade your hosting, or contact your hosting company

Try disabling modifications and addons as well i suppose

[geevest.com]

i take dedicated server for this bro,
500$/month.so its not enough?
it just i need to upgrade my RAM or what?

[SEOvB]

How much ram do you have?

Is your server optimized, or are you simply throwing all the hardware it can contain at it?

Try

Make a my.cnf backup before doing

cp /etc/my.cnf /etc/my.cnf.prev

Then change following values on /etc/my.cnf to

nano /etc/my.cnf

max_connections=500
wait_timeout = 30
query_cache_limit=2M
query_cache_size=24M

Restart mysql.

service mysqld restart

This should help

[geevest.com]

i have 4GB ram friend.visitor 20.000/day so its not enough? or i need to upgrade my ram?

[Marco van Herwaarden]

I would start by posting an optimisation request at vB.com.

[SEOvB]

Originally Posted by geevest.com

i have 4GB ram friend.visitor 20.000/day so its not enough? or i need to upgrade my ram?

I dont know, there are lots of variables.

How many modifications?
What do those visitors do while there?
Is your server optimized?
Do you run anything other than vBulletin?


That error tells you 1 thing. Your MySQL is out of allowed memory

Solutions: Optimize Server/MySQL, Remove modifications/plugins, Throw more RAM and get the same error in a few weeks probably

I suggest posting over at vBulletin.com Server optimization forum: http://www.vbulletin.com/forum/forumdisplay.php?f=14

[geevest.com]

hello,now im already upgrade my server and Ram in to 8GB.
until now im always getting database error.
yes i have 3sites in 1dedicated server but other site is simple dont have traffic.that just blogs and imageshare.
do i need to disable all plugins?

[SEOvB]

no you shouldn't

And adding more ram may not solve your issue if you don't allow MySQL access to the more ram.

Post in the server optimization forum and you could probably save some money: http://www.vbulletin.com/forum/forumdisplay.php?f=14

[Dismounted]

Make sure you're running a 64-bit OS, otherwise, your RAM won't be fully utilised.