Archive for October, 2007
Wednesday, October 31st, 2007
We were using replication to deal with certain queries that were producing table scans. I realize this is not a great long term solution but we were migrating a web site that was set up this way, so it wasn't really a choice.
We had a database that was a ...
Posted in mysql, replication | No Comments »
Friday, October 12th, 2007
I'm migrating a PHP 4 site right now. It makes me realize how far PHP has come in the last few years.
I ran across a weird bug where code was working on our dev server, but not production. I was getting the error:
session_start(): Failed to initialize storage ...
Posted in php | No Comments »
Thursday, October 11th, 2007
MySQL query cache can be useful, if it works. Here's how to check it's effectiveness.
show status like 'qc%';
+-------------------------+----------+
| Variable_name | Value |
+-------------------------+----------+
| Qcache_free_blocks | 6407 |
| ...
Posted in mysql | No Comments »
Tuesday, October 2nd, 2007
I'll keep this short. Please, stop trying to be clever. I'm talking to you, mediocre developer. I realized you think it's awesome to use a different file extension, like .awesome. It's not. You're really not accomplishing anything. If your excuse if that you don't ...
Posted in rant | 1 Comment »