[rt-users] RT 3.6.4 poor query performance

Richard Ellis Richard.Ellis at Sun.COM
Mon Mar 17 11:48:02 EDT 2008


Hi Jesse,

mysql> use rt3;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SELECT * from ACL where RightName = 'OwnTicket'
    -> ;
+------+---------------+-------------+-----------+------------+----------+-------------+---------------+
| id   | PrincipalType | PrincipalId | RightName | ObjectType | ObjectId 
| DelegatedBy | DelegatedFrom |
+------+---------------+-------------+-----------+------------+----------+-------------+---------------+
|   14 | Group         |          13 | OwnTicket | RT::Queue  |        1 
|      0 |             0 |
| 1686 | Group         |         389 | OwnTicket | RT::Queue  |        1 
|      0 |             0 |
| 1770 | Group         |         609 | OwnTicket | RT::Queue  |        1 
|      0 |             0 |
| 2124 | Group         |         755 | OwnTicket | RT::Queue  |        1 
|      0 |             0 |
|  262 | Group         |         332 | OwnTicket | RT::Queue  |        3 
|      0 |             0 |
|  249 | Group         |         333 | OwnTicket | RT::Queue  |        3 
|      0 |             0 |
|  313 | Group         |         332 | OwnTicket | RT::Queue  |        4 
|      0 |             0 |
|  300 | Group         |         334 | OwnTicket | RT::Queue  |        4 
|      0 |             0 |
|  326 | Group         |         332 | OwnTicket | RT::Queue  |        5 
|      0 |             0 |
|  338 | Group         |         335 | OwnTicket | RT::Queue  |        5 
|      0 |             0 |
|  363 | Group         |         332 | OwnTicket | RT::Queue  |        6 
|      0 |             0 |
|  350 | Group         |         336 | OwnTicket | RT::Queue  |        6 
|      0 |             0 |
|  376 | Group         |         332 | OwnTicket | RT::Queue  |        7 
|      0 |             0 |
|  388 | Group         |         337 | OwnTicket | RT::Queue  |        7 
|      0 |             0 |
|  401 | Group         |         332 | OwnTicket | RT::Queue  |        8 
|      0 |             0 |
|  413 | Group         |         338 | OwnTicket | RT::Queue  |        8 
|      0 |             0 |
|  438 | Group         |         332 | OwnTicket | RT::Queue  |        9 
|      0 |             0 |
|  425 | Group         |         339 | OwnTicket | RT::Queue  |        9 
|      0 |             0 |
|  237 | Group         |         332 | OwnTicket | RT::Queue  |       10 
|      0 |             0 |
|  224 | Group         |         340 | OwnTicket | RT::Queue  |       10 
|      0 |             0 |
|  450 | Group         |         332 | OwnTicket | RT::Queue  |       11 
|      0 |             0 |
| 4994 | Group         |       21706 | OwnTicket | RT::Queue  |       11 
|      0 |             0 |
|  288 | Group         |         332 | OwnTicket | RT::Queue  |       12 
|      0 |             0 |
|  512 | Group         |         342 | OwnTicket | RT::Queue  |       13 
|      0 |             0 |
|  500 | Group         |         350 | OwnTicket | RT::Queue  |       13 
|      0 |             0 |
|  550 | Group         |         343 | OwnTicket | RT::Queue  |       14 
|      0 |             0 |
|  537 | Group         |         350 | OwnTicket | RT::Queue  |       14 
|      0 |             0 |
|  575 | Group         |         344 | OwnTicket | RT::Queue  |       15 
|      0 |             0 |
|  563 | Group         |         350 | OwnTicket | RT::Queue  |       15 
|      0 |             0 |
|  587 | Group         |         345 | OwnTicket | RT::Queue  |       16 
|      0 |             0 |
|  600 | Group         |         350 | OwnTicket | RT::Queue  |       16 
|      0 |             0 |
|  625 | Group         |         346 | OwnTicket | RT::Queue  |       17 
|      0 |             0 |
|  613 | Group         |         350 | OwnTicket | RT::Queue  |       17 
|      0 |             0 |
|  650 | Group         |         347 | OwnTicket | RT::Queue  |       18 
|      0 |             0 |
|  638 | Group         |         350 | OwnTicket | RT::Queue  |       18 
|      0 |             0 |
|  662 | Group         |         348 | OwnTicket | RT::Queue  |       19 
|      0 |             0 |
|  675 | Group         |         350 | OwnTicket | RT::Queue  |       19 
|      0 |             0 |
|  475 | Group         |         349 | OwnTicket | RT::Queue  |       20 
|      0 |             0 |
|  487 | Group         |         350 | OwnTicket | RT::Queue  |       20 
|      0 |             0 |
|  688 | Group         |         350 | OwnTicket | RT::Queue  |       21 
|      0 |             0 |
| 5016 | Group         |       21707 | OwnTicket | RT::Queue  |       21 
|      0 |             0 |
|  525 | Group         |         350 | OwnTicket | RT::Queue  |       22 
|      0 |             0 |
|  701 | Group         |         341 | OwnTicket | RT::Queue  |       23 
|      0 |             0 |
|  714 | Group         |         351 | OwnTicket | RT::Queue  |       23 
|      0 |             0 |
| 1716 | Group         |         341 | OwnTicket | RT::Queue  |       24 
|      0 |             0 |
| 1728 | Group         |         352 | OwnTicket | RT::Queue  |       24 
|      0 |             0 |
|  763 | Group         |         341 | OwnTicket | RT::Queue  |       25 
|      0 |             0 |
|  751 | Group         |         353 | OwnTicket | RT::Queue  |       25 
|      0 |             0 |
|  776 | Group         |         341 | OwnTicket | RT::Queue  |       26 
|      0 |             0 |
|  800 | Group         |         354 | OwnTicket | RT::Queue  |       26 
|      0 |             0 |
|  824 | Group         |         341 | OwnTicket | RT::Queue  |       27 
|      0 |             0 |
|  812 | Group         |         355 | OwnTicket | RT::Queue  |       27 
|      0 |             0 |
|  837 | Group         |         341 | OwnTicket | RT::Queue  |       28 
|      0 |             0 |
|  899 | Group         |         356 | OwnTicket | RT::Queue  |       28 
|      0 |             0 |
|  849 | Group         |         341 | OwnTicket | RT::Queue  |       29 
|      0 |             0 |
|  863 | Group         |         357 | OwnTicket | RT::Queue  |       29 
|      0 |             0 |
|  924 | Group         |         341 | OwnTicket | RT::Queue  |       30 
|      0 |             0 |
|  911 | Group         |         358 | OwnTicket | RT::Queue  |       30 
|      0 |             0 |
|  887 | Group         |         341 | OwnTicket | RT::Queue  |       31 
|      0 |             0 |
|  874 | Group         |         359 | OwnTicket | RT::Queue  |       31 
|      0 |             0 |
|  937 | Group         |         341 | OwnTicket | RT::Queue  |       32 
|      0 |             0 |
|  949 | Group         |         360 | OwnTicket | RT::Queue  |       32 
|      0 |             0 |
| 4745 | Group         |         385 | OwnTicket | RT::Queue  |       32 
|      0 |             0 |
| 4730 | Group         |          41 | OwnTicket | RT::Queue  |       33 
|      0 |             0 |
|  739 | Group         |         341 | OwnTicket | RT::Queue  |       33 
|      0 |             0 |
|  961 | Group         |         361 | OwnTicket | RT::Queue  |       33 
|      0 |             0 |
|  986 | Group         |         341 | OwnTicket | RT::Queue  |       34 
|      0 |             0 |
|  973 | Group         |         362 | OwnTicket | RT::Queue  |       34 
|      0 |             0 |
| 1011 | Group         |         341 | OwnTicket | RT::Queue  |       35 
|      0 |             0 |
|  998 | Group         |         363 | OwnTicket | RT::Queue  |       35 
|      0 |             0 |
| 1037 | Group         |         341 | OwnTicket | RT::Queue  |       36 
|      0 |             0 |
| 1024 | Group         |         364 | OwnTicket | RT::Queue  |       36 
|      0 |             0 |
| 1050 | Group         |         341 | OwnTicket | RT::Queue  |       37 
|      0 |             0 |
| 1062 | Group         |         365 | OwnTicket | RT::Queue  |       37 
|      0 |             0 |
| 1087 | Group         |         341 | OwnTicket | RT::Queue  |       38 
|      0 |             0 |
| 1074 | Group         |         366 | OwnTicket | RT::Queue  |       38 
|      0 |             0 |
| 1099 | Group         |         341 | OwnTicket | RT::Queue  |       39 
|      0 |             0 |
| 1111 | Group         |         367 | OwnTicket | RT::Queue  |       39 
|      0 |             0 |
| 1136 | Group         |         341 | OwnTicket | RT::Queue  |       40 
|      0 |             0 |
| 1123 | Group         |         368 | OwnTicket | RT::Queue  |       40 
|      0 |             0 |
| 1160 | Group         |         341 | OwnTicket | RT::Queue  |       41 
|      0 |             0 |
| 1148 | Group         |         369 | OwnTicket | RT::Queue  |       41 
|      0 |             0 |
| 1173 | Group         |         341 | OwnTicket | RT::Queue  |       42 
|      0 |             0 |
| 1185 | Group         |         370 | OwnTicket | RT::Queue  |       42 
|      0 |             0 |
| 1209 | Group         |         341 | OwnTicket | RT::Queue  |       43 
|      0 |             0 |
| 1197 | Group         |         371 | OwnTicket | RT::Queue  |       43 
|      0 |             0 |
| 1222 | Group         |         341 | OwnTicket | RT::Queue  |       44 
|      0 |             0 |
| 1234 | Group         |         372 | OwnTicket | RT::Queue  |       44 
|      0 |             0 |
| 1247 | Group         |         341 | OwnTicket | RT::Queue  |       45 
|      0 |             0 |
| 1259 | Group         |         373 | OwnTicket | RT::Queue  |       45 
|      0 |             0 |
| 1284 | Group         |         341 | OwnTicket | RT::Queue  |       46 
|      0 |             0 |
| 1271 | Group         |         374 | OwnTicket | RT::Queue  |       46 
|      0 |             0 |
| 1309 | Group         |         341 | OwnTicket | RT::Queue  |       47 
|      0 |             0 |
| 1296 | Group         |         375 | OwnTicket | RT::Queue  |       47 
|      0 |             0 |
| 1322 | Group         |         341 | OwnTicket | RT::Queue  |       48 
|      0 |             0 |
| 1334 | Group         |         376 | OwnTicket | RT::Queue  |       48 
|      0 |             0 |
| 1347 | Group         |         341 | OwnTicket | RT::Queue  |       49 
|      0 |             0 |
| 1359 | Group         |         377 | OwnTicket | RT::Queue  |       49 
|      0 |             0 |
| 1383 | Group         |         341 | OwnTicket | RT::Queue  |       50 
|      0 |             0 |
| 1371 | Group         |         378 | OwnTicket | RT::Queue  |       50 
|      0 |             0 |
| 1408 | Group         |         341 | OwnTicket | RT::Queue  |       51 
|      0 |             0 |
| 1743 | Group         |         379 | OwnTicket | RT::Queue  |       51 
|      0 |             0 |
| 1433 | Group         |         341 | OwnTicket | RT::Queue  |       52 
|      0 |             0 |
| 1445 | Group         |         380 | OwnTicket | RT::Queue  |       52 
|      0 |             0 |
| 1457 | Group         |         341 | OwnTicket | RT::Queue  |       53 
|      0 |             0 |
| 1469 | Group         |         381 | OwnTicket | RT::Queue  |       53 
|      0 |             0 |
| 1482 | Group         |         341 | OwnTicket | RT::Queue  |       54 
|      0 |             0 |
| 1494 | Group         |         386 | OwnTicket | RT::Queue  |       54 
|      0 |             0 |
| 1543 | Group         |         341 | OwnTicket | RT::Queue  |       55 
|      0 |             0 |
| 1531 | Group         |         382 | OwnTicket | RT::Queue  |       55 
|      0 |             0 |
| 1506 | Group         |         341 | OwnTicket | RT::Queue  |       56 
|      0 |             0 |
| 5038 | Group         |       21708 | OwnTicket | RT::Queue  |       56 
|      0 |             0 |
| 1519 | Group         |         341 | OwnTicket | RT::Queue  |       57 
|      0 |             0 |
| 3089 | Group         |        1568 | OwnTicket | RT::Queue  |       57 
|      0 |             0 |
|  463 | Group         |         383 | OwnTicket | RT::Queue  |       58 
|      0 |             0 |
| 1788 | Group         |         578 | OwnTicket | RT::Queue  |       61 
|      0 |             0 |
| 1825 | Group         |         578 | OwnTicket | RT::Queue  |       62 
|      0 |             0 |
| 1812 | Group         |         580 | OwnTicket | RT::Queue  |       62 
|      0 |             0 |
| 1862 | Group         |         578 | OwnTicket | RT::Queue  |       63 
|      0 |             0 |
| 1837 | Group         |         581 | OwnTicket | RT::Queue  |       63 
|      0 |             0 |
| 1849 | Group         |         582 | OwnTicket | RT::Queue  |       63 
|      0 |             0 |
| 1874 | Group         |         578 | OwnTicket | RT::Queue  |       64 
|      0 |             0 |
| 1911 | Group         |         578 | OwnTicket | RT::Queue  |       65 
|      0 |             0 |
| 1937 | Group         |         578 | OwnTicket | RT::Queue  |       66 
|      0 |             0 |
| 1981 | Group         |         641 | OwnTicket | RT::Queue  |       67 
|      0 |             0 |
| 1968 | Group         |         667 | OwnTicket | RT::Queue  |       67 
|      0 |             0 |
| 1994 | Group         |         641 | OwnTicket | RT::Queue  |       68 
|      0 |             0 |
| 2006 | Group         |         668 | OwnTicket | RT::Queue  |       68 
|      0 |             0 |
| 2021 | Group         |         641 | OwnTicket | RT::Queue  |       69 
|      0 |             0 |
| 2035 | Group         |         669 | OwnTicket | RT::Queue  |       69 
|      0 |             0 |
| 2048 | Group         |         641 | OwnTicket | RT::Queue  |       70 
|      0 |             0 |
| 2105 | Group         |         642 | OwnTicket | RT::Queue  |       70 
|      0 |             0 |
| 2075 | Group         |         641 | OwnTicket | RT::Queue  |       71 
|      0 |             0 |
| 2090 | Group         |         641 | OwnTicket | RT::Queue  |       72 
|      0 |             0 |
| 4953 | Group         |           4 | OwnTicket | RT::Queue  |       73 
|      0 |             0 |
| 2141 | Group         |         578 | OwnTicket | RT::Queue  |       74 
|      0 |             0 |
| 2167 | Group         |         350 | OwnTicket | RT::Queue  |       75 
|      0 |             0 |
| 2154 | Group         |        1008 | OwnTicket | RT::Queue  |       75 
|      0 |             0 |
| 2181 | Group         |         341 | OwnTicket | RT::Queue  |       76 
|      0 |             0 |
| 2193 | Group         |        1055 | OwnTicket | RT::Queue  |       76 
|      0 |             0 |
| 2218 | Group         |        1064 | OwnTicket | RT::Queue  |       77 
|      0 |             0 |
| 2230 | Group         |        1065 | OwnTicket | RT::Queue  |       77 
|      0 |             0 |
| 2255 | Group         |        1064 | OwnTicket | RT::Queue  |       78 
|      0 |             0 |
| 2243 | Group         |        1066 | OwnTicket | RT::Queue  |       78 
|      0 |             0 |
| 2269 | Group         |        1064 | OwnTicket | RT::Queue  |       79 
|      0 |             0 |
| 2281 | Group         |        1067 | OwnTicket | RT::Queue  |       79 
|      0 |             0 |
| 2294 | Group         |        1064 | OwnTicket | RT::Queue  |       80 
|      0 |             0 |
| 2306 | Group         |        1068 | OwnTicket | RT::Queue  |       80 
|      0 |             0 |
| 2330 | Group         |        1064 | OwnTicket | RT::Queue  |       81 
|      0 |             0 |
| 2318 | Group         |        1069 | OwnTicket | RT::Queue  |       81 
|      0 |             0 |
| 2355 | Group         |        1064 | OwnTicket | RT::Queue  |       82 
|      0 |             0 |
| 2342 | Group         |        1070 | OwnTicket | RT::Queue  |       82 
|      0 |             0 |
| 2368 | Group         |        1064 | OwnTicket | RT::Queue  |       83 
|      0 |             0 |
| 2382 | Group         |        1071 | OwnTicket | RT::Queue  |       83 
|      0 |             0 |
| 2395 | Group         |        1064 | OwnTicket | RT::Queue  |       84 
|      0 |             0 |
| 2409 | Group         |        1072 | OwnTicket | RT::Queue  |       84 
|      0 |             0 |
| 2422 | Group         |        1064 | OwnTicket | RT::Queue  |       85 
|      0 |             0 |
| 2436 | Group         |        1064 | OwnTicket | RT::Queue  |       86 
|      0 |             0 |
| 2448 | Group         |        1073 | OwnTicket | RT::Queue  |       86 
|      0 |             0 |
| 2885 | Group         |        1156 | OwnTicket | RT::Queue  |       87 
|      0 |             0 |
| 2897 | Group         |        1157 | OwnTicket | RT::Queue  |       87 
|      0 |             0 |
| 2910 | Group         |        1156 | OwnTicket | RT::Queue  |       88 
|      0 |             0 |
| 2922 | Group         |        1158 | OwnTicket | RT::Queue  |       88 
|      0 |             0 |
| 2949 | Group         |        1156 | OwnTicket | RT::Queue  |       89 
|      0 |             0 |
| 2936 | Group         |        1159 | OwnTicket | RT::Queue  |       89 
|      0 |             0 |
| 2964 | Group         |        1156 | OwnTicket | RT::Queue  |       90 
|      0 |             0 |
| 2976 | Group         |        1160 | OwnTicket | RT::Queue  |       90 
|      0 |             0 |
| 2991 | Group         |        1156 | OwnTicket | RT::Queue  |       91 
|      0 |             0 |
| 3003 | Group         |        1161 | OwnTicket | RT::Queue  |       91 
|      0 |             0 |
| 3032 | Group         |        1156 | OwnTicket | RT::Queue  |       92 
|      0 |             0 |
| 3019 | Group         |        1162 | OwnTicket | RT::Queue  |       92 
|      0 |             0 |
| 3047 | Group         |        1156 | OwnTicket | RT::Queue  |       93 
|      0 |             0 |
| 3059 | Group         |        1163 | OwnTicket | RT::Queue  |       93 
|      0 |             0 |
| 2500 | Group         |        1156 | OwnTicket | RT::Queue  |       94 
|      0 |             0 |
| 2485 | Group         |        1164 | OwnTicket | RT::Queue  |       94 
|      0 |             0 |
| 3074 | Group         |        1156 | OwnTicket | RT::Queue  |       95 
|      0 |             0 |
| 2664 | Group         |        1238 | OwnTicket | RT::Queue  |       96 
|      0 |             0 |
| 2678 | Group         |        1239 | OwnTicket | RT::Queue  |       96 
|      0 |             0 |
| 2720 | Group         |        1238 | OwnTicket | RT::Queue  |       97 
|      0 |             0 |
| 2707 | Group         |        1240 | OwnTicket | RT::Queue  |       97 
|      0 |             0 |
| 2747 | Group         |        1238 | OwnTicket | RT::Queue  |       98 
|      0 |             0 |
| 2734 | Group         |        1241 | OwnTicket | RT::Queue  |       98 
|      0 |             0 |
| 2762 | Group         |        1238 | OwnTicket | RT::Queue  |       99 
|      0 |             0 |
| 2774 | Group         |        1242 | OwnTicket | RT::Queue  |       99 
|      0 |             0 |
| 2787 | Group         |        1238 | OwnTicket | RT::Queue  |      100 
|      0 |             0 |
| 2801 | Group         |        1243 | OwnTicket | RT::Queue  |      100 
|      0 |             0 |
| 2814 | Group         |        1238 | OwnTicket | RT::Queue  |      101 
|      0 |             0 |
| 2826 | Group         |        1244 | OwnTicket | RT::Queue  |      101 
|      0 |             0 |
| 2855 | Group         |        1238 | OwnTicket | RT::Queue  |      102 
|      0 |             0 |
| 2842 | Group         |        1245 | OwnTicket | RT::Queue  |      102 
|      0 |             0 |
| 2637 | Group         |        1238 | OwnTicket | RT::Queue  |      103 
|      0 |             0 |
| 2649 | Group         |        1246 | OwnTicket | RT::Queue  |      103 
|      0 |             0 |
| 2870 | Group         |        1156 | OwnTicket | RT::Queue  |      104 
|      0 |             0 |
| 2691 | Group         |        1238 | OwnTicket | RT::Queue  |      105 
|      0 |             0 |
| 4647 | Group         |        1593 | OwnTicket | RT::Queue  |      106 
|      0 |             0 |
| 3182 | Group         |        1585 | OwnTicket | RT::Queue  |      107 
|      0 |             0 |
| 3194 | Group         |        1587 | OwnTicket | RT::Queue  |      107 
|      0 |             0 |
| 3221 | Group         |        1585 | OwnTicket | RT::Queue  |      108 
|      0 |             0 |
| 3208 | Group         |        1588 | OwnTicket | RT::Queue  |      108 
|      0 |             0 |
| 3248 | Group         |        1589 | OwnTicket | RT::Queue  |      109 
|      0 |             0 |
| 3260 | Group         |        1590 | OwnTicket | RT::Queue  |      110 
|      0 |             0 |
| 3302 | Group         |        1591 | OwnTicket | RT::Queue  |      111 
|      0 |             0 |
| 3316 | Group         |        1592 | OwnTicket | RT::Queue  |      112 
|      0 |             0 |
| 3125 | Group         |        1593 | OwnTicket | RT::Queue  |      113 
|      0 |             0 |
| 3405 | Group         |        1634 | OwnTicket | RT::Queue  |      116 
|      0 |             0 |
| 3392 | Group         |        1635 | OwnTicket | RT::Queue  |      116 
|      0 |             0 |
| 3435 | Group         |        1634 | OwnTicket | RT::Queue  |      117 
|      0 |             0 |
| 3447 | Group         |        1636 | OwnTicket | RT::Queue  |      117 
|      0 |             0 |
| 3462 | Group         |        1634 | OwnTicket | RT::Queue  |      118 
|      0 |             0 |
| 3476 | Group         |        1637 | OwnTicket | RT::Queue  |      118 
|      0 |             0 |
| 3501 | Group         |        1634 | OwnTicket | RT::Queue  |      119 
|      0 |             0 |
| 3488 | Group         |        1638 | OwnTicket | RT::Queue  |      119 
|      0 |             0 |
| 3516 | Group         |        1634 | OwnTicket | RT::Queue  |      120 
|      0 |             0 |
| 3530 | Group         |        1639 | OwnTicket | RT::Queue  |      120 
|      0 |             0 |
| 3555 | Group         |        1634 | OwnTicket | RT::Queue  |      121 
|      0 |             0 |
| 3542 | Group         |        1640 | OwnTicket | RT::Queue  |      121 
|      0 |             0 |
| 3580 | Group         |        1634 | OwnTicket | RT::Queue  |      122 
|      0 |             0 |
| 3568 | Group         |        1641 | OwnTicket | RT::Queue  |      122 
|      0 |             0 |
| 3366 | Group         |        1634 | OwnTicket | RT::Queue  |      123 
|      0 |             0 |
| 3378 | Group         |        1642 | OwnTicket | RT::Queue  |      123 
|      0 |             0 |
| 3600 | Group         |        1634 | OwnTicket | RT::Queue  |      124 
|      0 |             0 |
| 3420 | Group         |        1634 | OwnTicket | RT::Queue  |      125 
|      0 |             0 |
| 3701 | Group         |        1693 | OwnTicket | RT::Queue  |      126 
|      0 |             0 |
| 3685 | Group         |        1694 | OwnTicket | RT::Queue  |      126 
|      0 |             0 |
| 3730 | Group         |        1693 | OwnTicket | RT::Queue  |      127 
|      0 |             0 |
| 3742 | Group         |        1695 | OwnTicket | RT::Queue  |      127 
|      0 |             0 |
| 3770 | Group         |        1693 | OwnTicket | RT::Queue  |      128 
|      0 |             0 |
| 3757 | Group         |        1696 | OwnTicket | RT::Queue  |      128 
|      0 |             0 |
| 3799 | Group         |        1693 | OwnTicket | RT::Queue  |      129 
|      0 |             0 |
| 3811 | Group         |        1697 | OwnTicket | RT::Queue  |      129 
|      0 |             0 |
| 3824 | Group         |        1693 | OwnTicket | RT::Queue  |      130 
|      0 |             0 |
| 3839 | Group         |        1698 | OwnTicket | RT::Queue  |      130 
|      0 |             0 |
| 3867 | Group         |        1693 | OwnTicket | RT::Queue  |      131 
|      0 |             0 |
| 3854 | Group         |        1699 | OwnTicket | RT::Queue  |      131 
|      0 |             0 |
| 3880 | Group         |        1693 | OwnTicket | RT::Queue  |      132 
|      0 |             0 |
| 3892 | Group         |        1700 | OwnTicket | RT::Queue  |      132 
|      0 |             0 |
| 3670 | Group         |        1693 | OwnTicket | RT::Queue  |      133 
|      0 |             0 |
| 3657 | Group         |        1701 | OwnTicket | RT::Queue  |      133 
|      0 |             0 |
| 3908 | Group         |        1693 | OwnTicket | RT::Queue  |      134 
|      0 |             0 |
| 3717 | Group         |        1693 | OwnTicket | RT::Queue  |      135 
|      0 |             0 |
| 4032 | Group         |        2139 | OwnTicket | RT::Queue  |      136 
|      0 |             0 |
| 4045 | Group         |        2139 | OwnTicket | RT::Queue  |      137 
|      0 |             0 |
| 4061 | Group         |        2139 | OwnTicket | RT::Queue  |      138 
|      0 |             0 |
| 4341 | Group         |        2139 | OwnTicket | RT::Queue  |      139 
|      0 |             0 |
| 4093 | Group         |        2139 | OwnTicket | RT::Queue  |      140 
|      0 |             0 |
| 4112 | Group         |        2139 | OwnTicket | RT::Queue  |      141 
|      0 |             0 |
| 4128 | Group         |        2139 | OwnTicket | RT::Queue  |      142 
|      0 |             0 |
| 4016 | Group         |        2139 | OwnTicket | RT::Queue  |      143 
|      0 |             0 |
| 4144 | Group         |        2139 | OwnTicket | RT::Queue  |      144 
|      0 |             0 |
| 4156 | Group         |        2140 | OwnTicket | RT::Queue  |      144 
|      0 |             0 |
| 4325 | Group         |        2139 | OwnTicket | RT::Queue  |      145 
|      0 |             0 |
| 4169 | Group         |        2137 | OwnTicket | RT::Queue  |      146 
|      0 |             0 |
| 4525 | Group         |        3931 | OwnTicket | RT::Queue  |      146 
|      0 |             0 |
| 4185 | Group         |        2137 | OwnTicket | RT::Queue  |      147 
|      0 |             0 |
| 4549 | Group         |        3931 | OwnTicket | RT::Queue  |      147 
|      0 |             0 |
| 4201 | Group         |        2137 | OwnTicket | RT::Queue  |      148 
|      0 |             0 |
| 4354 | Group         |        2137 | OwnTicket | RT::Queue  |      149 
|      0 |             0 |
| 4220 | Group         |        2137 | OwnTicket | RT::Queue  |      150 
|      0 |             0 |
| 4233 | Group         |        2137 | OwnTicket | RT::Queue  |      151 
|      0 |             0 |
| 4249 | Group         |        2137 | OwnTicket | RT::Queue  |      152 
|      0 |             0 |
| 4268 | Group         |        2137 | OwnTicket | RT::Queue  |      153 
|      0 |             0 |
| 4515 | Group         |        3931 | OwnTicket | RT::Queue  |      153 
|      0 |             0 |
| 4492 | Group         |        2134 | OwnTicket | RT::Queue  |      154 
|      0 |             0 |
| 4504 | Group         |        2136 | OwnTicket | RT::Queue  |      154 
|      0 |             0 |
| 4297 | Group         |        2137 | OwnTicket | RT::Queue  |      154 
|      0 |             0 |
| 4312 | Group         |        2138 | OwnTicket | RT::Queue  |      154 
|      0 |             0 |
| 4476 | Group         |        3931 | OwnTicket | RT::Queue  |      154 
|      0 |             0 |
| 4284 | Group         |        2137 | OwnTicket | RT::Queue  |      155 
|      0 |             0 |
| 4537 | Group         |        3931 | OwnTicket | RT::Queue  |      155 
|      0 |             0 |
| 4385 | Group         |         341 | OwnTicket | RT::Queue  |      156 
|      0 |             0 |
| 4372 | Group         |        2283 | OwnTicket | RT::Queue  |      156 
|      0 |             0 |
| 4418 | Group         |         332 | OwnTicket | RT::Queue  |      157 
|      0 |             0 |
| 4405 | Group         |        2560 | OwnTicket | RT::Queue  |      157 
|      0 |             0 |
| 4446 | Group         |         350 | OwnTicket | RT::Queue  |      158 
|      0 |             0 |
| 4433 | Group         |        2561 | OwnTicket | RT::Queue  |      158 
|      0 |             0 |
| 4461 | Group         |        2835 | OwnTicket | RT::Queue  |      159 
|      0 |             0 |
| 4571 | Group         |        4582 | OwnTicket | RT::Queue  |      160 
|      0 |             0 |
| 4582 | Group         |        4583 | OwnTicket | RT::Queue  |      161 
|      0 |             0 |
| 4619 | Group         |        5102 | OwnTicket | RT::Queue  |      162 
|      0 |             0 |
| 4682 | Group         |        1593 | OwnTicket | RT::Queue  |      163 
|      0 |             0 |
| 4696 | Group         |        1593 | OwnTicket | RT::Queue  |      164 
|      0 |             0 |
| 4712 | Group         |        1593 | OwnTicket | RT::Queue  |      165 
|      0 |             0 |
| 4764 | Group         |        6143 | OwnTicket | RT::Queue  |      166 
|      0 |             0 |
| 4827 | Group         |        7946 | OwnTicket | RT::Queue  |      167 
|      0 |             0 |
| 5095 | Group         |        7946 | OwnTicket | RT::Queue  |      168 
|      0 |             0 |
| 4811 | Group         |        7947 | OwnTicket | RT::Queue  |      168 
|      0 |             0 |
| 4792 | Group         |        7948 | OwnTicket | RT::Queue  |      169 
|      0 |             0 |
| 4843 | Group         |        8175 | OwnTicket | RT::Queue  |      170 
|      0 |             0 |
| 4873 | Group         |         341 | OwnTicket | RT::Queue  |      171 
|      0 |             0 |
| 4860 | Group         |        8752 | OwnTicket | RT::Queue  |      171 
|      0 |             0 |
| 4918 | Group         |         341 | OwnTicket | RT::Queue  |      172 
|      0 |             0 |
| 4896 | Group         |       10153 | OwnTicket | RT::Queue  |      172 
|      0 |             0 |
| 4939 | Group         |       11696 | OwnTicket | RT::Queue  |      173 
|      0 |             0 |
| 4976 | Group         |       20811 | OwnTicket | RT::Queue  |      174 
|      0 |             0 |
| 5074 | Group         |         389 | OwnTicket | RT::Queue  |      175 
|      0 |             0 |
| 5052 | Group         |       24040 | OwnTicket | RT::Queue  |      175 
|      0 |             0 |
|    2 | Group         |          11 | OwnTicket | RT::System |        1 
|      0 |             0 |
|  155 | Group         |         389 | OwnTicket | RT::System |        1 
|      0 |             0 |
+------+---------------+-------------+-----------+------------+----------+-------------+---------------+
298 rows in set (0.00 sec)

mysql>

FYI, also getting reports that multiple updates is equally slow. No idea 
why, but its very concerning. I hope its something simple.

Richard


Jesse Vincent wrote:
>
> On Mar 17, 2008, at 8:29 AM, Richard Ellis wrote:
>
>> Hi Guys,
>>
>> I'm seeing the same thing. A lot more users in that dropdown than 
>> should be there.
>>
>
> Richard,
>
> I'd like to help get to the bottom of this.  Can you send the output of:
>
> SELECT * from ACL where RightName = 'OwnTicket'
>
>
>

-- 
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 richard.ellis at Sun.COM
	sun.com

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


More information about the rt-users mailing list