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, uhlar@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.