Sequoia Capital offers insights on surviving the economic downturn. READ MORE

A lot of comments on my last blog. Here is my response

How can I get more details for each SQL statement?
The second argument to dispatch_command is a pointer to the THD structure. It contains all sorts of information. You can dig for all the info you may ever need. Only issue is that we are now dealing with the internal structures and these may change for every release. So the script will not be portable. When I get a few minutes I'd blog a sample but your millage may vary.
A better way to get these structures is using the embedded MySQL DTrace probes. These will expose the info you need. For details on the embedded DTrace probes and example scripts on how to get these details see the discussion thread on OpenSolaris DTrace Discuss Finally the tid was printed to give you some amount of isolation based on connections. Not …

As standard, MySQL allows replication from one master to multiple slaves, and that is a common scale-out scenario, but there have been a few comments recently, and some longer standing queries about having a setup that works the other way round, that is, multiple slaves replicating into a single master.

This a common enough scenario in data logging systems, where the data is collected locally and then distributed up to a central database, or in EPOS (Electronic Point of Sale) systems where you want the transactions logs from the tills logged up to the database at head office. There are many other situations where you want that merging of information.

Although MySQL doesn’t support what is called ‘multiple master, single slave’ solution, you can simulate the general approach by using a combination of replication and federated tables.

Replication allows for different table types on the master (the source of the data) …

Within the APAC region? Planning to attend foss.my (November 8-9 2008)? Why not stay a little longer, for the MySQL for Developers training course - 5 days, from 10-14 November 2008, conducted by my good friends at hSenid (MySQL partners in Malaysia). To register, or find out more, drop Ruchith a quick email at ruchith[at]hsenid[dot]com.

Read Alexis' Adoption Story and, for full details, go to our usual Questionnaire.

Hey everyone, I try to get the magazine out every three months on the 15th. Sometimes life gets in the way. Imagine that! The next issue is looking great and will be out very soon.

Not to early to start thinking about what you want in the next issue. I will be asking for article ideas very soon.

Keith

There’s a Facebook event for OpenSQL Camp. If you RSVP to it, your friends will find out, and that will help spread the word.

Our product historically used an Oracle backend, and after implementing simple date based range partitioning we got a 20-30 time performance increase in our queries. We had used MySQL in other more minor products we had developed, but we couldn’t move to it until partitioning was implemented. In Dec 05 we started to test MySQL partitioning, where partitioning syntax was supported but the optimizations were not in place. As soon as the optimizations were put in, we were able to run a side by side comparison against unpartitioned tables and Oracle partitions. Not only did we get in MySQL a 30+ times performance increase, but the MySQL version ran nearly twice as fast as the same Oracle configuration in a like for like test.

First of all, let me say that I think it's great that you're using MySQL, regardless of the underlying operating system.  What I'm currently  looking at is when might it make sense for MySQL users to give Solaris or OpenSolaris a try.  In that process, something that would be helpful to know is why do so many existing MySQL users deploy on Linux?  Is it familiarity, what's available in their environment, known to work, licensing model, cost, etc?  Do you have other reasons?  I'd like to know. Please share your comments.  Thanks.

Just a quick post that I've moved The FederatedX Storage Engine for MySQL to Launchpad from my Mercurial repository. I'm trying like anything to get a spare moment to work on it-- writing a book takes every spare moment I have. I have made it group accessible and am working with Antony Curtis (who with Arjen encouraged me to get this on LP) on it. So, what I need to do is start a 5.1 compile (it has a problem with latest 5.1) and then give it a test run to see what the problem is. I want to keep this project moving!

The Launchpad page for it is:

https://launchpad.net/federatedx