[rt-users] rtx-shredder mysql optimization

[Alex Moura]

Another bit of information about the issue that may help is the following
"top" display, _during_ a rtx-shredder running and after it finished:

The next "top" output was captured with a running rtx-shredder (removing a
single ticket):
--------------------------
last pid: 51170;  load averages:  0.80,  0.54,  0.38  up 20+21:41:21
22:20:35
69 processes:  2 running, 67 sleeping
CPU states: 28.5% user,  0.0% nice,  2.0% system,  0.0% interrupt, 69.6%idle
Mem: 1796M Active, 782M Inact, 262M Wired, 149M Cache, 112M Buf, 522M Free
Swap: 4070M Total, 1100K Used, 4069M Free

  PID USERNAME    THR PRI NICE   SIZE    RES STATE  C   TIME   WCPU COMMAND
48990 mysql        10  20    0   447M 60432K kserel 0   4:18 93.60% mysqld
 2245 www           1   4    0   163M   156M accept 2  30:08  0.00% perl
 2131 www           1   4    0   185M   170M accept 0  28:34  0.00% perl
 2174 www           1   4    0   180M   169M accept 2  28:30  0.00% perl
 2058 www           1   4    0   174M   163M accept 0  27:23  0.00% perl
--------------------------

The next 'top' output was captured two minutes after rtx-shredder finished
removing a single ticket:

last pid: 51575;  load averages:  0.19,  0.41,  0.35  up 20+21:43:19
22:22:33
61 processes:  1 running, 60 sleeping
CPU states:     % user,     % nice,     % system,     % interrupt,     %
idle
Mem: 1769M Active, 783M Inact, 260M Wired, 149M Cache, 112M Buf, 550M Free
Swap: 4070M Total, 1096K Used, 4069M Free

  PID USERNAME    THR PRI NICE   SIZE    RES STATE  C   TIME   WCPU COMMAND
 2245 www           1   4    0   163M   156M accept 2  30:08  0.00% perl
 2131 www           1   4    0   185M   170M accept 0  28:34  0.00% perl
 2174 www           1   4    0   180M   169M accept 2  28:30  0.00% perl
 2058 www           1   4    0   174M   163M accept 0  27:23  0.00% perl
 2066 www           1   4    0   162M   155M accept 0  26:29  0.00% perl
48990 mysql        10  20    0   443M 58028K kserel 0   4:24  0.00% mysqld
 2067 nobody        1  96    0 14420K 13536K select 0   0:47  0.00% perl
 1919 root          1  96    0  8612K  5876K select 0   0:41  0.00% httpd
--------------------------

Thanks,

Alex
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080401/a4a0d350/attachment.htm>