MySQL: Optimize your Primary Key

Lately I’ve been reading a lot about MySQL optimization and fine tuning. The other day I read a good tip about the size of your primary key. It will definitely save you space as your tables get bigger.

Read more

MySQL: Database Optimization with MySQLTuner

At work, we ran into some MySQL max connections issues that were bringing down our entire site. One highly used table was corrupted which was making all the queries lock, idle or sleep. This would lead to max connections being hit and our whole site going down. We asked our provider to look into it and they turned us on a really cool MySQL optimizer script.
Read more