Update: Sun has expanded its Cloud Computing portfolio with the recent acquisition of Qlayer, a cloud computing company that automates the deployment and management of both public and private clouds.  The Q-layer organization, based in Belgium, is now part of Sun's Cloud Computing business unit which develops and integrates cloud computing technologies, architectures and services.

Cloud computing is about managing petascale data. Sun's server and storage systems can radically improve the data-intensive computing emerging in the cloud. Some clouds are closed platforms that lock you in. Sun's open source philosophy and Java principles form the core of a strategy that provides interoperability for large-scale computing resources. Sun's virtualization solutions for advanced …

Update: Sun has expanded its Cloud Computing portfolio with the recent acquisition of Qlayer, a cloud computing company that automates the deployment and management of both public and private clouds.  The Q-layer organization, based in Belgium, is now part of Sun's Cloud Computing business unit which develops and integrates cloud computing technologies, architectures and services.

Cloud computing is about managing petascale data. Sun's server and storage systems can radically improve the data-intensive computing emerging in the cloud. Some clouds are closed platforms that lock you in. Sun's open source philosophy and Java principles form the core of a strategy that provides interoperability for large-scale computing resources. Sun's virtualization solutions for advanced …

Update: Sun has expanded its Cloud Computing portfolio with the recent acquisition of Qlayer, a cloud computing company that automates the deployment and management of both public and private clouds.  The Q-layer organization, based in Belgium, is now part of Sun's Cloud Computing business unit which develops and integrates cloud computing technologies, architectures and services.

Cloud computing is about managing petascale data. Sun's server and storage systems can radically improve the data-intensive computing emerging in the cloud. Some clouds are closed platforms that lock you in. Sun's open source philosophy and Java principles form the core of a strategy that provides interoperability for large-scale computing resources. Sun's virtualization solutions for advanced …

Angelo recently showed an easy way to dump SQL queries using DTrace, while reading the articles I felt that some important information is missing: The name of the user executing the query and the selected database. So I sat down a few minutes and tried to collect that data.

For the database name I found a quite simple solution: It is passed as parameter to the check_user() function to MySQL so we can easily add a thread-local variable to keep that name. Simple script for that:

#!/usr/sbin/dtrace -s

#pragma D option quiet

pid$1::*check_user*:entry
{
    self->db = arg4 ? copyinstr(arg4) : "(no schema)";
}

pid$1::*dispatch_command*:entry
{
    printf("%s: %s\n", self->db, copyinstr(arg2));
}

Getting the username is a bit harder, for the …

CIO published an article highlighting 5 cheap (or free) software that can be afforded during financial crisis. Their recommendations are:

• Open Office ($0) instead of Microsoft Office ($110 for basic version)
• Mozilla Thunderbird ($0) instead of Microsoft Outlook (lots of security issues)
• GnuCash ($0) instead of Quicken ($30 for starter edition)
• Alfresco ($0) instead of Sharepoint ($5K for five licenses)
• …

(Note: This post is relevant only if you want to have 'DTr ace' support in the MySQL server. Packages for Solaris are available at http://dev.mysql.com/downloads/.  You can install the MySQL packages for Solaris 10 on Open Solaris)

We shall use the Sun Studio C/C++ compilers and linkers to build MySQL 6.0 alpha on Open Solaris b98 on a x86 system.

1. Grab the MySQL 6.0 alpha tarball from here
2. Extract it

3. Go to the source root, and do the following: (The text following a '#' should be treated as comments)

       $ ./configure --enable-dtrace CC=cc CXX= CC --without-falcon --prefix=/export/home/amit/mysql60-install # MySQL 6.0 alpha contains DTrace probes. To enable it use the flag --enable-dtrace, 'cc' and 'CC' are Sun C …

(Note: This post is relevant only if you want to have 'DTr ace' support in the MySQL server. Packages for Solaris are available at http://dev.mysql.com/downloads/.  You can install the MySQL packages for Solaris 10 on Open Solaris)

We shall use the Sun Studio C/C++ compilers and linkers to build MySQL 6.0 alpha on Open Solaris b98 on a x86 system.

1. Grab the MySQL 6.0 alpha tarball from here
2. Extract it

3. Go to the source root, and do the following: (The text following a '#' should be treated as comments)

       $ ./configure --enable-dtrace CC=cc CXX= CC --without-falcon --prefix=/export/home/amit/mysql60-install # MySQL 6.0 alpha contains DTrace probes. To enable it use the flag --enable-dtrace, 'cc' and 'CC' are Sun C …

(Please note that you will have to build MySQL from sources only if you want to try out the DTrace facilities. Otherwise, binary packages are available for installation) 

We shall use the Sun Studio C/C++ compilers and linkers to build MySQL 6.0 alpha on Open Solaris b98 on a x86 system.

1. Grab the MySQL 6.0 alpha tarball from here
2. Extract it
3. Go to the source root, and
   1. ./configure --enable-dtrace --prefix=/export/home/amit/mysql60-install CC=cc CXX=CC --without-falcon
      
   2. make
   3. make install

Note:

Please make sure that the location of the Sun tools are ahead in your PATH. GNU tools should be located later in the PATH. For eg.

…

If you use MySQL, you may want to give OpenSolaris a try. Why? It's open source and has great features, like ZFS and DTrace, which make life a lot easier for MySQL DBAs.  

• ZFS is a 128-bit file system that automates common administrative tasks, protects data from corruption, provides compression, and allows for adding and removing storage easily (just to name a few things its capable of).  It is great for MySQL deployments in that DBAs can add or remove storage without restarting the database and fast snapshots are a breeze.  Additonally, ZFS shows better performance than UFS.  See these results performed by MySQL. 
• DTrace helps administrators analyze, debug, and optimize their application environment.  It's a great tool for MySQL DBAs since it …

Want to use Dtrace or ZFS but are unfamiliar with building MySQL on Solaris? Dont panic, its never been easier. Here are the steps that worked for me.

1. Install OpenSolaris using the latest development ISO file
2. Install developer tools

   pfexec pkg install ss-dev

3. Download 5.1.28rc source
4. Build it

   export CC=/opt/SunStudioExpress/bin/cc
   export CXX=/opt/SunStudioExpress/bin/CC
   export CFLAGS="-xO3" #Your fav compiler flags go here 
   export CXXFLAGS="-xO3"
   
   ./configure --with-plugins=innobase,myisam --with-mysqld-libs=-lmtmalloc
   gmake 
   

Yes, it is that simple. Of course you could just download the binaries and use them too; they work just fine.