Sun is launching systems with multisocket  6-core Opterons (Istanbul) today. Last week I got access to  Sun Fire X4140 with 2 x 6-core Opterons with 36GB RAM. It is always great to see such a 1RU system packaged with so many x64 cores.

# psrinfo -vp The physical processor has 6 virtual processors (0-5)   x86 (chipid 0x0 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz)     Six-Core AMD Opteron(tm) Processor 8435 The physical processor has 6 virtual processors (6-11)   x86 (chipid 0x1 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz)     Six-Core AMD Opteron(tm) Processor 8435

I decided to take the system for a test drive with Olio. Olio is a Web 2.0 toolkit consisting on a web 2.0 event calendar application  which can help stress a system. Depending on your favorite scripting language you …

Sun is launching systems with multisocket  6-core Opterons (Istanbul) today. Last week I got access to  Sun Fire X4140 with 2 x 6-core Opterons with 36GB RAM. It is always great to see such a 1RU system packaged with so many x64 cores.

# psrinfo -vp The physical processor has 6 virtual processors (0-5)   x86 (chipid 0x0 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz)     Six-Core AMD Opteron(tm) Processor 8435 The physical processor has 6 virtual processors (6-11)   x86 (chipid 0x1 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz)     Six-Core AMD Opteron(tm) Processor 8435

I decided to take the system for a test drive with Olio. Olio is a Web 2.0 toolkit consisting on a web 2.0 event calendar application  which can help stress a system. Depending on your favorite scripting language you …

Recently I've done several performance studies to find the most optimal way to fix the "furious flushing" observed during all my benchmarks with InnoDB. The initial report about this work you may find here including initially proposed patches. But analyzing test workloads with the latest MySQL performance build I think there is a need to go more far...

First of all let's me present you the result I've got on the Read+Write workload @dbSTRESS - first part of graph represents the TPS level obtained with MySQL 5.4, and the second part - with the latest MySQL performance build (#46):

This Read+Write workload is running non-stop during one hour within the same conditions in both cases:

• 16 CPU cores
• 32 concurrent user sessions
• innodb_thread_concurrency=16
…

Even this topic was covered several times already, the question is still open - use or not to use InnoDB thread concurrency?.. And the only true answer here - "It depends" :-) and I'll try to make a short summary about the current state here.

The main current InnoDB bottlenecks are all mostly due to a high contention on internal locks. As all multi-threaded (as well multi-process) applications giving a concurrent access to its resources, InnoDB have to guarantee there is only one thread may modify a given resource on the same time. This guarantee is achieved by locking a resource in exclusive mode and implemented with mutexes. Depending on implementation, some locks may become very hot with a growing access concurrency. And it's exactly what's happening with InnoDB...

Things where improved a lot with Google patches and continuing with MySQL 5.4 version. But even if several lock bottlenecks were successfully removed, the lock …

Absolutely nothing?

5.4.0 was released with a change in the MySQL Binary distributions, delivering only 1 64bit Linux platform and two Sun Solaris platforms. This was officially announced on April 21 2009 however the 5.4.0 Release Notes state 05 April 2009. So it’s not a big deal, but consistency would be nice.

I’ve seen in a few posts 5.4.1, so I decided to try it out. Spending the time to read what’s changed in 2 months with the 5.4.1 Release Notes before I go downloading and installing, you read.

This release does not differ from 5.4.0 …

Recently new performance builds were made by our MySQL Team, and it seems to me reaching now a new milestone with the build #45 - within this single build Mikael joined several previously tested performance builds showed a positive performance improvement. So, how well it's comparing now to the default 5.4 ?..

Here are my results obtained on M5000 (quad-cores)/ Solaris10 update7 and db_STRESS.

Solaris 10 update7

Special note about update7: I was pleasantly surprised the kernel locks issue was gone! CPU Spinlocks within a similar workload are devided by 4(!) - very positive improvement, and seems the things will be even better with update8!

Read-Only Workload

For my big surprise there was no difference (or very few) between …

Sun recently rolled out a new Business Intelligence (BI) solution that uses Open Storage at its core. There are several things that are different about this solution that make it stand out from the crowd.

1) It is based on Open Source software.

This solution uses the commercial versions of open source software from Pentaho and Infobright to provide the BI and Datawarehouse (DW) functions respectively and both use the MySQL database. Also, this solution uses Sun's Open Storage products as the core storage component which are built using Open Source software and industry standard components. Combine those with an Open Source operating system like Solaris or Linux and you have a complete BI solution built on an Open Source software stack.

2) The price is right. …

Sun recently rolled out a new Business Intelligence (BI) solution that uses Open Storage at its core. There are several things that are different about this solution that make it stand out from the crowd.

1) It is based on Open Source software.

This solution uses the commercial versions of open source software from Pentaho and Infobright to provide the BI and Datawarehouse (DW) functions respectively and both use the MySQL database. Also, this solution uses Sun's Open Storage products as the core storage component which are built using Open Source software and industry standard components. Combine those with an Open Source operating system like Solaris or Linux and you have a complete BI solution built on an Open Source software stack.

2) The price is right. …

Sun recently rolled out a new Business Intelligence (BI) solution that uses Open Storage at its core. There are several things that are different about this solution that make it stand out from the crowd.

1) It is based on Open Source software.

This solution uses the commercial versions of open source software from Pentaho and Infobright to provide the BI and Datawarehouse (DW) functions respectively and both use the MySQL database. Also, this solution uses Sun's Open Storage products as the core storage component which are built using Open Source software and industry standard components. Combine those with an Open Source operating system like Solaris or Linux and you have a complete BI solution built on an Open Source software stack.

2) The price is right. …

Governments. Governance. Customers wins. And more.

Follow 451 CAOS Links live @caostheory
“Tracking the open source news wires, so you don’t have to.”

Governments
The Examiner provided a two part interview with Daniel Risascher, Office of the CIO, Department of Defense, on open source at the DoD, while Government Technology Magazine reported on how open source software and cloud computing can save government money. Similarly, The UK Conservative party delivered a paper on the future of open standards, open source, SOA and cloud for UK Government, while it was reported that Vienna to …