Showing entries 1 to 1
Displaying posts with tag: session table (reset)
Jun
04
2009
vBulletin, session table is InnoDB
Posted by Mohammad Lahlouh on Thu 04 Jun 2009 08:38 UTC
Tags:

In large vBulletin forum we had strange problem in memory table "session", we've 25M post, 1.7M user, 20K online user.So we change engine of session table to InnoDB and set configuration of innoDB as follow (be careful this configuration is not proper for other tables because this is good in performance but bad in crash and recovery, and data reliability)innodb_data_home_dir = /dev/shm/mysql/

Showing entries 1 to 1