From mboxrd@z Thu Jan 1 00:00:00 1970 From: Matthew Tippett Subject: Re: sync guest calls made async on host - SQLite performance Date: Fri, 09 Oct 2009 15:06:51 -0400 Message-ID: <4ACF89CB.5020406@gmail.com> References: <4ABC6AA5.6080909@tauceti.net> <4AC259DC.2080807@codemonkey.ws> <4AC260BB.3090906@gmail.com> <4AC27355.3090303@codemonkey.ws> <4ACCC7A1.9060303@gmail.com> <4ACCEC9F.7090309@gmail.com> <4ACE0196.9010904@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: Anthony Liguori , Avi Kivity , RW , kvm@vger.kernel.org To: Dustin Kirkland Return-path: Received: from mail-fx0-f227.google.com ([209.85.220.227]:38591 "EHLO mail-fx0-f227.google.com" rhost-flags-OK-OK-OK-OK) by vger.kernel.org with ESMTP id S1751917AbZJITHc (ORCPT ); Fri, 9 Oct 2009 15:07:32 -0400 Received: by fxm27 with SMTP id 27so6680041fxm.17 for ; Fri, 09 Oct 2009 12:06:55 -0700 (PDT) In-Reply-To: Sender: kvm-owner@vger.kernel.org List-ID: Thanks Duncan for reproducing the behavior outside myself and Phoronix. I dug deeper into the actual syscalls being made by sqlite. The salient part of the behaviour is small sequential writes followed by a fdatasync (effectively a metadata-free fsync). As Dustin indicates, if scsi is used, you incur the cost of virtualization, if virtio is used, your guests fsyncs incur less cost. So back to the question to the kvm team. It appears that with the stock KVM setup customers who need higher data integrity (through fsync) should steer away from virtio for the moment. Is that assessment correct? Regards, Matthew -------- Original Message -------- Subject: Re: sync guest calls made async on host - SQLite performance From: Dustin Kirkland To: Matthew Tippett , Anthony Liguori , Avi Kivity , RW , kvm@vger.kernel.org Date: 10/09/2009 11:18 AM > On Fri, Oct 9, 2009 at 6:25 AM, Matthew Tippett wrote: >> Can I ask you to do the following... >> >> 1) Re-affirm that Ubuntu does not carry any non-stream patches and >> the build command and possibly any other unusual patches or >> commandline options. This should push it back onto Avi and Anthony's >> plate. > > I have put the patches we're carrying here, for your review: > * http://rookery.canonical.com/~kirkland/patches > > There's nothing exotic in here. Most of these have been committed > upstream already. All of them have been at least posted on these > lists. None of these should affect your test case. > > We configure with: > ./configure --prefix=/usr --disable-blobs --audio-drv-list="alsa pa > oss sdl" --audio-card-list="ac97 es1370 sb16 cs4231a adlib gus" > --target-list="$(TARGET_SYSTEM_TCG) $(TARGET_LINUX_TCG)" > > We carry a number of compiler options, mostly in the interest of > hardening and security: > * https://wiki.ubuntu.com/CompilerFlags > > The #define'd variables on my local system (which should be similar, > though not identical to our build servers) can be seen here: > * http://rookery.canonical.com/~kirkland/defined > >> 2) Carefully consider risks to virtualized environments in the >> server space and consider noting it in release notes. > > Thank you for the suggestion. I will take it under consideration. > > :-Dustin