This is if you do SHOW Processlist;
in mysql. I think we may have found the cause of the problem: every user is a privileged user who had modifyticket rights. Of course this brings problems once the database is growing. I'm going to change all permissions today and hope this will do the trick.. Thanks, Alain -----Original Message----- From: Dmitri Tikhonov [mailto:[EMAIL PROTECTED] Sent: maandag 30 oktober 2006 19:23 To: Alain Sips Cc: [email protected] Subject: Re: [rt-users] Problems Multi taksing On Mon, 2006-10-30 at 09:18 +0100, Alain Sips wrote: > I checked where it can be, and one thing I found out is that when you > want to retrieve a ticket, a lock is set during the time the ticket > gets displayed on the screen, for example: > > > > | 40456 | rt_user | rtdb.vianetworks.nl:56980 | rt3 | Query | 8 > | User lock | SELECT > GET_LOCK('Apache-Session-3623293be2c14213fb0441bcba44ccf0', 3600) Which table is this from? - Dmitri. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
