From: Stephane C. <se...@lo...> - 2008-08-28 14:58:36
|
Le Thu, Aug 28, 2008 at 10:11:48AM -0400, Louis-Philippe Huberdeau écrivait : > On August 28, 2008 09:41:32 Stephane Casset wrote: > > Le Thu, Aug 28, 2008 at 09:42:02AM -0400, Louis-Philippe Huberdeau > écrivait : > > > InnoDB is not available on all installations. If available, it could be a > > > good thing to reduce the locking and should have limited impact. > > > > > > ALTER TABLE sessions ENGINE=InnoDB; > > > > well tiki_sessions... but yes... > > I tend to thing sessions is more of a bottleneck because it gets larger > writes, but it could be both. I don't know the exact configuration of tw sites, but are the sessions stored in DB ? If it is the case can we try to use the php sessions management instead, or is not available or advisable because of things unknown to me ? > > > Maybe this is something we could try on info or some other side before > > > patching the code. > > > > Trying this will be easier than backporting recent optimizations. > > > > > If we decide to change the default, I think it should remain as an alter > > > statement. If it fails because the engine is not available, the table > > > still gets created. > > > > Yes we can propose this as an option at install time. > > > > By the way the installer is MySQL only... > > Just like the rest of tiki at this time. Until other problems are solved, > solving this won't help anyone. Well it was not my understanding that TikiWiki was MySQL only, but if it is ok with everyone, then we can have more optimizations coming... > tiki_sessions only keeps track of the session, sessions get a read and > a write on every request for the data when using db sessions. Yes, maybe it is not a very good setup... or am I missing something ? > I don't think changing the field type would help and indexing seems > just fine. sessionId is currently the primary key, so that's just > fine. Yes right for sessionId, I saw that just after hitting the send key !;p > If we can avoid hitting tiki_sessions for anonymous users, that's a good > thing, but they still need sessions. A+ -- Stéphane Casset LOGIDÉE sàrl Se faire plaisir d'apprendre 1a, rue Pasteur Tel : +33 388 23 69 77 ca...@lo... F-67540 OSTWALD Fax : +33 388 23 69 77 http://logidee.com |