[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