Tip : Check SQL Index Fragmentation
 

Just noticed while doing some spring cleaning in the site's database that a lot of our most used tables had 70% + fragmentation on their indexes.

Made sure to rebuild and reorganize all of them, and they're now sitting around 0-.1% fragmented.

Our DB is in SQL Server, but should apply to you MYSQL guys as well.

Pretty interesting that I believe our site is pretty optimized, but you can still stumble upon something like this :mad:

optimization is never over.

Optimize....

Then the host has a network issue... LOL

how do you do that on a wordpress without fucking up the db?

login at phpmyadmin -> select all database -> select all tables -> select optimize from drop down list -> confirm

you're done

LOL, that makes it too easy :thumbsup