PLEASE NOTE: I am currently reviewing and extending this document. While caring for a remarkable amount of MySQL server instances, troubleshooting becomes a common task. It might of interest for you which Recovering a crashed MySQL server After a server … Weiterlesen →

Topics for this podcast:

*CAOS 11 - Open to Investment
*CollabNet out with new TeamForge 5.2
*Memcached and MySQL appliances abound

iTunes or direct download (25:05, 5.8 MB)

Open source in government. Sourcefire announces relationships with Symantec and Microsoft. EPL supercedes CPL. The cost and potential savings of open source. The origins of open source. IBM and Sun - back on? And more.

Follow 451 CAOS Links live @caostheory

# OStatic: Why Isn’t Open Source Even Considered at the U.S. State Government Level?

# Simon Phipps: Five Ideas To Get FOSS Into Governments.

# Sourcefire’s 3D system to be bundled as part of the Symantec Managed Security Services offering.

# Sourcefire has also announced a strategic relationship with Microsoft.

# The Eclipse Foundation has …

Refining the Beekeeper model. Investment opportunities. Schooner, Gear6 and Virident line up memcached appliances. The launch of the Open Source Channel Alliance. Is source code necessary? And more.

Follow 451 CAOS Links live @caostheory

Of bees and trees
We noted last week that James Dixon, CTO of Pentaho, had updated his Beekeeper model for understanding the commercial-community relationships employed by vendors to engage with open source. Roberto Galoppini quickly followed up with some feedback, as did Tarus …

Take a look here:

  Response Time (s)
 Transaction      %    Average :    90th %        Total        Rollbacks      %
------------  -----  ---------------------  -----------  ---------------  -----
    Delivery   3.98      0.211 :     0.266       274829                0   0.00
   New Order  44.78      0.157 :     0.187      3090951            30925   1.00
Order Status   3.99      0.149 :     0.179       275357                0   0.00
     Payment  42.76      0.150 :     0.180      2951361                0   0.00
 Stock Level   3.99      0.152 :     0.182       275564            92070  33.41

50606.82 new-order transactions per minute (NOTPM)
60.5 minute duration
0 total unknown errors
31 second(s) ramping up

If you know what this output is from, and you know what 50K TPM means… your probably curious about these #’s. I am probably tantalizing you right now in fact. But I am not going to tell you more, not yet. So go ahead and guess. Better yet come …

This is an issue that keeps rearing its ugly head over and over again, and since it greatly affects performance, it is most important that DBAs of any DMBS running on Linux come to grips with it. So I decided to do some research and try different settings on my notebook. Here are my findings.

What can you find on the web?

A Wikipedia search for the word swappiness will come up empty (any volunteers out there want to write an article?). A Google search will show some pretty old material—the best article I found is from 2004: Linux: Tuning Swappiness. This article includes a detailed discussion with some interesting remarks by Andrew Morton, a Linux kernel maintainer.

So, what is swappiness?

Towards the end of the email thread quoted in the article, you’ll find this definition (sort of):

> I’ve read the source for where …

Only a little over a week before the User conference and I am still burning the midnight oil to get as much information for my presentations as possible. I thought I would tease you a bit here. What do you get when you put 4 Intel X-25E’s ( Sun branded) SSD’s running RAID10 in a Sun 4450 and run the sysbench fileio test on it?

We have finally uploaded the next beta packages of our upcoming database design tool. We have fixed several bugs and added some enhancements that to the Interface. There’s a new editor for defining/maintaining User Defined Datatypes.

There are binary-packages for Windows, Mac OS X Leopard and Linux (Ubuntu and Fedora) as well as the zipped sources for building Workbench yourself. If you experience problems please let us know by filing bugs at http://bugs.mysql.com or contact us directly on via irc-client on irc.freenode.net channel #workbench.
Thank you all for your feedback and contribution. Fetch the new packages at our main download page and give it another try.

A little while ago, I was the brave soul tasked with making sure Drizzle was working properly and passing all tests on Solaris and OpenSolaris. Brian recently blogged about some of the advantages of also running on Solaris and the SunStudio compilers - more warnings from the compiler is a good thing. Many kudos goes to Monty Taylor for being the brave soul who fixed most of the compiler warnings (and for us, warnings=errors - so we have to fix them) for the SunStudio compilers before I got to making te tests work.

So, I got to the end of it all and got pointed to an OpenSolaris x86 box where the drizzleslap test was timing out. The timeout for tests is some amazingly long amount of time - 15 minutes. All the drizzle-test-run tests are rather short tests.

To make running the tests quick, I usually LD_PRELOAD …

Some weeks ago Luke Kaines stated his observation that “requiring copyright attribution is a greater sin than providing commercial add-ons”.

His perspective was based on the theory that requiring copyright assignment restricts the developer community, a theory that was apparently repeated by Dave Neary during the recent OSBC event (I missed that session due to our CAOS client lunch).

Daniel Chalef of KnowledgeTree provided some evidence of Dave’s perspective and also the contrary view that the assignment of copyright is critical not just for vendor-dominated projects but also for community projects such as The Mozilla Foundation, The …