[rt-users] auto-incremented user id is incrementing wildly

[Sean Perry]

I noticed this shortly after installing RT and forgot about it.  Today's 
talk of SQL optimization had me looking at the database again.

mysql> select id from Users;
+-----+
| id  |
+-----+
|   1 |
|  10 |
|  12 |
|  22 |
|  45 |
|  60 |
| 162 |
| 224 |
| 246 |
| 280 |
| 298 |
| 324 |
| 330 |
| 396 |
| 398 |
| 400 |
| 406 |
| 412 |
| 414 |
| 416 |
| 418 |
| 420 |
| 422 |
| 440 |
| 446 |
| 460 |
| 470 |
+-----+
27 rows in set (0.00 sec)

According to show table status, the next id will be 471.

I have not deleted any users by hand.  Around the jump from 60 to 160 I 
moved from mysql 3 to mysql 4.  This started as rt 3.0.3 and is now rt 
3.0.4 and the move also coincides with the 60 -> 160 jump.  However, you 
will note that even before then the numbers bounced around a bit.