We've been running into a problem with one client:SELECT COUNT(*) FROM tbl;takes 0.25 seconds on one db, and 0.06 seconds on another. Consistently. That's a fourfold difference. There aren't any significant configuration differences (like query cache, etc.), the software versions are the same, and the table fits into memory. This has been looked at by at least 3 in-house MySQL experts, and the only thing we can determine is that it's a hardware difference.Th

It recently came up that it would be helpful if we had a cheat sheet to find out the machine names for any given UNIX. I knew these off the top of my head but it would be great if people added more as comments. HP/HP-UX: /bin/uname -i IBM/AIX: /bin/uname -m SGI/IRIX: /sbin/sysinfo -s Sun/Solaris: /usr/ucb/hostid

OpenSolaris Web Stack (http://opensolaris.org/os/project/webstack) is an OpenSolaris project and community building an integrated stack of popular open source web tier infrastructure technologies such as Apache HTTP server, MySQL, memcached, PHP and Ruby On Rails optimized for Solaris platform. This session introduces OpenSolaris Web Stack, its status and future development including addition of newer technologies such as lighttpd, Varnish etc., as well as the ease of use features for developers and deployers. We will also be discussing an experimental web stack IPS package repository and it could be leveraged to build and make available popular end user applications such as Drupal.

Developing MySQL on Solaris requires you to install a suitable compiler and other tools, but you may be surprised to know that most of the material is there already, or easy to install if it's not. But even more so, there is a huge wealth of information that you can get about your application while it's running, both with and without using more traditional debugging methods. We'll cover setting up a suitable environment, where to find the things you need, and and how to make use of the process monitoring tools and debugging environment to get the best out of development on Solaris generally, and MySQL specifically.

Using DTrace with MySQL - current state, future prospects, and lots of examples

Using, installing and working with MySQL on OpenSolaris. - Note that the video must be downloaded to be able to view it!

Developing MySQL on Solaris requires you to install a suitable compiler and other tools, but you may be surprised to know that most of the material is there already, or easy to install if it's not. But even more so, there is a huge wealth of information that you can get about your application while it's running, both with and without using more traditional debugging methods. We'll cover setting up a suitable environment, where to find the things you need, and and how to make use of the process monitoring tools and debugging environment to get the best out of development on Solaris generally, and MySQL specifically.

Using DTrace with MySQL - current state, future prospects, and lots of examples

Using DTrace with MySQL - current state, future prospects, and lots of examples

Using, installing and working with MySQL on OpenSolaris. - Note that the video must be downloaded to be able to view it!