The 2008 MySQL Magazine Survey reaches 400 responses! Thanks to all those who have surveyed.

Our goal for this survey is to reach 500 responses before the survey closes, which is coming soon.

The 2008 MySQL Magazine Survey closes June 17th at 05:00 GMT.

Have you surveyed?


MySQL DBA & Programming Blog by Mark Schoonover

Jim Starkey joined MySQL about 2 1/2 years ago when MySQL acquired his startup company, Netfrastructure.  Jim has a long history in the database industry having created several major databases over the years and we wanted him to take the core engine of Netfrastructure and integrate it into MySQL.  This became the Falcon project, which is now in Beta as part of …

Please find a nice article by Djoni Darmawikarta here. He gives a nice step-by-step tutorial on how to use MySQL Workbench to create a simple model and then use the Forward Engineering functionality to create the actual database schema.

If you have written such a tutorial yourself or plan to write one, please drop us a email at workbench@mysql.com and we will be happy to feature you on our official Workbench Blog!

I want to get opinions from outside of my daily circle of people on the best server hardware to use for MySQL. I remember from the conference somebody (Pipes?) mentioning a particular Dell server with multiple disk RAID10 that could supposedly be had for about $6k but I completely misplaced the model number (Frank, did you get my email?).

I know that a multi-disk RAID array with a bunch of fast disks (15k RPM?) is probably the most important method of improving performance, followed by the amount of RAM, so I'm trying to find the best combination/balance of the two. However, server prices on the Internet range so much that I don't even know where to begin to tell a good deal from a bad one. I don't think SSDs can play a role here, because we …

In this post I shall show you how you can set up a MySQL community server on your Solaris installation.

Some useful information:

• Solaris installation: Solaris 10 (32-bit SPARC)
• MySQL 5.1.24-rc is the MySQL community server I am using for the demonstration (You may also try this with MySQL 5.1.25-rc, since the older tarball is not available officially anymore)
  

You will need the following tools:

• GNU Make (gmake): I am using GNU Make 3.80
• GNU C/C++ compiler:
  
  • gcc (GCC) 3.4.3 (csl-sol210-3_4-branch+sol_rpath)
  • g++ (GCC) 3.4.3 (csl-sol210-3_4-branch+sol_rpath)
    

• Download the MySQL 5.1.24-rc source tarball from  …

In this post I shall show you how you can set up a MySQL community server on your Solaris installation.

Some useful information:

• Solaris installation: Solaris 10 (32-bit SPARC)
• MySQL 5.1.24-rc is the MySQL community server I am using for the demonstration (You may also try this with MySQL 5.1.25-rc, since the older tarball is not available officially anymore)
  

You will need the following tools:

• GNU Make (gmake): I am using GNU Make 3.80
• GNU C/C++ compiler:
  
  • gcc (GCC) 3.4.3 (csl-sol210-3_4-branch+sol_rpath)
  • g++ (GCC) 3.4.3 (csl-sol210-3_4-branch+sol_rpath)
    

• Download the MySQL 5.1.24-rc source tarball from  …

We run an internally developed AMP benchmark to understand the performance characteristics of the AMP stack on various platforms.

We did some comparisons of the AMP stack in Cool Stack 1.2 with the one in Cool Stack 1.3. We didn't see any signficant difference in performance in the Apache/PHP tier between the two versions. However, there is a dramatic improvement in performance in the MySQL tier using Cool Stack 1.3. Cool Stack 1.2 shipped with MySQL 5.0.45 and 1.3 now has MySQL 5.1.24.

The graph below shows the CPU utilization on the MySQL system at different load levels :

MySQL 5.1 is 4x more efficient than 5.0.45 ! There are improvements in the Query Cache and query optimization in MySQL 5.1, but at this point we are doing more analysis to understand the reasons for the dramatic performance increase. Here is another graph that shows the network …

We run an internally developed AMP benchmark to understand the performance characteristics of the AMP stack on various platforms.

We did some comparisons of the AMP stack in Cool Stack 1.2 with the one in Cool Stack 1.3. We didn't see any signficant difference in performance in the Apache/PHP tier between the two versions. However, there is a dramatic improvement in performance in the MySQL tier using Cool Stack 1.3. Cool Stack 1.2 shipped with MySQL 5.0.45 and 1.3 now has MySQL 5.1.24.

The graph below shows the CPU utilization on the MySQL system at different load levels :

MySQL 5.1 is 4x more efficient than 5.0.45 ! There are improvements in the Query Cache and query optimization in MySQL 5.1, but at this point we are doing more analysis to understand the reasons for the dramatic performance increase. Here is another graph that shows the network …

It's finally here. Before you download the release, please do read the documentation. It's over a month late, but hopefully the features will compensate for the delay.
Almost every single component in the stack has been upgraded. Two new packages, CSKpython and CSKnginx have been added. And yes - the python package does include mod_python too.
You can read about the full list of changes in the Changelog.

ruby

Significant changes have been made to the ruby package. In addition to the upgrade to ruby1.8.6p114, we include a number of gems, notably mysql, postgres and mongrel. It should also be easy to install any new gem …

It's finally here. Before you download the release, please do read the documentation. It's over a month late, but hopefully the features will compensate for the delay.
Almost every single component in the stack has been upgraded. Two new packages, CSKpython and CSKnginx have been added. And yes - the python package does include mod_python too.
You can read about the full list of changes in the Changelog.

ruby

Significant changes have been made to the ruby package. In addition to the upgrade to ruby1.8.6p114, we include a number of gems, notably mysql, postgres and mongrel. It should also be easy to install any new gem …