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 mailto:michiel.beijen@gmail.com> Hi Carlos, On Fri, Jun 17, 2011 at 16:48, Carlos Andrés Gallego Arboleda mailto:carlos.gallego@itconsultores.com.co> wrote:

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