Today I was doing some work on one of our database servers (each of them has 4 SAS disks in RAID10 on an Adaptec controller) and it required huge multi-thread I/O-bound read load. Basically it was a set of parallel full-scan reads from a 300Gb compressed innodb table (yes, we use innodb plugin). Looking at the iostat I saw pretty expected results: 90-100% disk utilization and lots of read operations per second. Then I decided to play around with linux I/O schedulers and try to increase disk subsystem throughput. Here are the results:

If you are a GUI-oriented person, you need not read this. But if you are like me, you make heavy use of the console. If you are managing many machines as well as your own Linux workstation, it’s VERY important to know where your console session is.

Too many times in the past I had wanted to bring down my workstation, and would type “shutdown” or “reboot” in the console window, only to find out to my horrors that the console was really a remote session to one of my web servers serving up hundreds of web sites.

Whoops!

Well, that prompted me into developing a solution where I can tell at a glance where I happened to be logged in. This way,  I wouldn’t be in danger of issuing dangerous commands on the wrong server. And if you are working for someone else, it also keeps you from being FIRED!

I use KDE to do my development and …

Earlier this week I posted how OpenJDK was knock, knock, knockin' on Lenny's door.  At that time I also mentioned how it was already in Ubuntu and Fedora.

What I failed to mention, however, and was right under my very nose was that fact that OpenJDK had already made it into OpenSUSE 11.  Thanks to MySQL Euro-community manager and former SUSE employee Lenz Grimmer, I was …

Tag1 Consulting is focused on improving Drupal's performance and scalability. We also believe that when information is freely shared, everyone wins. Toward these ends, we are working on an online book titled, "Drupal Performance and Scalability". The book is divided into five main sections, Drupal Performance, Front End Performance, Improved Caching and Searching, Optimizing the Database Layer, and Drupal In The Cloud. The book is primarily aimed toward users running …

Earlier this week I posted how OpenJDK was knock, knock, knockin' on Lenny's door.  At that time I also mentioned how it was already in Ubuntu and Fedora.

What I failed to mention, however, and was right under my very nose was that fact that OpenJDK had already made it into OpenSUSE 11.  Thanks to MySQL Euro-community manager and former SUSE employee Lenz Grimmer, I was …

Earlier this week I posted how OpenJDK was knock, knock, knockin' on Lenny's door.  At that time I also mentioned how it was already in Ubuntu and Fedora.

What I failed to mention, however, and was right under my very nose was that fact that OpenJDK had already made it into OpenSUSE 11.  Thanks to MySQL Euro-community manager and former SUSE employee Lenz Grimmer, I was …

It seems almost churlish to wonder whether Google could be even more successful than it already is with a different strategy, but the company’s approach to open source and open development has come into focus in recent weeks.

On last week’s podcast we discussed whether the company should see the AGPL as more of an opportunity than a threat following Jay’s post about the company releasing more code under open source licenses.

Nik Cubrilovic over at TechCrunch, meanwhile, has written an interesting …

Sun continues to take a performance pounding, and the rumors of replacements, layoffs and revamps are beyond swirling and now perpetuating skepticism of the company. It strikes me as odd that Sun, which has embraced open source and is also the defacto leading corporate open source software contributor, is continually dogged by doubts about its transitions and tenures despite well-respected technology and participation in open source. Part of this lies in the company’s continuing dichotomy in strategy — a reference to tepid support for Linux and continued preference for and focus on Solaris. This is a large part of Sun’s ‘handicap,’ IMHO when it comes to Linux and open …

I was at a client site with Yves Trudeau ( another MySQL consultant ) and the client had purchased a brand new top of the line 16 core server.  It is well documented in many places that scalability beyond 4-8 cores with innodb is less then optimal.  We were asked for a ballpark on the performance of a 16 cores vs an 8 cores, and specifically if their were any options to reduce the number of cores the mysqld process could use.   We decided to benchmark this using DBT2.   To do the test we ended up setting the CPU affinity of the mysqld process.  You can set this with the following command:  taskset.   Yves ended up trying the same DBT2 tests for 1-16 cores.    I won’t write too much about the scalability here, as I said their are way better resources out their that can explain it better, but what I wanted to do is post the results of …

Having a Google account is sometimes useful in ways you hadn’t planned for. For example, at a few different employers I’ve been at, I’ve had to prepare for reviews by providing a list of accomplishments to my supervisor. One decent tool for generating this list is email, though it can take some time. Another useful tool is the Web History feature of your Google account.

Though this isn’t necessarily indicative of everything I’ve accomplished in the first half of 2008 per se, it’s definitely indicative of the types of things I’ve generally been into so far this year, and it’s interesting to look back. What does your Web History say?

• Gearman - this is used by some rather large web sites, notably Digg. It reminds me a little of having Torque and Maui, but geared toward more general-purpose applications. In fact, it was never clear to me that …