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.
In my first post, , about piping email with PHP, I detailed how to set up qmail to send an email to a PHP script, read the email, output it. Now that you have the basics down, we can get into more email processing with PHP.
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.
Wow long time no post. I’ve been pretty busy with work and freelance stuff but I’m hoping to get back into posting again.
Well my employer had their site mirrored by d3stroy.com the other day. My coworker and I had the task of staying late and figuring out what they did.
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.