what is the size of the total of your .MYI files? 8000 users should prolly generate a lot of posts..

phpmyadmin can tell you the size of that (indices overhead)