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 …

2009 Boston MySQL User Group Videos:

Dec 2009 - Time Zones in MySQL (Sheeri K. Cabral) - video - PDF presentation - Description

Nov 2009 - How InnoDB works: Exploring SHOW ENGINE INNODB STATUS (Sheeri K. Cabral) - video - PDF presentation - Description

read more

What tool should I use to develop small MySQL end user applications on my Mac?

Let me start by saying that I don’t know the answer, and I’m looking for your guidance. To make my question more specific, let me describe my background and what I want.

I started my professional career in the 1980s as a developer using a tool called FOCUS by Information Builders. Terminology was different in those times. Focus was “a hierarchical database” and a “4GL“, which stood for “Fourth generation programming language“. Presumably, 4GLs saved lots of development time over the third generation, which wasn’t just COBOL (no, I never wrote a line of that) but …

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.