One of my hobbies that has taken a good bit of time lately has been to revamp my photo album. I originally wrote it a few years ago and, while it has served its purpose well, it lacks some features that I would like to see and represents less than ideal design decisions. This time around I have started from the ground up and, as a result, have the opportunity to apply some of the things I have learned n the past two years. For instance, this time around, all my main tables will be using InnoDB (or another transactional engine depending on when I finish the dern thing :) completely with foreign keys and, of course, making use of transactions where possible.

Recently while working on my little project, I discovered the value of TRADITIONAL. I am referring, of course, to to the SQL mode setting in MySQL that makes it behave more like, well, a "traditional" database. I tend to think of that as both somewhat unfair and vague. It might be …

I honestly do not know why somebody would want to export each record from a table in to its’ own files in a csv format. I am sure people have their own reasons. But since I got request from couple people, I figure I would post a solution here. Same script can be used to dump the whole table in to one csv file as well, with little tweaking. I will start with creating database with a table. I then insert three rows with test data into the table just to show three separate files creation.

mysql> CREATE DATABASE testdump;
mysql> USE testdump
mysql> CREATE TABLE `testtable` (
`id` TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`testfield` VARCHAR( 15 ) NOT NULL ,
`testfield2` VARCHAR( 15 ) NOT NULL
) ENGINE = innodb COMMENT = 'test table for dumping each row to file';
mysql> INSERT INTO `testtable` values ('','test1','test2'),('','test3','test4'),('','test5','test6'); …

One of my hobbies that has taken a good bit of time lately has been to revamp my photo album. I originally wrote it a few years ago and, while it has served its purpose well, it lacks some features that I would like to see and represents less than ideal design decisions. This time around I have started from the ground up and, as a result, have the opportunity to apply some of the things I have learned n the past two years. For instance, this time around, all my main tables will be using InnoDB (or another transactional engine depending on when I finish the dern thing :) completely with foreign keys and, of course, making use of transactions where possible.

Recently while working on my little project, I discovered the value of TRADITIONAL. I am referring, of course, to to the SQL mode setting in MySQL that makes it behave more like, well, a "traditional" database. I tend to think of that as both somewhat unfair and vague. It might be …

I have updated the Forge page for the External Language Stored Procedures, adding a PDF for the slides used in the presentation and a link to a video of the presentation for those people who missed it. It was quite unfortunate that at the Conference, there were two presentations occurring at the same time which discussed the topic of UDF/Stored Procedures so I am sure that there are people who

Previously.
As usual, hit up the homepage for the latest and greatest downloads. Or simply 'git pull' and use the tag release-6 if you're cool enough.

I'd like to use this post to explain in a more general fashion about what DPM is and why it's different from the rest of the proxies.

First, milestones since R5:
- BSD licensed. You are now free to roam about the cabin.
- Several C level bugs fixed.
- Many improvements to the lua library dpml.lua
- All of the demos were rewritten using dpml.lua, and are now far easier to use.

Now, what is DPM?
- It's a proxy for MySQL. It is event driven, embeds lua, and is written in C. It allows you to write plugins in lua, and …

Previously.
As usual, hit up the homepage for the latest and greatest downloads. Or simply 'git pull' and use the tag release-6 if you're cool enough.

I'd like to use this post to explain in a more general fashion about what DPM is and why it's different from the rest of the proxies.

First, milestones since R5:
- BSD licensed. You are now free to roam about the cabin.
- Several C level bugs fixed.
- Many improvements to the lua library dpml.lua
- All of the demos were rewritten using dpml.lua, and are now far easier to use.

Now, what is DPM?
- It's a proxy for MySQL. It is event driven, embeds lua, and is written in C. It allows you to write plugins in lua, and …

Work on the next generation of MySQL Database Administrator Exams has started and it raises the question of 'What does a DBA actually do?

The vivacious Sheeri Kritzer Cabral had a list of Best Practices for Database Administrators that is a good starting point. A lot of the items she lists are hard to quantify, especially for someone who has to write performance reviews and make salary increase recommendations.

I used to work for a program manager who was very good at managing developers by the numbers of lines of code generated, bugs fixed, and number of hours spent in the little gray cubicles. DBA work is not as easy to quantify. It was frustrating for both of us as there was no discrete output to log, report and graph. And how can examining buffer cache hits rates be valued by an employer in comparison to someone putting …

Here's one for you... imagine you have a properly normalised schema, but you need to output it to CSV for a spreadsheet. So, you have multiple attributes for each item. The number of items is larger than the max # of joins (61) that you can do in MySQL. How to do this in a single query?