Joomla Session table in memory

IMPORTANT: The following article is valid only for Joomla 1 & 1.5, for newer versions of the CMS please check our WiKi on enabling opcode, object and session caching: https://eservices-greece.com/wiki/joomla/caching


You will change the storage engine for the session table from MyISAM to Memory

WARNING: If for any reason you want the session's to survive a restart of the server / mysql service then do not do this, since all sesion's will be wiped.

 

Since the memory engine doesnt support blobs, we change the type to a varchar with 5k size.

ALTER TABLE `jos_session` CHANGE `data` `data` VARCHAR( 5000 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL

Finally we change the storage engine

ALTER TABLE `jos_session` TYPE = memory

 

To revert the change:

ALTER TABLE `jos_session` ENGINE = MYISAM

ALTER TABLE `jos_session` CHANGE `data` `data` VARCHAR( 20000 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL

  • 1 Users Found This Useful
Was this answer helpful?