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

Hi Carlos,

On Fri, Jun 17, 2011 at 16:48, Carlos Andrés Gallego Arboleda 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