Database performance

[mtsab]

Hi Guys,

I am just migrating to OTRS 3.3.3,
I finished the migration and I was checking at the Support Assessment module,

Everything looks good, until I run a SQL benchmark:


Result: SQL
Key Value Time Comment
Insert Time: 10000 54 s Should not take more than 5's on an average system.
Update Time: 10000 59 s Should not take more than 9's on an average system.
Select Time: 10000 5 s Looks fine!
Delete Time: 10000 44 s Should not take more than 5's on an average system.
Multiplier: * 1 s



What the heck! I just installed this thing... I am not really a mysql admin so I am kinda lost. Would you please advice me in what should I check in order to get this properly working?

Thank you!!

[wurzel]

Hi,

I got this bad times very often. But the "feeling" is good. And my top (htop) does not display loads on CPU or RAM issues.

So i don't bother.

but I don't know if this is correct.

Flo

[mtsab]

It seems to be working just fine to me, but if performance can be improved I'll love to know how to do it...