Huge post, but it’s trying to be comprehensive, so it needs to be long. But very interesting. I’m sure there’s (at least) one or two nuggets in there that I’ll be able to use later.
Great post on steps to take (and their particular order) on solving a technical issue in a small company (though it’d work for a large company as well). I’m not sure I completely agree – always worth overlooking code to make sure it’s written as efficiently as possible – but it’s interesting and I especially [...]
Haven’t actually tried this yet, but it’s worth keeping in mind for later.
Whoda thought that combining gay marriage and schema design would lead to an great post?
This is going to make me sound like an old man (OK, right, I am old. So, suck it.), but these two posts alternately scare me and let me know that I’ll have work going into the future as a DB developer. In the first post, Chris Moos describes a problem he’s having with queries [...]
This is awesome! We’ve been having multiple issues with data loads recently. Especially one file we get monthly, which is not very wide (few columns, with small data types), but has over 27 millions rows. Even though our server is now huge, and I split the file into 7M row files, one of the “chunks” [...]
Our tables have gotten large enough that it takes hours to do an alter table. So, this could be a very good thing. It doesn’t relieve any of the issues dealing with the table being locked during this time, but at least we’ll know how much longer it will be locked. Makes me wonder if [...]
It’s an interesting time in the database world. RDBM systems are once again said to be dead. Actually, people have been calling their demise for quite a while (remember object-based db’s anyone?) While I think these general DB systems still have their uses and will be around for quite a while (they’re “not dead yet”), [...]
Despite the title, this post only describes one scenario: that where you need to skip one (or possibly more) queries on the slave in order for replication to restart. Still, this has come in handy recently. Here’s the money section: Just to go sure, we stop the slave: mysql> STOP SLAVE; Fixing the problem is [...]
Here’s some links to guides for installing Oracle on Linux (including OS and Oracle patches needed). It’s not really up to date so some things need to be “winged”, but definitely worth using. Oracle 9i on Red Hat Oracle 10g Also, metalink resource on patches (again OS and db related) for 9i on Red Hat [...]