I’ll be attending PgEast this year, as I’ve done for the last couple of years, and this year I’ll also be speaking. The topic is query analysis with mk-query-digest. The official description of my talk is as follows:

mk-query-digest is a powerful open-source tool for capturing, filtering, transforming, and aggregating queries, with the ability to do all sorts of other advanced tasks too. By default, it aggregates similar queries together and presents a designed-for-DBAs report with statistics about the most important queries, so you can see where to focus your optimization efforts. This talk shows you how to use mk-query-digest to analyze your Postgres server’s workload.

…

Maatkit does more than just MySQL. I’ve just committed a new version of mk-query-digest, a powerful log analysis tool, with support for Posgtres logs, in both syslog and stderr format. I’m hoping that people will give this a spin in the real world. I have lots of test cases, but that’s never enough; I’m looking for people to crunch their logs and let me know if anything breaks.

A brief tutorial:

# Get it
$ wget http://www.maatkit.org/trunk/mk-query-digest

# Run it
$ perl mk-query-digest --type pglog /path/to/log/file

# Learn about it (search for the string "pglog")
$ perldoc mk-query-digest

I’m going to close comments on this blog post so I don’t get bug reports in the comments. If you have feedback, please post it to the Maatkit mailing list, or …

I’m speaking at the O’Reilly MySQL Conference 2010. I hope I don’t lose my voice, because I have four sessions! Diagnosing and Fixing MySQL Performance Problems EXPLAIN Demystified Read-Write Splitting: Techniques, Challenges, and Solutions MySQL Graphing and Trending with Cacti You can click through on the links above to learn more about each session. I’m also looking forward to the other sessions. Here’s a sample of a few that I have my eye on:

Maatkit does more than just MySQL. I’ve just committed a new version of mk-query-digest, a powerful log analysis tool, with support for Posgtres logs, in both syslog and stderr format. I’m hoping that people will give this a spin in the real world. I have lots of test cases, but that’s never enough; I’m looking for people to crunch their logs and let me know if anything breaks. A brief tutorial:

Understanding MySQL Internals

Understanding MySQL Internals. By Sasha Pachev, O’Reilly 2007. Page count: about 227 pages. (Here’s a link to the publisher’s site).

I should have read this book a long time ago, and it’s my loss that I didn’t. Although the title makes it sound like it should only benefit those who’ll be changing the MySQL server’s own code, that’s not true. To the contrary, at least parts of this book should be required reading for DBAs and developers who use MySQL, after they gain a moderate level of familiarity with how to use the server.

The book does indeed start off …

Are you tired of waiting an hour or so performing a LOAD DATA INFILE statement involving a file with millions of rows?If so, and you have enough money to pay for 3 monthly installments of $5.99... (Belgian chocolate will substitute nicely) -- you TOO can be a hero in your office and go home early for the weekend. :)How? Disable keys. Load data infile. Enable keys.ALTER TABLE

Topics for this podcast:

*Jacobsen v. Katzer and open source impact
*Intel, Nokia team up for MeeGo open source OS
*Open source continues in embedded space
*MongoDB and the advent of the NoSQL databases
*Copyrights, complexities, control and conflict

iTunes or direct download (21:48, 6.07 MB)

drizzle> select * from plugins WHERE PLUGIN_TYPE="storageengine";
+--------------------+---------------+-----------+-------------+
| PLUGIN_NAME        | PLUGIN_TYPE   | IS_ACTIVE | MODULE_NAME |
+--------------------+---------------+-----------+-------------+
| ARCHIVE            | StorageEngine | TRUE      |             |
| BLACKHOLE          | StorageEngine | TRUE      |             |
| CSV                | StorageEngine | TRUE      |             |
| FunctionEngine     | StorageEngine | TRUE      |             |
| INFORMATION_ENGINE | StorageEngine | TRUE      |             |
| InnoDB             | StorageEngine | TRUE      |             |
| MEMORY             | StorageEngine | TRUE      |             |
| MyISAM             | StorageEngine | TRUE      |             |
| schema             | StorageEngine | TRUE      |             |
+--------------------+---------------+-----------+-------------+
9 rows in set (0 sec)

The payoff for making …

You have found the 179th edition of Log Buffer, the weekly review of database blogs. Welcome. Enjoy your stay. We begin with . . .

SQL Server

Merrill Alrich gets going with a fresh juxtaposition–his thoughts on motorcycles and Access. “Many DBAs,” he writes, “have been called in to rescue people, or teams, or projects who have mission critical Access applications gone horribly wrong. It’s very unpleasant, especially the typical discussion we have to have with the Access afficionado . . . ”

Brent Ozar is in on this discussion too. Here he gives his …

The highlights:

Fixed bug where memory loss occured if data was too large.
Added gearman_strerror().
Fixed bug where setting an option off in mass would not trip any triggers on the option (for both worker and client).
Options that are internal can no longer be set by external callers.
Deprecated gearman_client_set_event_watch_fn() and gearman_worker_set_event_watch_fn.
gearman_job_handle() and gearman_job_function_name() now return const char* pointers
gearman_worker_unregister now returns GEARMAN_NO_REGISTERED_FUNCTION if the function does not exist (or is being removed)
Added gearman_worker_function_exist()
Trying to send too large of a piece of data will result in GEARMAN_ARGUMENT_TOO_LARGE.
Added support for gearmand command client to daemonize and create a pid file.
Fixed job handle comparison bug with WORK_FAIL responses.
Fixed disable assert configure …