Guten Tag Matus UHLAR - fantomas, 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. Cheers André am Montag, 4. April 2011 um 15:56 schrieben Sie: MUf> Hello, 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? MUf> Thank you -- Mit freundlichen Grüßen André Bauer mono...@gmx.net System: Ubuntu 8.04.1/Apache 2.2.8-MOD_PERL/MySQL 5.0.51a/ OTRS 2.3.3 --------------------------------------------------------------------- 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
