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 <michiel.beijen@gmail.com>

Hi Carlos,

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