The headline above has two parts: 1) some letters 2) a question mark. The question mark is the important thing here! It resolves to:

* Can we debug stored programs in MySQL?
* Do you debug stored programs in MySQL?
* How do you debug stored programs in MySQL?

We have tried, but we gave up! In the early stages of our IssueBurner application we actually used Stored Procedures quite a lot. As the complexity increased debugging became so tedious that we recoded the application ‘the traditional way’ coding the logic in the application code instead.

In simple cases you may of course add a little debugging code that writes some data to user variables, temporary tables etc. Next remove them or comment them when you want to turn debugging off. If you want to work more …

Percona just released their MySQL PAM Authentication insanity, just as Oracle did before, for MySQL 5.5 and MariaDB is no better.

The Oracle module requires a module to be loaded into your client, which is done automatically if the module is present and the server supports PAM auth. The module is called ominously "mysql_clear_password" and does what it says on the tin: Your database server access password is henceforth sent from the client to the server in clear, not encrypted, hashed, salted or otherwise protected.

I suppose the Percona module does the same, although it is not being mentioned in the docs at all (or at least I have not …

Dumb question to follow last comment: how do you see I/O on the slave thread? That’s a great prefetch metric.

I’m researching algorithms for automatic fault detection in MySQL (see my previous post for context). I need real-world data samples to test the algorithm. Can you help by sending me a bit of data from your production server? The end goal is an open-source tool that will be a standard part of a typical MySQL installation. The problem I’m trying to solve for all MySQL users is this: something went wrong, what was it?

Installing Apache2 With PHP5 And MySQL Support On CentOS 5.7 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 5.7 server with PHP5 support (mod_php) and MySQL support.

At next month’s Boston MySQL Meetup, I will give a talk: “Fractal Tree Indexes – Theoretical Overview and Customer Use Cases.” The meetup is 7 pm Monday, January 9th, 2012, and will be held at MIT Building E51 Room 337e (corner of Ames & Amherst St, Cambridge, MA). Thanks to host Sheeri Cabral for the invitation.

Most databases employ B-trees to achieve a good tradeoff between the ability to update data quickly and to search it quickly. It turns out that B-trees are far from the optimum in this tradeoff space. …

Oracle Releases "MySQL: A guide to High Availability Solutions". There are several commonly accepted requirements in order to be called a "Guide" such as be informative and attempt to include all of the solutions available.

Oracle's so-called Guide missed all of the above it failed to include:

1. Continuent Tungsten HA
2. Schooner Replication
3. Red Hat Cluster
4. VCS
5. Percona MMM
6. DRBD

But the so-called Guide did not stop there, "The Guide" also miserably fails to even attempt to be informative. It briefly describes solutions already widely known such as replications and MySQL Cluster - Wooo Hoo we have known about those some some time now ...ahhh nearly a decade.

Instead the guide goes into page filling "blah...blah" about causes of failures and meaningless charts. No mention about the best practices or even practical approach to HA.
…

OSSCube, co-organizer of OSI Days, thanks all of you for making OSI Days, 2011 such a success. We are delighted that this 8th version of Asia’s mega convention, held at Bengaluru on Nov 20-22, 2011, is one of the best OSI Days events we have had...! Over 2,000 people and 100+ sessions across three days and that’s the proof that the event was greatly accepted by open source enthusiasts.

This year the conference had a very good feel with varied interesting, exciting sessions and workshops.  Hope, attendees would not find conflicted over which session to attend, as there were too many interesting topics running simultaneously!

The conference snarled from OSI, PHP, Kernel to Data Days in three Audis and 3 MRs aimed with providing quality content and empowering the open source lovers. There were discussions from FOSS for everyone, Open Source for developers to Open Source for …

OSSCube, co-organizer of OSI Days, thanks all of you for making OSI Days, 2011 such a success. We are delighted that this 8th version of Asia’s mega convention, held at Bengaluru on Nov 20-22, 2011, is one of the best OSI Days events we have had...! Over 2,000 people and 100+ sessions across three days and that’s the proof that the event was greatly accepted by open source enthusiasts.

This year the conference had a very good feel with varied interesting, exciting sessions and workshops.  Hope, attendees would not find conflicted over which session to attend, as there were too many interesting topics running simultaneously!

The conference snarled from OSI, PHP, Kernel to Data Days in three Audis and 3 MRs aimed with providing quality content and empowering the open source lovers. There were discussions from FOSS for everyone, Open Source for developers to Open Source for …

It is finally ready! The training course at least I have been waiting for since we started the company: A MySQL training course for Developers.  And this is not just another standard MySQL for Developers training course. Based on our previous experiences at MySQL AB, we wanted to create something different, with a better fit. We wanted to aim this MySQL training course more at developers who already have experience using SQL and MySQL instead of just focusing on teaching SQL basics. Sure, we still cover the SQL basics, however it's done quickly.  We focus more on the MySQL exceptions and how to optimize SQL on MySQL.  As a result, entire chapters are dedicated to query optimization in MySQL, choosing storage engines, replication and other things often related more to a DBA role, that we deemed to be important for an advanced MySQL developer. We have also added a large section focusing on solving complex problems with …