From owner-freebsd-ports-bugs@FreeBSD.ORG Thu Nov 23 16:00:36 2006 Return-Path: X-Original-To: freebsd-ports-bugs@hub.freebsd.org Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id A228116A494 for ; Thu, 23 Nov 2006 16:00:36 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [69.147.83.40]) by mx1.FreeBSD.org (Postfix) with ESMTP id B822243D68 for ; Thu, 23 Nov 2006 15:59:58 +0000 (GMT) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.13.4/8.13.4) with ESMTP id kANG0YV1007734 for ; Thu, 23 Nov 2006 16:00:34 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.13.4/8.13.4/Submit) id kANG0Y1P007733; Thu, 23 Nov 2006 16:00:34 GMT (envelope-from gnats) Resent-Date: Thu, 23 Nov 2006 16:00:34 GMT Resent-Message-Id: <200611231600.kANG0Y1P007733@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Alexander Zhuravlev Received: from mx1.FreeBSD.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 45D9A16A4A7 for ; Thu, 23 Nov 2006 15:50:38 +0000 (UTC) (envelope-from zaa@zaa.pp.ru) Received: from kernel.ulstu.ru (kernel.ulstu.ru [62.76.34.36]) by mx1.FreeBSD.org (Postfix) with ESMTP id 32C7A43DB4 for ; Thu, 23 Nov 2006 15:49:28 +0000 (GMT) (envelope-from zaa@zaa.pp.ru) Received: from localhost (localhost [127.0.0.1]) by kernel.ulstu.ru (ulstuMail) with ESMTP id 8487E4AEDE; Thu, 23 Nov 2006 18:49:55 +0300 (MSK) Received: from kernel.ulstu.ru ([127.0.0.1]) by localhost (kernel.ulstu.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id lQk264IFoPK5; Thu, 23 Nov 2006 18:49:49 +0300 (MSK) Received: from wave.zaa.local (zaa.ulstu.ru [62.76.34.17]) by kernel.ulstu.ru (ulstuMail) with ESMTP id E0CD04AECA for ; Thu, 23 Nov 2006 18:49:46 +0300 (MSK) Received: by wave.zaa.local (Postfix, from userid 3909) id 364C0B816; Thu, 23 Nov 2006 18:49:50 +0300 (MSK) Message-Id: <20061123154950.364C0B816@wave.zaa.local> Date: Thu, 23 Nov 2006 18:49:50 +0300 (MSK) From: Alexander Zhuravlev To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: Subject: ports/105788: [NEW PORT] databases/mysqlsla Mysqlsla analyzes general, slow, and raw MySQL statement logs X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Alexander Zhuravlev List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 23 Nov 2006 16:00:36 -0000 >Number: 105788 >Category: ports >Synopsis: [NEW PORT] databases/mysqlsla Mysqlsla analyzes general, slow, and raw MySQL statement logs >Confidential: no >Severity: non-critical >Priority: medium >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Thu Nov 23 16:00:33 GMT 2006 >Closed-Date: >Last-Modified: >Originator: Alexander Zhuravlev >Release: FreeBSD 6.2-PRERELEASE i386 >Organization: >Environment: System: FreeBSD wave.zaa.local 6.2-PRERELEASE FreeBSD 6.2-PRERELEASE #34: Thu Nov 23 16:32:08 MSK 2006 root@wave.zaa.local:/usr/obj/usr/src/sys/WAVE i386 >Description: mysqlsla analyzes general, slow, and raw MySQL statement logs. mysqlsla can read multiple MySQL general and slow logs (and logs containing raw SQL statements), combine them, then run various analyses on all the queries. In addition, mysqlsla can correlate the analyses so that the queries in one analysis are used as the basis for subsequent analyses. Other options include limiting the output of each analysis to the top N queries, averaging execution time over N runs, customizing the order in which the analyses are ran, statement filtering, statement pattern matching, and mysqldumpslow-like formatting. >How-To-Repeat: >Fix: --- mysqlsla.port begins here --- # This is a shell archive. Save it in a file, remove anything before # this line, and then unpack it by entering "sh file". Note, it may # create directories; files and directories will be owned by you and # have default permissions. # # This archive contains: # # mysqlsla/ # mysqlsla/pkg-descr # mysqlsla/distinfo # mysqlsla/Makefile # mysqlsla/files # mysqlsla/files/patch-mysqlsla # echo c - mysqlsla/ mkdir -p mysqlsla/ > /dev/null 2>&1 echo x - mysqlsla/pkg-descr sed 's/^X//' >mysqlsla/pkg-descr << 'END-of-mysqlsla/pkg-descr' Xmysqlsla analyzes general, slow, and raw MySQL statement logs. Xmysqlsla can read multiple MySQL general and slow logs (and logs Xcontaining raw SQL statements), combine them, then run various Xanalyses on all the queries. In addition, mysqlsla can correlate Xthe analyses so that the queries in one analysis are used as the Xbasis for subsequent analyses. Other options include limiting the Xoutput of each analysis to the top N queries, averaging execution Xtime over N runs, customizing the order in which the analyses are Xran, statement filtering, statement pattern matching, and Xmysqldumpslow-like formatting. X XWWW: http://hackmysql.com/mysqlsla END-of-mysqlsla/pkg-descr echo x - mysqlsla/distinfo sed 's/^X//' >mysqlsla/distinfo << 'END-of-mysqlsla/distinfo' XMD5 (mysqlsla-1.3.tgz) = fc426c50e084e3be5aedfccd6f395fac XSHA256 (mysqlsla-1.3.tgz) = bd286d4071de17a04cfafaccae05bdab9fb9089cafe626d0b6fba14b46eba7a0 XSIZE (mysqlsla-1.3.tgz) = 14372 END-of-mysqlsla/distinfo echo x - mysqlsla/Makefile sed 's/^X//' >mysqlsla/Makefile << 'END-of-mysqlsla/Makefile' X# New ports collection makefile for: mysqlsla X# Date created: 2006-11-23 X# Whom: Alexander Zhuravlev X# X# $FreeBSD$ X XPORTNAME= mysqlsla XPORTVERSION= 1.3 XCATEGORIES= databases XMASTER_SITES= http://hackmysql.com/scripts/ XEXTRACT_SUFX= .tgz X XMAINTAINER= zaa@zaa.pp.ru XCOMMENT= Mysqlsla analyzes general, slow, and raw MySQL statement logs X XRUN_DEPENDS= ${SITE_PERL}/${PERL_ARCH}/Term/ReadKey.pm:${PORTSDIR}/devel/p5-Term-ReadKey \ X ${SITE_PERL}/${PERL_ARCH}/DBD/mysql.pm:${PORTSDIR}/databases/p5-DBD-mysql X XUSE_PERL5= yes XNO_BUILD= yes XNO_WRKSUBDIR= yes X XPLIST_FILES= bin/mysqlsla XPORTDOCS= mysqlsladoc.html X X.include X X.if ${PERL_LEVEL} < 500805 XRUN_DEPENDS+= ${SITE_PERL}/${PERL_ARCH}/Time/HiRes.pm:${PORTSDIR}/devel/p5-Time-HiRes X.endif X Xdo-install: X @${INSTALL_SCRIPT} ${WRKSRC}/mysqlsla ${PREFIX}/bin X X.if !defined(NOPORTDOCS) X @${ECHO_MSG} "===> Installing documentation for ${PKGNAME}" X @${MKDIR} ${DOCSDIR} X. for i in ${PORTDOCS} X @${INSTALL_DATA} ${WRKSRC}/${i} ${DOCSDIR} X. endfor X.endif X X.include END-of-mysqlsla/Makefile echo c - mysqlsla/files mkdir -p mysqlsla/files > /dev/null 2>&1 echo x - mysqlsla/files/patch-mysqlsla sed 's/^X//' >mysqlsla/files/patch-mysqlsla << 'END-of-mysqlsla/files/patch-mysqlsla' X--- mysqlsla.orig Thu Nov 23 18:31:31 2006 X+++ mysqlsla Thu Nov 23 18:31:47 2006 X@@ -115,7 +115,7 @@ if( (!$op{'general'} && !$op{'slow'} && X X $op{'host'} ||= 'localhost'; X $op{'port'} ||= 3306; X-$op{'socket'} ||= '/var/run/mysqld/mysqld.sock'; X+$op{'socket'} ||= '/tmp/mysql.sock'; X $op{'avg'} ||= 1; X $op{'top'} ||= 0; X if(have_op 'safe') { $op{'filter'} = "-*,+SELECT,+USE"; } END-of-mysqlsla/files/patch-mysqlsla exit --- mysqlsla.port ends here --- >Release-Note: >Audit-Trail: >Unformatted: