[rt-users] Group.Name NULL (~performace)

[Jure Simsic]

Hi,

I'm trying to drill to the bottom of why my RT performance is really 
sluggish and it burns out nearly all of my CPU (on a 4 CPU solaris 
box!!!!). As i was looking around through the mysql tables i found out i 
have a bunch of groups with NULL name or just empty string. The 
situation is like this:

mysql> select count(id) from Groups where Name like '%';
+-----------+
| count(id) |
+-----------+
|       188 |
+-----------+
1 row in set (0.03 sec)

Of these, 7 are empty strings:

mysql> select count(id) from Groups where Name='';
+-----------+
| count(id) |
+-----------+
|         7 |
+-----------+
1 row in set (0.02 sec)

and 157 are a "User nnn" type:

mysql> select count(id) from Groups where Name like 'User %';
+-----------+
| count(id) |
+-----------+
|       157 |
+-----------+
1 row in set (0.03 sec)


And the NULLs are 3639-188=3451!!!

mysql> select count(id) from Groups;
+-----------+
| count(id) |
+-----------+
|      3936 |
+-----------+
1 row in set (0.02 sec)


Shit. Is this normal?? I have a feeling my DB is all messed up. The page 
loads take a long time and the main reason that I've stumbled on this 
Groups thing is that i have a test user and i couldn't deassign him from 
one group - it would timeout and the CPU just went ^^^..So I had to 
delete him from group membership by hand..

Are there any DB  sanity tools/checks one could try or just some schema 
to recreate the db anew and in sane state?

I'm running rt 3.0.11 on solaris8 and mysql 4.0.18, apache 1.3.29, 
modperl 1.29 but also tried apache2 (2.0.49) with fastcgi (2.4.0) but 
was constantly getting errors and stack dumps, so I switched back 
yesterday..

Any suggestions?
Anything is appreciated ;-)

Thanx
Jure