Session optimizer 1.0

Extension type: Other Resource
Extension originally created by mumuri on May 29, 2009

Description

This scripts allows you to optimise mysql sessions by transforming your session table in a "memory" table (this table will be loaded in the ram of your server)

Some explanations

Mysql use differents type of table (myIsam, InnoDB etc ...), one of them is the memory table. This type of table are loaded in the ram of your server for fastest access.


BUT, this have a consequence, if you restart mysql, data from this type of table are lost (like when you're closing your computer, data in ram memory is lost), which means your table will be purge every time a "mysql restart" is done (this does not happen often).

What is the use of this for me ?

In your zikula instance, there is a table "session_info" which store all information on your connection (current IP and session id). If you lost data from this table, the only thing the user will have to do, is to login back if he was connected. The structure of the table is not lost.

I will be clear, the effect of this optimisation is little. It'can have an influence if you're runing a big discussion board for logged people (as they use this session info a lot). This can have an influence too, if you're using anonymous session for unlogged people.

How to install ?

Run this query on your phpmyadmin

ALTER TABLE `zk_session_info` CHANGE `pn_vars` `pn_vars` VARCHAR( 255 )  NOT null   ;
ALTER TABLE `zk_session_info`  ENGINE = MEMORY ;

Work only with mysql !!!
http://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine.html
http://communaute.zikula.fr/Forums/viewtopic/topic/2951/start/12

Screenshots

TargetGroup

All

Status

Normal