From owner-freebsd-stable@FreeBSD.ORG Wed Jul 27 10:55:19 2011 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 37BE0106566C for ; Wed, 27 Jul 2011 10:55:19 +0000 (UTC) (envelope-from ml@os2.kiev.ua) Received: from s1.sdv.com.ua (s1.sdv.com.ua [77.120.97.61]) by mx1.freebsd.org (Postfix) with ESMTP id ED1EF8FC0A for ; Wed, 27 Jul 2011 10:55:18 +0000 (UTC) Received: from 90-105-243-80.cust.centrio.cz ([80.243.105.90] helo=[192.168.100.107]) by s1.sdv.com.ua with esmtpsa (TLSv1:CAMELLIA256-SHA:256) (Exim 4.76 (FreeBSD)) (envelope-from ) id 1Qm1lj-000JyF-3t for freebsd-stable@freebsd.org; Wed, 27 Jul 2011 13:55:17 +0300 Message-ID: <4E2FEE8C.4020607@os2.kiev.ua> Date: Wed, 27 Jul 2011 12:55:08 +0200 From: Alex Samorukov User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.18) Gecko/20110617 Lightning/1.0b2 Thunderbird/3.1.11 MIME-Version: 1.0 To: freebsd-stable@freebsd.org Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-SA-Score: -1.0 Subject: dtrace/mysqld 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: Wed, 27 Jul 2011 10:55:19 -0000 If anyone interested - i was able to compile dtrace support in mysql-server55 port. During this i found a bug in dtrace/bsd - if it is running more then 1 time on the same object (this is the case for mysqld) then object is broken. I was able to do workaround (with preserving original object and then copying it) and then everything compiled and started correctly. This is an example: bsd# ./work/mysql-5.5.14/support-files/dtrace/query-time.d dtrace: buffer size lowered to 2m Who Database Query Time(ms) root@localhost mysql select sleep(1) from user limit 1 1000 root@localhost mysql select * from user limit 1 0 I will try to cleanup my patches (its currently very dirty hacks) and submit them to the mysql bugtracker (and port). Feel free to contact me if you want to test this (or to fix dtrace/obects bug).