David Coveney from interconnectit.com has written an excellent tutorial of how to use MySQL Workbench with XAMPP, a very nice bundle of Apache, MySQL, PHP and Perl. If you are running XAMPP or what to give it a try, make sure to check out his tutorial that describes how to set the correct MySQL Server Instance profile parameters.

This tutorial is also a good resource for people who do not use a default installation of MySQL and need to manually adjust their MySQL Server Instance profile parameters in order to make their setup work with MySQL Workbench. Default installations should work out of the box of course.

Please find the tutorial here: …

I may sound like a broken record, but currently we have only three MySQL University sessions scheduled for this year. In 2009, we ran more than 25 sessions, and I'd surely like to get anywhere near that figure.

Anyone who has something technical to say about MySQL qualifies as a speaker. MySQL University sessions take place on Thursday afternoons European time, and normally have between 20 and 30 attendees, but quite a lot of people listen to the recordings when the live sessions' time isn't convenient for them. We're using Dimdim as our conferencing system, so the setup for speakers is very simple: Just grab a headset, start a Flash-enabled browser on either Windows, Mac OS X, Linux, or Solaris, perform a 10-minute test with the MySQL University host, and you're ready for the live session. Everything …

I may sound like a broken record, but currently we have only three MySQL University sessions scheduled for this year. In 2009, we ran more than 25 sessions, and I'd surely like to get anywhere near that figure.

Anyone who has something technical to say about MySQL qualifies as a speaker. MySQL University sessions take place on Thursday afternoons European time, and normally have between 20 and 30 attendees, but quite a lot of people listen to the recordings when the live sessions' time isn't convenient for them. We're using Dimdim as our conferencing system, so the setup for speakers is very simple: Just grab a headset, start a Flash-enabled browser on either Windows, Mac OS X, Linux, or Solaris, perform a 10-minute test with the MySQL University host, and you're ready for the live session. Everything …

After a nice long vacation, it's time to unveil our destinations for public classes in 2010.  We are now offering a course for Developers as well as DBAs.  The dates are:

• Seattle 16 February
• San Francisco 18-19 February
• Boston 22-23 February
• New York City 25-26 February
• Montréal …

I had some free time over Thanksgiving so I decided to work on something I have been thinking about for quite some time. I hacked up Google’s show table_statistics patch to also track stats per connection. I say this is a first draft hack because I based it off of the v2 patch which uses a straight up hash table instead of the intermediate object cache.

I’ve added the global/session key word to the existing show table_statistics command in the same way that show status works. This means that the default behavior of show table_statistics is to show session data instead of global data. This is different from the Google patch which only works globally. This has been running in production environments for a bit and seems stable. Note that these environments don’t run at the concurrency that motivated Google to update the patch to be less likely to lock a global mutex. You have been warned!

I’m planning on updating the patch with …

Finland-based Aito Technologies, developer of a customer experience analytics product suite, today announced its plans to employ Sun Microsystems’ MySQL Embedded Database Server software to successfully analyze up to billions of phone calls, text messages, and mobile data sessions on a daily basis.

Get it Done with MySQL 5&6 Get it Done with MySQL 5&6. By Peter Brawley and Arthur Fuller. Self-published, 2009. Page count: about 615 pages. I asked the authors for a print edition to review, but it is also available as an e-book. The right word to describe this book falls somewhere between “tome” and “lunker.” You could beat back an unwelcome salesperson with it. You could also beat back any number of stubborn database problems.

CMON - the Cluster Monitor has recently been released and here is a little how to about how to install from binary and source (at the end), deployment etc.

1. Download the cmon binary package to a monitoring host
Currently there are binaries available for Linux 64-bit and 32-bit (statically linked) and works for MySQL Cluster 7.0.9 and later.

In this case the monitoring host will be on 'ndb05' (IP address 10.0.1.5) - see 9. Suggested Deployment for a picture describing the setup.

The Monitoring machine should have installed:

• a mysql server up and running that will store the cmon database (if you build from source you need to have the mysql cluster libraries and include files)
• apache (if you want to have the web interface) + php_mysql
• rrdtool (if you want to have graphs in web interface)
…

Your site is getting awfully slow? There's just to much reads to your database and you have already tweaked the performance of every query? In most cases data caching is the solution to your problem!

The idea is to cache all processed data you heave retrieved from the database. Let us look on a example. It uses a mockup class that basically can handle any caching system like memcached or xcache

I’ve talked about PERFORMANCE_SCHEMA in the past - almost a year ago now.

Back then the feature was just coming together in to something useable, and was on the cusp of moving towards code review. It entered code review, and went around, and around for 9 months, whilst various refinements were made.

Never the less, Marc Alff persevered (much respect!), and yesterday pushed his final merge in to the mysql-next-mr bzr tree. PERFORMANCE_SCHEMA is now awaiting the next milestone release, and will be a part of the next GA release of MySQL!

We have the initial documentation ready:

http://dev.mysql.com/doc/performance-schema/en/index.html

This first round adds the infrastructure to take monitoring of the MySQL Server to the …