Hi Carlos,
A great tool for finding out how to optimize your mysql is mysqltuner.pl. It's a perl script that checks your setup and makes recommandations for tuning it. Read more about it at mysqltuner.com.
Lars
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Carlos Andrés Gallego Arboleda
Sent: Saturday, June 18, 2011 12:06 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] OTRS DB MyISAM vs InnoDB
Hi Michiel,
Thanks for your words. After reading them, we'll stick to MyISAM and increase memory
Regards.
Carlos Gallego
2011/6/17 Michiel Beijen
We have a DB more big than 4.1 GB and the application turn more slow.
Our OS is OpenSuse 11.3 How is your database server dimensioned? It is pretty important that you can keep the most frequently used parts of your database in memory. So if you have a bigger database you will also want to throw in more memory. InnoDB or MyISAM does not make very much difference in my experience as OTRS is mostly read-only anyway. Usually MyISAM is faster than InnoDB and OTRS does not use any of the transactional features that InnoDB offers.
Let me know what you decide to do. -- Mike --------------------------------------------------------------------- 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