I am happy to announce that there now is a MySQL User Group in Los Angeles, California! Their first meetup will take place on Nov. 19th at 7:30pm, Carl Gelbart will give a presentation about "Infobright, an Open Source Data Warehouse". The location has not been finalized yet, it seems: Sun offered them to choose between one of their locations in Universal City, El Segundo or Irvine. Thanks a lot to Joe Devon for stepping up and volunteering to organize this group, it's appreciated!

And if you are not able to join the LA MySQL User Group because you live somewhere else - take a look at http://mysql.meetup.com/ for a local MySQL User Group in your area! If there isn't one yet, have you …

I am happy to announce that there now is a MySQL User Group in Los Angeles, California! Their first meetup will take place on Nov. 19th at 7:30pm, Carl Gelbart will give a presentation about "Infobright, an Open Source Data Warehouse". The location has not been finalized yet, it seems: Sun offered them to choose between one of their locations in Universal City, El Segundo or Irvine. Thanks a lot to Joe Devon for stepping up and volunteering to organize this group, it's appreciated!

And if you are not able to join the LA MySQL User Group because you live somewhere else - take a look at http://mysql.meetup.com/ for a local MySQL User Group in your area! If there isn't one yet, have you …

Dear Italian MySQLlers,

join us for two new webinars on High Availability and Scalability and on the upcoming MySQL Enterprise Fall Release. All details here: http://www-it.mysql.com/news-and-events/web-seminars/

In the first one on November the 13th we will explore various MySQL high availability technologies and architectures. We will explore the uses cases for when to implement MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD) and other high-availability technologies.

Join us on December the 9th to see how the MySQL Query Analyzer, a new feature to the MySQL Enterprise Monitor, helps keep your key MySQL systems up and running at the highest levels of scalability and performance by helping you analyze your most expensive application and user queries by total executions, total run time, total data …

I know that this is well documented in many places on the web, but one of the comments that I saw to an earlier blog post was around installing MySQL via OpenSolaris.  David Comay provided some answers in the comments, which I thought that I would reiterate here.  This works for OpenSolaris 2008.05.

With a one line command, you can install MySQL:

pfexec pkg install SUNWmysql5

If you are looking for the entire AMP stack, you can install Apache, MySQL, and PHP using the command:

pfexec pkg install amp

And, if you are looking for the entire AMP stack with developer tools, use the following command:

pfexec pkg install amp-dev

Note that pfexec will allows you to run a privileged command as a non-root user provided that you have the authorization to do so.


The software that is installed with the commands above is placed in …

My colleague, Tom Daly, just submitted results for SPECj that showcases a compelling price / performance story with Glassfish, MySQL 5.0, and OpenSolaris on commodity Sun Intel hardware.  See the full details here.

Recently, a bug that caused excessive memory usage and slowness (specially in large models) in Workbench has been fixed in its canvas. From the testing I’ve done, the speed for displaying diagrams seems to scale much better and dragging around tables in large models is doable in an acceptable speed. This fix is in the upcoming releases of the 5.0 and 5.1 alpha versions of Workbench.

Apart from that, we’ve been doing some work on reintroducing OpenGL support to the Workbench canvas. Unlike the initial implementation, this time OpenGL is used directly instead of going through Cairo’s experimental (and not quite reliable) support through the Glitz layer. This means that in machines with a recent graphics card, hardware acceleration will be used and working with large diagrams will be a lot smoother and faster. Of course, software rendering backends (GDI+, Quartz and Xlib) will still be supported and used in case OpenGL is not the best …

Dear Italian MySQLlers,

join us for two new webinars on High Availability and Scalability and on the upcoming MySQL Enterprise Fall Release. All details here: http://www-it.mysql.com/news-and-events/web-seminars/

In the first one on November the 13th we will explore various MySQL high availability technologies and architectures. We will explore the uses cases for when to implement MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD) and other high-availability technologies.

Join us on December the 9th to see how the MySQL Query Analyzer, a new feature to the MySQL Enterprise Monitor, helps keep your key MySQL systems up and running at the highest levels of scalability and performance by helping you analyze your most expensive application and user queries by total executions, total run time, total data …

Dear Italian MySQLlers,

join us for two new webinars on High Availability and Scalability and on the upcoming MySQL Enterprise Fall Release. All details here: http://www-it.mysql.com/news-and-events/web-seminars/

In the first one on November the 13th we will explore various MySQL high availability technologies and architectures. We will explore the uses cases for when to implement MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD) and other high-availability technologies.

Join us on December the 9th to see how the MySQL Query Analyzer, a new feature to the MySQL Enterprise Monitor, helps keep your key MySQL systems up and running at the highest levels of scalability and performance by helping you analyze your most expensive application and user queries by total executions, total run time, total data …

Everyone does backups. Usually it’s some nightly batch job that just dumps all MySQL tables into a text file or ordinarily copies the binary files from the data directory to a safe location. Obviously both ways involve much more complex operations than it would seem by my last sentence, but it is not important right now. Either way the data is out and ready to save someone’s life (or job at least). Unfortunately taking backup does not come free of any cost. On the contrary, it’s more like doing very heavy queries against each table in the database when mysqldump is used or reading a lot of data when copying physical files, so the price may actually be rather high. And the more effectively the server resources are utilized, the more that becomes a problem.

What happens when you try to get all the data?

The most obvious answer is that it needs to be read, through I/O requests, from a storage that it resides on. The storage is …

Starting with version 5.1.28, there is a new table INFORMATION_SCHEMA.PROFILING and a new statement SHOW PROFILE(S). Basic information is in the reference manual and in an introductory article. But I don’t think that’s adequate for everyone. I’ll try here to give some non-basic information. I’ll assume that you read the manual, think of this as a supplement.

A bit of a caveat: I was totally against adding this feature, and some of my bias might show. But I’m not trying to argue about it. I do believe that once we add a feature we should explain it, and all I’m trying to do is explain here.

How it works

The data-gathering code, or “instrumentation”, goes approximately like this:
statement_begin:
…