The Joyent Accelerator for MySQL is apparently 2-4 times faster than an EC2 instance, but there's no mention of configuration, database size or even what the queries were in their record breaking performance tests.

I assume that Joyent has tuned their MySQL install, so it only seems fair not to use the default configuration on the EC2 test. If you look at Vadim's EBS benchmarks (particularly random read/write) it looks like they may have a very good product, but instead we're left with the impression that they have something to hide.

1,245 transactions per second isn't very much these days if they …

I got the question on how small a packaged application with a built-in MySQL server could be. I had an idea that it could be made very small, but I didn't have any exact numbers. The platform was Windows, so I decided to try to build an application like this, to test it.
I had a few requirements:

• A minimal amount of registry settings.
• I didn't want to spend too much time on the application itself, so this should be simple.
• I wanted to have a full blow installation package, i.e. install application and then run it, so no servers to be started or something like that. Just install and run.
• No assumptions about the Windows PC where this was installed (I actually in the end made one such simplification. I decided to use a fix MySQL port number).
• Installer was InnoSetup, because I like it and I know it well.
  

So, I started building a simple dialog based …

Dear Community,

The 18-th build of MySQL server with Percona patches is available now.

Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.84
• Fixed the issue with CLIENT_STATISTICS
• New patch innodb_recovery_patches.patch greatly improves recovery time

Fixed bugs in the build:

• Bug #407117 in Percona patches: "any mysql-test fails with a warning "master.err: ctype_ucs2_def: InnoDB: Warning: some resources were not cleaned up in shutdown:""
• …

A document oriented database or data store does not use tables for storing data. It stores each record as a document with certain characteristics. So a multiple documents in this type of store can have different characteristics - which means different number of fields per record and different fields per row. The benefit would be that if you are using a document oriented database for storing a

I got to think about the commercialization of Open Source software project happen these days. Many of them have been acquired by larger companies, or are about to, and I think a discussion here is important. By which I in no way think I have all the answers, quite the opposite, this post is more about raising questions, and maybe propose a few possible answers.

So, do we really need commercialization of the project? And if you ask me (but I am a Sales Engineer after all, so what do you expect from me), I think the answer must be yes. And then the question is how this is best done. I think we can agree that Open Source, as a development model is just great, but to keep it going, something more is needed. And there are reasons why we want commercialization of these projects. Among them, in my mind, are:

• A commercial entity is needed for many things related to the project, such as partnerships, contacts, employees …

I'm proud to announce two big news today: First, the new XAMPP with PHP 5.3.0 is finally released and allows everyone the experience of this new PHP version, and secondly, congratulations and many thanks to Carsten Wiedmann, who took over the responsibility for the Windows version. Carsten was able to simplify the Windows version by replacing the installer by a self-extracting archive without losing the ease-of-use of XAMPP.

In all versions we updated Apache (2.2.12), MySQL (5.1.37), PHP (5.3.0), phpMyAdmin (3.2.0.1), plus minor updates of some libraries and tools.

Get the downloads and more details on the specific platforms XAMPP project page.

Linux vs FreeBSD, vi vs emacs, MySQL vs PostgreSQL, your habit or favorite technology vs another's. At the end of the day there is no winner, just a matter of preference for the task at hand. I learned C++ 13 years ago, I forgot most of my C++ knowledge 10 years ago, I discouraged the use of C++ in this period in between, and in the past year I've been re-learning C++ (mostly due to Drizzle). So what did I use after unlearning C++ 10 years ago? I wrote everything in C (and by everything I mean this was my performance programming language of choice). This worked quite well, but it's an interesting evolution that I think is now coming full circle.

When I first started programming C, it was a bit clumsy, and I look back at my old code and cringe. I began to develop a certain programming style that can best be described as object-oriented C programming due to the conventions used. The structs, functions that operated …

Do you plan to attend the Free and Open Source Conference (FrOSCon) in St. Augustin, Germany on August 22 & 23? Are you a fan of MySQL and would you like to share your knowledge about it with other users? Here is your chance!

Sun Microsystems is a Gold sponsor of FrOSCon this year and will also be present with a booth there on both days. In addition to demo stations about Open HA Cluster, OpenSolaris and NetBeans, Sun will also provide space for a MySQL info desk, which we would like to turn into a "Guru Bar", including members of the MySQL community.

The goal is to talk with existing and potential new MySQL users, share …

Most likely you have seen Giuseppe's post showing the latest feature of Planet MySQL. Voting from RSS readers, was one feature I was really hoping for, since the day voting was announced. As I read most blogs using Google Reader.

Now, I don't remember if it was Dups who asked me, or if I asked him, but all I remember is that I ended up writing a little JavaScript widget, that you can add to your blog. This widget allows readers to vote for your blog on Planet MySQL, all from within your blog.

Why would you want to add this JavaScript to your blog?
Because you want to make it very easy for your readers to vote if …

I will be presenting at upcoming MySQL Meetup at San Francisco this Thursday, August 13. I will talk about Sphinx covering the new cool features this search engine has as well as showing the demo on how simple it is to use Sphinx to implement high performance full text search for your MySQL driven application.

We also will have the raffle for 2 tickets for Performance Optimization for MySQL with Innodb and XtraDB Single Day Intense Training Workshop for either Santa Clara or San Francisco locations.

Entry posted by peter | …