 |
Open Query blogAbout MySQL, Drizzle, MariaDB and more! |
You take a look at someone’s MySQL (or MariaDB) data directory, and see mysql foo bar -> foo What’s the issue? Identify pattern. What does it mean? Consequences. Is there any way it can be safe and useful/usable? Describe. Good luck!
|
Filed under: Good practice / Bad practice |
by arjen Social tagging: database > datadir > mariadb > mysql > symbolic link > symlink
3 Comments »
What’s the difference between INT(2) and INT(20) ? Not a lot. It’s about output formatting, which you’ll never encounter when talking with the server through an API (like you do from most app languages). The confusion stems from the fact that with CHAR(n) and VARCHAR(n), the (n) signifies the length or maximum length of that [...]
|
Filed under: Good practice / Bad practice |
by arjen Social tagging: birthdate > data types > database > date-of-birth > int > integer > mariadb > mysql > year
No Comments »
The linux.conf.au organisers have given all miniconfs an additional few weeks to spruik for more proposal submissions, huzzah! So if you didn’t submit a proposal because you weren’t sure whether you’d be able to attend LCA2010, you now have until October 23 to convince your boss to send you and get your proposal in.
|
Filed under: Conferences |
by cafuego Social tagging: best conference in the world > community > conference > contribute > database > filesystem > lca2010 > linux > linux.conf.au > memcache > mysql > opensolaris > raid > sql > storage > zfs
No Comments »
Since you were going to linux.conf.au 2010 in Wellington, NZ anyway in January of next year, you should submit a proposal to speak at the data storage and retrieval miniconf. If you have something to say about storage hardware, file systems, raid, lvm, databases or anything else linux or open source and storage related, please [...]
|
Filed under: Conferences |
by cafuego Social tagging: best conference in the world > community > contribute > database > filesystem > linux > linux.conf.au > memcache > opensolaris > raid > sql > storage
No Comments »
The Daily WTF collects excellent tales from the real world. These days, the dismal dramatic sagas are often (at least in part) about mistakes involving databases; no surprise there, they’re so prolific… Anyway, if you can learn from other people’s mistakes, that’s cheap and efficient education! I thought I’d share today’s edition with you: it’s called [...]
|
Filed under: Uncategorized |
by arjen Social tagging: daily > database > delete > good habits > mysql > prevention > WTF
1 Comment »