DBA Lounge

Environment Variables in Grid Control User Defined Metrics

Emerson wrote: “Foolish consistency is the hobgoblin of small minds”. I love this quote, because it allows me to announce a presentation titled “7 Sins of Concurrency” and then show up with only 5. There are places where consistency is indeed foolish, while other times I wish for more consistency. Here is a nice story that illustrates both types of consistency, or lack of.

INFORMATION_SCHEMA tables are case sensitive

I wanted to get examples of some of the extra information that the Percona server has in its INFORMATION_SCHEMA metadata, and in doing so, I stumbled across an interesting MySQL bug/feature/point — INFORMATION_SCHEMA tables (which are actually system views) are case sensitive when used in comparisons:

Using Test::* modules outside of a TAP context

I was happily minding my business today, until I got sight of Tim’s tweet bemoaning the fact that Test::Difference tests can’t easily be used outside of a test harness. Darn him, that’s exactly the kind of happy little puzzle I can’t resist. So I began to think about it. Of course, the Right Solution is probably to add alternative non-TAP-tied functions to the test modules themselves. But what if you just want to quickly leverage the module’s functionality without having to re-arrange its innards? Well, most test modules use Test::Builder, so there’s surely ways to twist that to our advantage. After a hour or two of hacking, I think I got one.

Partial to a picture of your posse in your POD?

If you are, you might like the little greasemonkey script (available on userscript.org and github) that I churned. The script finds the AUTHORS/CONTRIBUTORS section of POD pages on http://search.cpan.org and add Gravatar pictures where it finds author email addresses. The picture on the right is an example of what it does to the main Catalyst CONTRIBUTORS section.

The XLDB4 Conference for Very Large Databases

For the 4th Extremely Large Databases Conference. I am interested in any MySQL folks planning to attend (I would expect Tokutek to be represented, and maybe even the Calpont folks). Most of this is directly from an e-mail I received from Jacek Becla, who had a keynote at the 2008 MySQL User Conference and Expo. If you also received this e-mail, please feel free to skip ahead to my viewpoints on the various Oracle conferences (or just skip altogether).

XPathScript Reborn

A little hacking happened to decouple the core engine from its Apache roots, and XML::XPathScript was born. That module served me quite well throughout the years, but for some time now I’ve had this plan of doing a clean rewrite patiently sitting on my back-burner. This week I had a smashing staycation, and thanks to a very understanding wife, I was able to indulge in the necessary hacking sessions to get the ground work done. The result is not on CPAN yet, but can be perused on GitHub. As an example is worth a thousand pages of documentation, let’s say that you want to turn the piece of docbook-ish xml

It’s the End of the World As We Know It (NoSQL Edition)

I think Michael Stonebraker overshot the target In a 2007 paper titled, “The End of an Architectural Era”. Why is this The End? According to Michael Stonebraker “current RDBMS code lines, while attempting to be ‘one size fits all’ solution, in face, excel at nothing. Hence, they are 25 years old legacy code lines that should be retired in favor of a collection of ‘from scratch’ specialized engined”.

Beware the /var/tmp/.oracle Hidden Directory!

A few months ago, we had a test instance complaining that it couldn’t write to ASM. This was an single (non-RAC) instance on Oracle Enterprise Linux 5, using ASM for the storage.We ended up booting the server altogether, after which everything came up nicely. We filed an SR with Oracle Support, who directed us to Note 391790.1 (Unable To Connect To Cluster Manager Ora-29701). This note lists the cause, quite simply, as…

Shuck & Awe #7: Hunting for Perl

No one is safe from the TPF Inquisition. Alberto Simões cornered Michael Schwern at YAPC and exacted a confession about the state of Test::Builder 2. No doubt threatened by the horrid torments that only torture by the comfy chair can provide, the Schwern spilled the beans.

Page 28 of 67« First...1020...2627282930...405060...Last »