Hello,
On 05.04.11 12:44, André Bauer wrote: > If you´re using OTRS 2.4.x you could use the community extension > "MySQL Booster". > > You can find it here: http://forums.otrs.org/viewtopic.php?f=21&t=8062 > > It will speed up OTRS MySQL Performance a lot when you´re also using a > customer DB. Is this applicable even when we have the customer database in oracle? I think it speeds up user searches, but I'm not sure in what way... However the talk about using lower() in selects explains much... > am Montag, 4. April 2011 um 15:56 schrieben Sie: > MUf> we have a few years of tickets stored in MySQL database, in MyISAM > tables. > > MUf> Last few weeks the OTRS is becoming slow. I feel it could be caused by > MUf> using MyISAM tables since locking is working at table level, while with > MUf> InnoDB it's done at row level. > > MUf> OTOH, the InnoDB tables do not support fulltext searching. > > MUf> Could anyone tell me if it's worth moving tables to InnoDB and which > tables > MUf> should be moved, or, which should be left in MyISAM? -- Matus UHLAR - fantomas, uh...@fantomas.sk ; http://www.fantomas.sk/ Warning: I wish NOT to receive e-mail advertising to this address. Varovanie: na tuto adresu chcem NEDOSTAVAT akukolvek reklamnu postu. Emacs is a complicated operating system without good text editor. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs