[rt-users] Performance questions....

[Gary Greene]

On 1/11/10 11:36 PM, "Emmanuel Lacour" <elacour at easter-eggs.com> wrote:
> On Mon, Jan 11, 2010 at 05:29:58PM -0800, Gary Greene wrote:
>> I'm currently running RT 3.8.1 on a Dell Optiplex 745 tower in my cube
> 
> think about upgrading to latest 3.8 there were many bugs in first
> releases (3.8.0, 3.8.1) and many improvements since.
> 
>> running CentOS 5.2. This box has a Pentium D dual core CPU with 1GB RAM. The
>> user load on the box is almost nothing, however when I update a ticket, it
>> takes a lot of time (about 20 seconds). Is there anyway I can improve
>> performance here?
>> 
> 
> What kind of database are you using. RT relies a lot on databases
> performances, and uses a lot of queries, even for a small set of users.
> For mysql, you _must_ tune the default configuration to be sure it
> really uses your RAM.
> 
> looks here:
> 
> http://wiki.bestpractical.com/view/PerformanceTuning
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com

We're using MySQL 5 on this box. I'll go through the performance tuning page
to see how it goes.

-- 
Gary L. Greene, Jr.
IT Operations
Minerva Networks, Inc.
Cell:  (650) 704-6633
Phone: (408) 240-1239