MySQL Query Analyzer is already helping people to drastically improve their application performance. 

Jeff Freund (CTO, Clickability) shares an interesting use case.

MySQL Query Analyzer is already helping people to drastically improve their application performance. 

Jeff Freund (CTO, Clickability) shares an interesting use case.

Last weekend I attended the OpenSQL Camp in Charlottesville, VA. There was a great turnout, and Baron did an excellent job organizing it! I saw a few folks I met at OSCON over the summer, along with meeting many new people. What a great group - intelligent, fun, and know how to get things done. I had some great conversations, especially with Brian, Stewart, Arjen, Patrick, Mark, and Jay. The food was great too, I was a bit worried about …

One of the new features in the new release of MySQL Enterprise Monitor is Query Analyzer. As the name suggests, the Query Analyzer provides information about the queries that are running on your server, the response times and row and byte statistics. The information provided is great, and it doesn’t take very long to see from the query data supplied that there are places where you could improve the the query, or even reduce the number of queries that you submit.

The system works by using the functionality of the MySQL Proxy to monitor the queries being executed and then provide that information up to the MySQL Enterprise Service Manager so that the information can be displayed within the Query Analyzer page. To get the queries monitored, you have to send the queries through the agent which both monitors their execution and sends the information on up to the Manager, along with all the other data being monitored.

The team, …

At the European Customer Conference a couple of weeks back, one of the topics was the use of DRBD. DRBD is a kernel-based block device that replicates the data blocks of a device from one machine to another. The documentation I developed for that and MySQL is available here.

Fundamentally, with DRBD, you set up a physical device, configure DRBD on top of that, and write to the DRBD device. In the background, on the primary, the DRBD device writes the data to the physical disk and replicates those changed blocks to the seconday, which in turn writes the data to it’s physical device. The result is a block level copy of the source data. In an HA solution, which means that you can switch over from your primary host to your secondary host in the event of system failure and be sure pretty certain that the data on the primary and seconday are the same.

…

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 …

The New Sun Microsystems  announced a new Glassfish/MySQL/OpenSolaris SPECjAppServer2004 result today. The  real highlight is that all software used in this benchmark is all Open Source Software. It is  a win for Open Source Software including Open Source Databases like PostgreSQL and MySQL. We need more of such benchmarks to highlight the exorbitant prices charged by Proprietary Database & other Software Vendors who charge and force customers to give them all their major dollars of their IT budget.

Tom Daly's blog entry highlight that in terms of Price/Performance, the proprietary database vendors who  conveniently also happen to be the …

Few months ago I’ve switched one of our internal projects from doing synchronous database saves of analytics data to an asynchronous processing using starling + a pool of workers. This was the day when I really understood the power of specialized queue servers. I was using database (mostly, MySQL) for this kind of tasks for years and sometimes (especially under a highly concurrent load) it worked not so fast… Few times I worked with some queue servers, but those were either some small tasks or I didn’t have a time to really get the idea, that specialized queue servers were created just to do these tasks quickly and efficiently.

All this time (few months now) I was using starling noticed really bad thing in how it works: if workers die (really die, or lock on something for a long time, or just start lagging) …

You may know that I created a SQL Reserved Keywords Checker a few years ago. I was just noticing today that a lot of people are searching for the same keywords. Here's a list of the top 10 keywords people searched for using the tool in the past year:.