And we run Now what? :(
Thanks for your inputs LifeinAsia, I think you missed th fact that I said id was a PRIMARY KEY. Let me even add to it and say that it is AutoIncrement.
mysqlcheck -A -c -a -s --use-frm
everyday. Periodically we do ANALYZE as well.
And we run
Now what? :(