> 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/ -- ============================ _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com