mysql

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 …

Leave a Reply

You must be logged in to post a comment.