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
