From mboxrd@z Thu Jan  1 00:00:00 1970
From: Anthony Liguori <anthony@codemonkey.ws>
Subject: Re: sync guest calls made async on host - SQLite performance
Date: Tue, 29 Sep 2009 13:54:58 -0500
Message-ID: <4AC25802.9060606@codemonkey.ws>
References: <4ABA45BE.1080008@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: kvm@vger.kernel.org, Dustin Kirkland <kirkland@canonical.com>,
	Avi Kivity <avi@redhat.com>
To: Matthew Tippett <tippettm@gmail.com>
Return-path: <kvm-owner@vger.kernel.org>
Received: from mail-qy0-f174.google.com ([209.85.221.174]:33789 "EHLO
	mail-qy0-f174.google.com" rhost-flags-OK-OK-OK-OK) by vger.kernel.org
	with ESMTP id S1753572AbZI2Sy5 (ORCPT <rfc822;kvm@vger.kernel.org>);
	Tue, 29 Sep 2009 14:54:57 -0400
Received: by qyk4 with SMTP id 4so4225641qyk.33
        for <kvm@vger.kernel.org>; Tue, 29 Sep 2009 11:55:01 -0700 (PDT)
In-Reply-To: <4ABA45BE.1080008@gmail.com>
Sender: kvm-owner@vger.kernel.org
List-ID: <kvm.vger.kernel.org>

Matthew Tippett wrote:
> Hi,
>
> I would like to call attention to the SQLite performance under KVM in 
> the current Ubuntu Alpha.
>
> http://www.phoronix.com/scan.php?page=article&item=linux_2631_kvm&num=3
>
> SQLite's benchmark as part of the Phoronix Test Suite is typically IO 
> limited and is affected by both disk and filesystem performance.

Gotta love Phoronix's transparent methodology...

Ubuntu's Karmic release has _not_ been released yet.  For this 
particular test, Phoronix was probably using an alpha drop before Ubuntu 
switched from kvm-84 to qemu-kvm-0.11.0.

Before 0.11.0, there were known issues with qcow2 and it was not 
recommended for use in production environments.  If you read the release 
notes for 0.10.0, we made this very clear.  Because of some performance 
problems, in 0.10.x we made cache=writeback the default for qcow2.  We 
document this pretty thoroughly.  See 
http://www.qemu.org/qemu-doc.html#SEC10  Some other distros that shipped 
0.10.x made cache=none the default in order to ensure data integrity (at 
the cost of performance).

For 0.11.0, Kevin Wolf has fixed the performance/reliability issues in 
qcow2 and we now set cache=writethrough for qcow2 by default.

And FWIW, Karmic has been on the 0.11.0 tree now for at least a month.

Regards,

Anthony Liguori