[rt-users] RT 3.0 Speed

[Simon Woodward]

Hi Jesse,

> I don't have the mysql docs in front of me, but these feel low.

I tried higher, but the box just didn't have the available resources.

This server also runs our intranet and Samba file shares for our
internal network, however it managed to run RT2 with no problem, even
using MySQL 4 (MYI, not InnoDB however) So it didn't like assigning 256M
etc of memory to just mysql. (Samba and intranet have run on this server
no problem for ages and hardly take up any resources).

> Things that would be useful to know:
> 	How much free memory on the box? Is it swapping?

;-), with the settings above, yup, its using it all, and its mysql thats
grabbing it ... and yes it is swapping ... which I accept is a cause for
it being slow, however yet again, it was fine under RT2

> 	How many rows in your: Users, Groups, GroupMembers,
> 	CachedGroupMembers, Queues, ACL, Tickets and Transactions 
> 	tables?

Users: 12828
Groups: 170161			} Errr, does this not look too large ?
GroupMembers: 114993		} This data is a fresh import from the
CachedGroupMembers: 387317	} rt2 dumped data using your util.
Queues: 20
ACL: 201
Tickets: 39308
Transactions: 149330

> 	What load is the box running at?

On average, its looking about 1.5 (which is abnormal), but its going up
between 10-40 as it gets busy, and its all mysql.

2:31pm  up 8 days,  4:41,  3 users,  load average: 2.62, 2.42, 3.81
112 processes: 109 sleeping, 3 running, 0 zombie, 0 stopped
CPU states: 69.8% user,  2.5% system,  0.0% nice, 27.5% idle
Mem:   517176K av,  507700K used,    9476K free,  141460K shrd,   50604K
buff
Swap:  136512K av,   77728K used,   58784K free                  116040K
cached

  PID USER     PRI  NI  SIZE  RSS SHARE STAT  LIB %CPU %MEM   TIME
COMMAND
14849 mysqld    20   0 97664  95M  2564 R     296 62.2 18.8   1:17
mysqld


> 	Are you sure the RT tables are actually innodb? Mysql may
> 	silently ignore the innodb directive if you don't have it
> 	configured right.

Yes. I am new to InnoDB, however it seems to be:

-rw-rw----   1 mysqld   daemon   673185792 May  6 14:28 ibdata1
-rw-rw----   1 mysqld   daemon    5242880 May  6 14:28 ib_logfile0
-rw-rw----   1 mysqld   daemon    5242880 May  6 14:28 ib_logfile1

root at cropton:/usr/local/var/mysql# du -sk rt3
484     rt3

root at cropton:/usr/local/var/mysql/rt3# ls -altr
total 488
-rw-rw----   1 mysqld   daemon       9006 May  4 20:56 Queues.frm
-rw-rw----   1 mysqld   daemon       8656 May  4 20:56 Principals.frm
-rw-rw----   1 mysqld   daemon       8838 May  4 20:56 Links.frm
-rw-rw----   1 mysqld   daemon       8920 May  4 20:56 Attachments.frm
-rw-rw----   1 mysqld   daemon       9744 May  4 20:57 Users.frm
-rw-rw----   1 mysqld   daemon       8856 May  4 20:57 Transactions.frm
-rw-rw----   1 mysqld   daemon       9388 May  4 20:57 Tickets.frm
-rw-rw----   1 mysqld   daemon       9134 May  4 20:57 Scrips.frm
-rw-rw----   1 mysqld   daemon       8876 May  4 20:57
ScripConditions.frm
-rw-rw----   1 mysqld   daemon       8696 May  4 20:57 Groups.frm
-rw-rw----   1 mysqld   daemon       8612 May  4 20:57 GroupMembers.frm
-rw-rw----   1 mysqld   daemon       8716 May  4 20:57
CachedGroupMembers.frm
-rw-rw----   1 mysqld   daemon       8812 May  4 20:57 ACL.frm
-rw-rw----   1 mysqld   daemon       8622 May  4 20:57 sessions.frm
-rw-rw----   1 mysqld   daemon       8786 May  4 20:57
TicketCustomFieldValues.frm
-rw-rw----   1 mysqld   daemon       8906 May  4 20:57 Templates.frm
-rw-rw----   1 mysqld   daemon       8820 May  4 20:57 ScripActions.frm
-rw-rw----   1 mysqld   daemon       8868 May  4 20:57 CustomFields.frm
-rw-rw----   1 mysqld   daemon       8824 May  4 20:57
CustomFieldValues.frm
drwx------   2 mysqld   daemon       4096 May  4 20:57 ./
drwx------  18 mysqld   daemon       4096 May  6 13:43 ../
-rw-rw----   1 mysqld   daemon      24576 May  6 14:29 sessions.MYI
-rw-rw----   1 mysqld   daemon     227348 May  6 14:29 sessions.MYD

> 	What mysql queries appear to be taking a long time?

TBH, everything, from logging in, to displaying a ticket ... however it should
be noted that those select count(*)'s I did for you above were quick, so I
suspect we're talking about queries involving joins, but I haven't got anything
more specific than that.

Cheers,

Simon.