MySQL question: MyISAM or InnoDB ?
Hello, we have a few years of tickets stored in MySQL database, in MyISAM tables. Last few weeks the OTRS is becoming slow. I feel it could be caused by using MyISAM tables since locking is working at table level, while with InnoDB it's done at row level. OTOH, the InnoDB tables do not support fulltext searching. Could anyone tell me if it's worth moving tables to InnoDB and which tables should be moved, or, which should be left in MyISAM? Thank you -- 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. REALITY.SYS corrupted. Press any key to reboot Universe.
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 monotek@gmx.net System: Ubuntu 8.04.1/Apache 2.2.8-MOD_PERL/MySQL 5.0.51a/ OTRS 2.3.3
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.
participants (2)
-
André Bauer -
Matus UHLAR - fantomas