[rt-users] Severe performance problems suddenly in RT 3.8.2

Tom Lahti toml at bitstatement.net
Tue Feb 17 17:40:57 EST 2009


> Now, I may be being silly here, but how can a table with only 806180  
> id's in its primary key have more than 3 million rows?  And counting  
> them takes three minutes, which really isn't many rows a second...

Is this stored in InnoDB by chance?  If it were me, I would mysqldump all
databases, nuke the back-end InnoDB files and reload from dump.  But that's
just me.

-- 
-- ============================
   Tom Lahti
   BIT Statement LLC

   (425)251-0833 x 117
   http://www.bitstatement.net/
-- ============================



More information about the rt-users mailing list