[rt-users] RT Performance Issues

[Ken Gunderson]

On Thursday 19 September 2002 02:26 pm,  Drew Mooney wrote:
> 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?

safe_mysqld is a script for starting up mysqld-- also monitors and 
restarts the daemon if server dies.  it's a good thing....