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.
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.
My co-worker sent me a link to a new MySQL database administrator app call Sequel Pro. It’s free for Mac OS X. I’ve been using it for about two weeks now and it has now replaced phpMyAdmin and MySQL Query Browser as my primary database application. It is a native OS X app. It’s so easy to use, very fast and the interface is great.
Today I needed to set up a full text searching system at work. Full text searching is basically searching a set of text fields/columns based on a search term and the results are sorted based on relevance. It is very handy for searching articles and such where there is a lot of text to search through. It is also much faster and more accurate than doing wildcard searches with the LIKE command.