From owner-freebsd-stable@FreeBSD.ORG Sat Oct 2 07:37:41 2010 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id E70921065673 for ; Sat, 2 Oct 2010 07:37:41 +0000 (UTC) (envelope-from telbizov@gmail.com) Received: from mail-qy0-f175.google.com (mail-qy0-f175.google.com [209.85.216.175]) by mx1.freebsd.org (Postfix) with ESMTP id 9C54E8FC0A for ; Sat, 2 Oct 2010 07:37:41 +0000 (UTC) Received: by qyk8 with SMTP id 8so318020qyk.13 for ; Sat, 02 Oct 2010 00:37:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=TBzSi9/4I0v85UDULLj2CkV6Lm1SlFvlVhGAfs5KPqY=; b=Ymul3nSZUCmWluB6z7sT1tS9E1Kw9UfgdT5lVT34cmqwYdiPywXMkNjE42c7P++h0o 61G1hrFvDD2ZV4qG+4oP++hBeSBaWJp0KugDV85xZufrITT1X5I37RqPiayvKi45EPa8 zjiA6dYTD2GqiToxRsyFL7NH0gG8H2c3nnp8c= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=VVQnMoScXr7YBuCDDjJj6qI1fT/pQITF0PktKPhVPIOVavgSbubm0IXHXg41BL7c8U 69t2qF21VZI75ECInf5IY1DQ4g58KL63Hxe9Y/ECsTgCn1PBU/+5EIKGYyIbzNfV9cSp mu1ywoYZev0WI9gbcJe7+MtCjxxPj/wq/MX60= MIME-Version: 1.0 Received: by 10.229.96.16 with SMTP id f16mr4672720qcn.255.1286003212105; Sat, 02 Oct 2010 00:06:52 -0700 (PDT) Received: by 10.229.191.132 with HTTP; Sat, 2 Oct 2010 00:06:52 -0700 (PDT) Date: Sat, 2 Oct 2010 00:06:52 -0700 Message-ID: From: Rumen Telbizov To: freebsd-stable@freebsd.org Content-Type: text/plain; charset=ISO-8859-1 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: MySQL performance concern X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 02 Oct 2010 07:37:42 -0000 Hello everyone, I am experimenting with MySQL running on FreeBSD and comparing with another (older) setup running on a Linux box. My results show that performance on Linux is significantly better than FreeBSD although the hardware is weaker. I'd appreciate your comments and ideas. Here's the setup: 1) FreeBSD 8.1-STABLE amd64 (Tue Sep 14 15:29:22 PDT 2010) running on a SuperMicro machine with 2 x Dual Core Xeon E5502 1.87Ghz ; 4 x SAS 15K in RAID10 setup under ZFS (two mirrored pairs) and 2 x SSD X25-E partitioned for: 8G for ZIL and the rest for L2ARC; 16G ram with 8 of them given to mysql and tons of free. 2) Linux Gentoo with 3 SATA disks in hardware RAID5 with similar cpu/motherboard and same memory size. The sole application that runs is a python script which inserts a batch of lines at a time. Only myisam is used as a format. Here's the problem: On the Linux box it manages to push around *5800*inserts/second while on the FreeBSD box it's only *4000/*second. MySQL version is 5.1.51 During this load the disk subsystem on FreeBSD is pretty much idle (both the SSDs and the SAS disks). CPU utilization contributed to mysqld is only around 30%. So I am clearly heavily under-utilizing the hardware. Linuxthreads support for 64bit architectures is not available so I couldn't try that but aside from that I tried recompiling mysql with all the different Makefile options available without any effect. Changing the recordsize in zfs to 8K doesn't make any difference. Tried percona binary without any luck. Let me know what additional information would be useful and I'll provide it here. Thank you in advance for your comments and suggestions. Cheers, Rumen Telbizov