During all those crashes due to faulty hardware I must have forgotten to fix the mysql database for BlogsNow before I used it. I had to remove som 800K blogs that all had insanly high index ids. Now I am trying to be a good boy and set the auto increment correct via:
alter table blog AUTO_INCREMENT number_here
Just that it seems to take for ever. The temp file and index file grow very erratic since one hour. I will let it cook for a couple of hours, but this looks fishy. 30 million entries should not be that much for mysql …