mysql lockup / datastore

[ugr|dual]

hi,

I am experiencing mysql lockups under heavy load (well optimized server I think, loads 5.00+). mysql goes to 99.9% cpu usage and all further connection attempts time out.

I took a look with mysqladmin when it happened and saw a lot of connections with query for the datastore table. all those had to be closed abnormally to get mysql down for a reboot. there where only 4 other active queries and 8 other connections total (persistent is off).

Any hint on how I can avoid that? Is this a table lockup?

| 1118495 | user | localhost | database | Query | 167 | | SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergrou |

[Floris]

Try updating your config file and datastore cache file to use the file system instead of the database. Perhaps this speeds things up for you.

[ugr|dual]

Thanks for the tipp, but how exactly do I do that?

I see no options regarding this change in the config file.

[Floris]

This is a feature from 3.6.7 PL1, I recommend to upgrade.

[ugr|dual]

Not a quick option as our system is very huge and VB stock edition is just a part of it.

any other hints on handling that condition?

[Steve Machol]

Please see this thread for help with optimizing your server:

http://www.vbulletin.com/forum/showthread.php?threadid=70117

Then post the requested info in a new thread in that forum.

[Ryloth]

Try updating your config file and datastore cache file to use the file system instead of the database. Perhaps this speeds things up for you.

i have this in my config.php

$config['Datastore']['class'] = 'vB_Datastore_Filecache';

and my datastore_cache.php is still over a year old. i set permissions for IUSR to read/write/modify and still... nothing. it is still hitting the database. i have vbulletin 3.6.4.

[peterska2]

Please start your own thread in the relevant forum for your version.