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 …

The replay of the two webinars can now be accesed from mysql.com

Remember that the second part of the webinar will be on March 3rd (details below).

ClusterJ Architecture

MySQL have been working on a new way of accessing MySQL Cluster using Java. Designed for Java developers, the MySQL Cluster Connector for Java implements an easy-to-use and high performance native Java interface and OpenJPA plug-in that maps Java classes to tables stored in the high availability, real-time MySQL Cluster database.

There is a series of 2 webinars coming up, as always these are free to attend – you just need to register in advance:

Part 1: Tuesday, February 16, 2010: 10:00 Pacific …