When we write about investors on this blog we are normally referring to angel and VC investors and the funding they provide to open source start-ups. There is a small, but growing, list of VCs that clearly understand the open source development and distribution models and the long-term profit potential of open source software vendors.

Can the same be said of individual and institutional investors buying and selling shares in publicly traded software companies? Not according to the analysis of Oliver Alexy, a research assistant and doctoral candidate at the Technische Universität München TUM Business School in Munich, Germany.

Oliver has analyzed the impact that releasing software under open source licenses has on a company’s share price. Details have been published this week in the …

If you’re an advanced MySQL person, you might already know these, in which case, please read anyway, because I still have some questions. On the other hand, f you’re someone who launched an application without a lot of database background, thinking “MySQL Just Works”, you’ll eventually figure out that it doesn’t, and in that case, maybe these tips will be of some use. Note that I’m speaking specifically about InnoDB and MyISAM, since this is where most of my experience is. Feel free to add more to this content in the comment area. 

InnoDB vs. MyISAM

Which one to use really depends on the application, how you’re deploying MySQL, your plans for growth, and several other things. The very high-level general rule you’ll see touted on the internet is “lots of reads, use MyISAM; lots of writes, use InnoDB”, but this is really an oversimplification. Know your application, and know your data.  If all of …

Recently I ran into major problems using GNU diff. It would crash with "diff: memory exhausted" after only a few minutes trying to process the differences between a couple 4.5GB files. Even a beefy box with 9GB of RAM would run out of it in minutes.

There is a different solution, however, that is not dependent on file sizes. Enter rdiff – rsync's backbone. You can read about it here: http://en.wikipedia.org/wiki/Rsync (search for rdiff).

The upsides of rdiff are:

• with the same 4.5GB files, rdiff only ate about 66MB of RAM and scaled very well. It never crashed to date.
• it is also MUCH faster than diff.
• rdiff itself combines both diff and patch capabilities, so you can create deltas and apply them using the same program

The downsides of rdiff are:

…

Sun advances GlassFish. Red Hat announces JBoss momentum. Mandriva releases Linux update. (and more)

Sun Microsystems Announces Technology Preview of Open Source Sun GlassFish Enterprise Server and New Sun GlassFish Communications Server, Sun Microsystems (Press Release)

Red Hat Continues Middleware Industry Momentum, Red Hat (Press Release)

Mandriva presents its latest distribution: Mandriva Linux 2008 Spring, Mandriva (Press Release)

Hyperic Announces MySQL …

After all the fuss it appears that MySQL will be remaining open source after all. As Kaj Arno and Monty Widenius report, Marten Mickos announced at CommunityOne that the MySQL Server will stay open source, as well as the forthcoming encryption and compression backup features, which MySQL had considered making available only to paying customers.

“The change comes from MySQL now being part of Sun Microsystems. Our initial plans …

Note: Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex is now published.

After our last post about installing Oracle 11g on Ubuntu 7.10 (November, 6th), and considering Ubuntu 8.04 LTS was released on April 21st, I spent some time reviewing and putting together this new HOWTO for the installation.

Please note: I’ve used the x86 server version of Ubuntu 8.04, but the same steps should work without any problems for the Desktop version. Also notice that this whole procedure can easily take over six hours to complete, so don’t complain I didn’t …

UPDATE: There are some examples being added at the MySQL Forge now.

When I first started installing MySQL for myself, it was quite handy to have the example my.cnf files in the source package. I was a noob to the MySQL configuration. Even after I became more experienced, I would use them as a starting point. However, I now find that they are so behind the times they are not as useful. Here are some of the comments from the files.

my-small.cnf

# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.

my-medium.cnf

# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to …

i was going to write some reactions to an observation that postgresql has no bug tracker and its discussion last week, but lost the spark and abandoned the post after a few days. but today i ran across a quote from linus torvalds that neatly sums up my thoughts:

We’ve always had some pending/unresolved issues, and I think that as our tracking gets better, there’s likely to be more of them. A number of bug-reports are either hard to reproduce (often including from the reporter) or end up without updates etc.

before there was a bug tracking system for mysql, there was a claim that all bugs were fixed in each release (or documented), and there has been a lot of pain in seeing how well that sort of claim stacks up against a actual …

There were free copies of the Linux Journal handed out to attendees outside in the hallways here at CommunityOne and I noticed that they just published this year's Readers' Choice Awards - MySQL was voted as the favourite database by 62.7% of their readers!

MySQL is not only the world's most popular open-source database, it's your favorite as well. Although PostreSGL,
SQLite, Firebird and others registered votes, the competition was not fierce. It doesn't hurt that MySQL runs on more than
20 different platforms.

Thanks a lot to the readers of LinuxJournal, we really appreciate the support!

Right now there is a discussion on Planet MySQL regarding MySQL / Linux swap problem. Peter Zaitsev originally brought the problem of MySQL swapping to light. Recently, Dathan Pattishall also wrote about it in his post Linux 64-bit, MySQL, Swap and Memory. Don McAskill followed up with his post, MySQL and the Linux Swap problem, and an interesting way to get around the issue: "make swap partitions out of RAM disks." Don also points to another article by Kevin regarding …