[rt-users] sessions table is lost after a system crash

[Tim Cutts]

On 23 Apr 2009, at 6:54 pm, Tom Lahti wrote:

> Kenneth Marshall wrote:
>> Tim,
>>
>> I am curious. Are you using InnoDB tables or MyISAM tables?
>> I thought that RT needed InnoDB. Does it have a problem with
>> system crashes and recovery with InnoDB?
>>
>> Just wondering.
>> Ken
>
> I was just about to say the same thing when this came in.  I think  
> you want
> InnoDB tables, not MyISAM.  In particular, large tables like the  
> attachment
> table will have problems, and frequently updated tables like the  
> session
> table will have crash recovery issues.  The crash recovery in the  
> InnoDB
> backend is more robust, as is the indexing methodology.

Preaching to the choir.  In a default RT installation on MySQL, all  
the tables are InnoDB *except* for the sessions table.  I don't know  
why that particular table is MyISAM, and I don't know whether there  
would be any consequences of converting it.

Tim


-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE.