OTRS 2.4.7 - Mysql database max size support

Hi, I am using OTRS 2.4.7 on Linux with Mysql Database. Data size is 13 GB. Please let me know what is the max size it can support without affecting the performance. Of late I am experiencing that the respone is slow, it is beacuse of the BIG size of database? regards, Amit

Hi Amit, 13GB of data for a Database server isn't too much. What kind of Hardware do you have in your DB Server? (CPU, RAM, HDDs). Have you optimized your my.cnf for big databases ? Greetings Oliver Am 29.11.2010 05:39, schrieb Amit Sharma:
Hi,
I am using OTRS 2.4.7 on Linux with Mysql Database.
Data size is 13 GB.
Please let me know what is the max size it can support without affecting the performance.
Of late I am experiencing that the respone is slow, it is beacuse of the BIG size of database?
-- Mit freundlichen Grüßen Oliver Methfessel Methfessel Computers Hauptsitz: Zieglerstr. 25a, 65191 Wiesbaden Kundenbüro: Kloppenheimer Weg 11, 65191 Wiesbaden Geschäftsführender Inhaber: Oliver Methfessel http://www.methfessel-computers.de

Hi Oliver,
It is a virtual machine hosted on VMWARE with 2 GB RAM and 80 GB HDD on a HP DL360 G6 server Intel Xeon Quad Core.
I am sure I have not done any optimisation in my.cnf
Please guide.
regards,
amit
--- On Mon, 29/11/10, Oliver Methfessel [MC]
participants (2)
-
Amit Sharma
-
Oliver Methfessel [MC]