So the good news is that the inaugural OpenSQL Camp is going to be an awesome event with mouth watering sessions by noted experts. The bad news (for me) is that I won't be attending it, which makes me sad. I cannot leave my town because my wife can go into labor anytime now.

The session list looks great! Congratulations and thanks to Baron, Sheeri, Ronald, all the sponsors and contributors for organizing the first OpenSQL Camp.

I will be watching PlanetMySQL closely for juicy blog posts. Hopefully, the one and only Sheeri is taking her camcorder!

Are you interested in testing your Solaris application with MySQL, but don't have the time or resources to setup an environment locally?  Today, Dan Powers reminded me that Sun has made it easy to get pre-configured environments.  The first is via the EZQual Virtual Lab, which allows partners access to secure, no-cost, test environments.  The second is through Amazon EC2 with OpenSolaris.  More details can be found at Dan's blog here.  And, if you need some help, let us know.

There are a couple of easy ways to test your Solaris application with MySQL ("the world's most popular opensource database").   Of course, you can always setup a Solaris or OpenSolaris environment and download it (70-80MB) and then install/configure locally.   However, if you don't want to go through the hassle of setting up the System, OS, & database yourself, Sun has made it easy to get your hands on pre-configured bits in a couple of other efficient ways.

Use the EZQual Virtual Lab.  Sun Partner's can get access to secure, no-cost, test environments (within Solaris containers/zones).  Here's the information directly from the program:

We've set up a secure, …

This week we had a very interesting problem at a customer: They complained, that their MySQL Cluster takes about 1 hour for a --initial start-up. After some tuning on the hardware and the config.ini they brought it down to around 40 minutes. But this is still unacceptable long...

This sounds a little strange to me. But let us have a look at their config.ini first. It looked more or less like the following (which is already tuned!):

#
# config.ini
#

[NDB_MGMD DEFAULT]
DataDir                      = /localdisk/cluster

[NDBD DEFAULT]
DataDir                      = /localdisk/cluster
NoOfReplicas                 =     2
LockPagesInMainMemory        =     1
DataMemory                   = 12000M
IndexMemory                  =  2000M

FragmentLogFileSize          =   256M
NoOfFragmentLogFiles         =    42

DiskCheckpointSpeedInRestart =   100M …

This week we had a very interesting problem at a customer: They complained, that their MySQL Cluster takes about 1 hour for a --initial start-up. After some tuning on the hardware and the config.ini they brought it down to around 40 minutes. But this is still unacceptable long...

This sounds a little strange to me. But let us have a look at their config.ini first. It looked more or less like the following (which is already tuned!):

 #
 # config.ini
 #
 
 [NDB_MGMD DEFAULT]
 DataDir                      = /localdisk/cluster
 
 [NDBD DEFAULT]
 DataDir                      = /localdisk/cluster
 NoOfReplicas                 =     2
 LockPagesInMainMemory        =     1
 DataMemory                   = 12000M
 IndexMemory                  =  2000M
 
 FragmentLogFileSize          =   256M
 NoOfFragmentLogFiles         =    42
 
 DiskCheckpointSpeedInRestart =   100M
 ODirect                      =     1
 
 BackupMaxWriteSize           =     1M …

As I mentioned earlier this week, I did a presentation on MySQL in OpenSolaris today.

The presentation (audio and slides) is now viewable online (and downloadable), and you can also get hold of the transcript of the questions: here (or download). The original presentation is here.

One minor difference from the presentation is that we …

Today, Martin "MC" Brown gave an overview of MySQL on openSolaris. Due to Yours Truly arriving late MC had to start a new Dimdim session (sorry for that!). So MC was the host and the presenter at the same time.

Interestingly (and annoyingly), this seemed to have a bad effect on sound quality. To most attendees, MC's voice sounded garbled. To me, he sounded like at least one octave too low. The sound recording, though, sounds all fine. I suspect that being the host of a Dimdim session has a bad effect on voice quality (the same thing has happened to me regularly, but I thought it was due to packet loss over my wifi or something). So, for the next MySQL University session on …

Reading this article you will learn how to create a Customized Performance Report for one of your MySQL™ Servers using HoneyMonitor, a GUI for MySQL™ Server Administration, Monitoring & Performance Tuning.

Contents

• Introduction
• Step 1 - Choosing a File Name and Opening the Report Designer
• Step 2 - Editing the SQL Queries used by the Report
• Step 3 - Editing the Charts contained in the Report
  • Axis Name
  • Series
• Step 4 - Other minor changes
• Step 5 - Previewing our Customized Report
• Few Considerations and Useful Tips
  • Actual Date Interval
  …

Entered 50 minute late (thanks to a wrong timezone calculation) into the MySQL University Session: MySQL and OpenSolaris by Martin MC Brown.


Incase you have missed it altogether, go grab the slides from the Wiki page.

Future and past univesity sessions are listed here at http://forge.mysql.com/wiki/MySQL_University

Entered 50 minute late (thanks to a wrong timezone calculation) into the MySQL University Session: MySQL and OpenSolaris by Martin MC Brown.


Incase you have missed it altogether, go grab the slides from the Wiki page.

Future and past univesity sessions are listed here at http://forge.mysql.com/wiki/MySQL_University