So, you have a query that ran for 400+ seconds an examined fifteen million rows. That seems..wrong. What does this say?
EXPLAIN SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_4 JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN Groups Groups_3 ON ( Groups_3.id = CachedGroupMembers_2.GroupId ) WHERE (Principals_1.Disabled = '0') AND (ACL_4.PrincipalType = Groups_3.Type) AND (Principals_1.id != '1') AND (Principals_1.PrincipalType = 'User') AND (ACL_4.RightName = 'OwnTicket') AND (Groups_3.Domain = 'RT::Queue-Role') AND ((ACL_4.ObjectType = 'RT::Queue') OR (ACL_4.ObjectType = 'RT::System')) ORDER BY main.Name ASC; On Tue, Mar 18, 2008 at 04:10:19PM +0000, Richard Ellis wrote: > Hi Jesse, > > The output of the slow query log for the last 23 hours: > > # [EMAIL PROTECTED]: rt_user[rt_user] @ localhost [] > # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 > use rt3; > SELECT GET_LOCK('Apache-Session-ce4e206474839cb7dd09a5216f86ce9e', 3600); > # Time: 080317 12:17:03 > # [EMAIL PROTECTED]: rt_user[rt_user] @ localhost [] > # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 > SELECT GET_LOCK('Apache-Session-ce4e206474839cb7dd09a5216f86ce9e', 3600); > # Time: 080317 12:17:47 > # [EMAIL PROTECTED]: rt_user[rt_user] @ localhost [] > # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 > SELECT GET_LOCK('Apache-Session-ce4e206474839cb7dd09a5216f86ce9e', 3600); > # Time: 080317 13:07:11 > # [EMAIL PROTECTED]: rt_user[rt_user] @ localhost [] > # Query_time: 411 Lock_time: 0 Rows_sent: 0 Rows_examined: 15418603 > SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_4 JOIN > Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN > CachedGroupMembers CachedGroupMembers_2 ON ( > CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN Groups Groups_3 > ON ( Groups_3.id = CachedGroupMembers_2.GroupId ) WHERE > (Principals_1.Disabled = '0') AND (ACL_4.PrincipalType = Groups_3.Type) > AND (Principals_1.id != '1') AND (Principals_1.PrincipalType = 'User') > AND (ACL_4.RightName = 'OwnTicket') AND (Groups_3.Domain = > 'RT::Queue-Role') AND ((ACL_4.ObjectType = 'RT::Queue') OR > (ACL_4.ObjectType = 'RT::System')) ORDER BY main.Name ASC; > # Time: 080317 13:07:13 > # [EMAIL PROTECTED]: rt_user[rt_user] @ localhost [] > # Query_time: 46 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 > SELECT GET_LOCK('Apache-Session-9f2f1478e69cd6a6381f8ef9b98f7551', 3600); > # [EMAIL PROTECTED]: rt_user[rt_user] @ localhost [] > # Query_time: 346 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 > SELECT GET_LOCK('Apache-Session-9f2f1478e69cd6a6381f8ef9b98f7551', 3600); > > Thanks > > Richard > > Jesse Vincent wrote: > >Sounds like someone previously changed the config file without > >restarting. > > > > > >On Mon, Mar 17, 2008 at 05:22:52PM +0000, Richard Ellis wrote: > > > >>Looks like theres a problem with the logfile > >> > >>080317 10:04:58 mysqld started > >>InnoDB: Error: log file /usr/local/mysql/data/ib_logfile0 is of > >>different size 0 5242880 bytes > >>InnoDB: than specified in the .cnf file 0 16777216 bytes! > >>080317 10:04:59 [Note] /usr/local/mysql/bin/mysqld: ready for connections. > >>Version: '5.0.51a-log' socket: '/tmp/mysql.sock' port: 3306 MySQL > >>Community Server (GPL) > >>080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:11 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:05:55 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:06:36 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:47 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:49 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:49 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:49 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:49 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:50 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:51 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:07:59 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/ACL.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/ACL.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Attachments.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Attachments.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Attributes.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Attributes.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/CustomFieldValues.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/CustomFieldValues.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/CustomFields.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/CustomFields.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Groups.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Groups.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Links.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Links.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/ObjectCustomFieldValues.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/ObjectCustomFieldValues.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Principals.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Principals.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Queues.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Queues.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/ScripActions.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/ScripActions.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/ScripConditions.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/ScripConditions.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Scrips.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Scrips.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Templates.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Templates.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Tickets.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Tickets.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Transactions.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Transactions.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:09:06 [ERROR] /usr/local/mysql/bin/mysqld: Incorrect > >>information in file: './rt3/Users.frm' > >>080317 10:16:25 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown > >> > >>080317 10:16:27 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete > >> > >>080317 10:16:27 mysqld ended > >> > >> > >> > >>Jesse Vincent wrote: > >> > >>>Note that mysqlcheck WILL report corruption if the database is being > >>>accessed. > >>> > >>> > >>> > >>>On Mar 17, 2008, at 1:13 PM, Richard Ellis wrote: > >>> > >>> > >>>>Restarted to apply that change and now it looks like the database has > >>>>gone bang. > >>>> > >>>>gpsummit# /usr/local/mysql/bin/safe_mysqld & > >>>>[2] 6970 > >>>>gpsummit# Starting mysqld daemon with databases from > >>>>/usr/local/mysql/data > >>>> > >>>>gpsummit# mysqlcheck rt3 > >>>>rt3.ACL > >>>>Error : Incorrect information in file: './rt3/ACL.frm' > >>>>error : Corrupt > >>>>rt3.Attachments > >>>>Error : Incorrect information in file: './rt3/Attachments.frm' > >>>>error : Corrupt > >>>>rt3.Attributes > >>>>Error : Incorrect information in file: './rt3/Attributes.frm' > >>>>error : Corrupt > >>>>rt3.CachedGroupMembers > >>>>Error : Can't find file: 'CachedGroupMembers' (errno: 2) > >>>>error : Corrupt > >>>>rt3.CustomFieldValues > >>>>Error : Incorrect information in file: './rt3/CustomFieldValues.frm' > >>>>error : Corrupt > >>>>rt3.CustomFields > >>>>Error : Incorrect information in file: './rt3/CustomFields.frm' > >>>>error : Corrupt > >>>>rt3.GroupMembers > >>>>Error : Can't find file: 'GroupMembers' (errno: 2) > >>>>error : Corrupt > >>>>rt3.Groups > >>>>Error : Incorrect information in file: './rt3/Groups.frm' > >>>>error : Corrupt > >>>>rt3.Links > >>>>Error : Incorrect information in file: './rt3/Links.frm' > >>>>error : Corrupt > >>>>rt3.ObjectCustomFieldValues > >>>>Error : Incorrect information in file: > >>>>'./rt3/ObjectCustomFieldValues.frm' > >>>>error : Corrupt > >>>>rt3.ObjectCustomFields > >>>>Error : Can't find file: 'ObjectCustomFields' (errno: 2) > >>>>error : Corrupt > >>>>rt3.Principals > >>>>Error : Incorrect information in file: './rt3/Principals.frm' > >>>>error : Corrupt > >>>>rt3.Queues > >>>>Error : Incorrect information in file: './rt3/Queues.frm' > >>>>error : Corrupt > >>>>rt3.ScripActions > >>>>Error : Incorrect information in file: './rt3/ScripActions.frm' > >>>>error : Corrupt > >>>>rt3.ScripConditions > >>>>Error : Incorrect information in file: './rt3/ScripConditions.frm' > >>>>error : Corrupt > >>>>rt3.Scrips > >>>>Error : Incorrect information in file: './rt3/Scrips.frm' > >>>>error : Corrupt > >>>>rt3.Templates > >>>>Error : Incorrect information in file: './rt3/Templates.frm' > >>>>error : Corrupt > >>>>rt3.Tickets > >>>>Error : Incorrect information in file: './rt3/Tickets.frm' > >>>>error : Corrupt > >>>>rt3.Transactions > >>>>Error : Incorrect information in file: './rt3/Transactions.frm' > >>>>error : Corrupt > >>>>rt3.Users > >>>>Error : Incorrect information in file: './rt3/Users.frm' > >>>>error : Corrupt > >>>>rt3.sessions > >>>> > >>>>I am so pooched now. No idea if this is recoverable or not. > >>>> > >>>>Rik > >>>> > >>>>Jesse Vincent wrote: > >>>> > >>>>>On Mar 17, 2008, at 12:26 PM, Richard Ellis wrote: > >>>>> > >>>>> > >>>>>>mysql> SELECT * from ACL, CachedGroupMembers, Groups where > >>>>>>ACL.RightName = 'OwnTicket' and ACL.PrincipalId = Groups.id and > >>>>>>Groups.id = CachedGroupMembers.GroupId; > >>>>>> > >>>>>Ok. Those results tell me there should be 290 names in your > >>>>>"SelectOwner" drop down. (That's a lot, but not enough that you > >>>>>should see 400s perf ;) > >>>>> > >>>>>Do you have mysql logging slow queries? If not, can you? > >>>>> > >>>>> > >>>>> > >>>>-- > >>>> > >>>>Richard Ellis > >>>>Technical Developer, .Sun eBusiness > >>>> > >>>>Sun Microsystems, Inc. > >>>>Phone x(70) 24727/+44-1252-424 727 > >>>>Fax +44 1252 420410 > >>>>Email [EMAIL PROTECTED] > >>>> > >>>> > >>-- > >>Sun.com <http://www.sun.com> * Richard Ellis * > >>Technical Developer, .Sun eBusiness > >> > >>*Sun Microsystems, Inc.* > >>Phone x(70) 24727/+44-1252-424 727 > >>Fax +44 1252 420410 > >>Email [EMAIL PROTECTED] > >> sun.com > >> > >> > > > > > > -- > Sun.com <http://www.sun.com> * Richard Ellis * > Technical Developer, .Sun eBusiness > > *Sun Microsystems, Inc.* > Phone x(70) 24727/+44-1252-424 727 > Fax +44 1252 420410 > Email [EMAIL PROTECTED] > sun.com > -- _______________________________________________ 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