[rt-users] RT Performance Issues

[Drew Mooney]

I had similar performance problems where RT would hang a bit between page
loads. I am running 2.0.14 on a Solaris 2.8 Netra T105.

Initial install was with 512MB of RAM, another user on this list advised that
the 512M would get chewed up fairly quickly. He was correct. With barely 50
tickets in our system things were getting a bit slow and the system was
chewing into swap space quite a bit.

I upped the RAM to 1024MB and speed improved quite nicely - except for doing
Keyword Selections. Is that database intensive work? If so, it is only db
intesive at setup time, or whenever Keywords are utilized? 

I had this question on the output of 'top':

load averages:
CPU states: % idle,  0.0% user, % kernel,  0.0% iowait,  0.0% swap
load averages:
42 processes:  41 sleeping, 1 on cpu
CPU states: 99.8% idle,  0.0% user,  0.2% kernel,  0.0% iowait,  0.0% swap
Memory: 1024M real, 511M free, 860M swap in use, 2031M swap free

   PID USERNAME THR PRI NICE  SIZE   RES STATE    TIME    CPU COMMAND
   371 root       7  58    0 2392K  984K sleep    0:20  0.0% mibiisa
   421 mysql     21  58    0  695M  337M sleep    0:20  0.00% mysqld
   249 apache     1  20    0   22M   19M sleep    0:18  0.00% httpd
   247 apache     1  58    0   19M   13M sleep    0:12  0.00% httpd
   250 apache     1  52    0   19M   14M sleep    0:08  0.00% httpd
   253 apache     1  58    0   18M   13M sleep    0:06  0.00% httpd
   430 apache     1  58    0   19M   14M sleep    0:04  0.00% httpd
   246 apache     1  58    0   19M   15M sleep    0:03  0.00% httpd
   432 apache     1  58    0   19M   14M sleep    0:03  0.00% httpd
   431 apache     1  51    0   18M   13M sleep    0:02  0.00% httpd
  2329 dmooney1   1  59    0 2024K 1184K cpu      0:00  0.00% top
   402 root       1   0    0 1136K  112K sleep    0:00  0.00% safe_mysqld
   259 root       1   2    0 1752K  168K sleep    0:00  0.00% smcboot
   260 root       1  12    0 1752K   80K sleep    0:00  0.00% smcboot
   317 root       2  29    0 3200K  960K sleep    0:00  0.00% dmispd


What's the deal with the 'safe_mysqld' - I know it's invoked by the mysql init
script, but is the process necessary? What does it do?

regards,

Drew