From owner-freebsd-ports-bugs@FreeBSD.ORG Mon Nov 27 09:10:26 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 8008A16A407 for ; Mon, 27 Nov 2006 09:10:26 +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 BC9E843D6B for ; Mon, 27 Nov 2006 09:09:24 +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 kAR9ANJt080795 for ; Mon, 27 Nov 2006 09:10:23 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.13.4/8.13.4/Submit) id kAR9ANGB080794; Mon, 27 Nov 2006 09:10:23 GMT (envelope-from gnats) Resent-Date: Mon, 27 Nov 2006 09:10:23 GMT Resent-Message-Id: <200611270910.kAR9ANGB080794@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 988F316A47E for ; Mon, 27 Nov 2006 09:04:04 +0000 (UTC) (envelope-from zaa@ulstu.ru) Received: from kernel.ulstu.ru (kernel.ulstu.ru [62.76.34.36]) by mx1.FreeBSD.org (Postfix) with ESMTP id EE2A943D60 for ; Mon, 27 Nov 2006 09:02:59 +0000 (GMT) (envelope-from zaa@ulstu.ru) Received: from localhost (localhost [127.0.0.1]) by kernel.ulstu.ru (ulstuMail) with ESMTP id 05BBC4AE4D; Mon, 27 Nov 2006 12:03:57 +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 8bIYDlTnGtFn; Mon, 27 Nov 2006 12:03:51 +0300 (MSK) Received: from orion.ulstu.ru (orion.ulstu.ru [62.76.34.33]) by kernel.ulstu.ru (ulstuMail) with ESMTP id 123B04AE4C for ; Mon, 27 Nov 2006 12:03:51 +0300 (MSK) Received: by orion.ulstu.ru (Postfix, from userid 3909) id 1E38F1AF2; Mon, 27 Nov 2006 12:03:51 +0300 (MSK) Message-Id: <20061127090351.1E38F1AF2@orion.ulstu.ru> Date: Mon, 27 Nov 2006 12:03:51 +0300 (MSK) From: Alexander Zhuravlev To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: Subject: ports/105905: [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: Mon, 27 Nov 2006 09:10:26 -0000 >Number: 105905 >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: Mon Nov 27 09:10:23 GMT 2006 >Closed-Date: >Last-Modified: >Originator: Alexander Zhuravlev >Release: FreeBSD 4.11-STABLE i386 >Organization: >Environment: System: FreeBSD orion.ulstu.ru 4.11-STABLE FreeBSD 4.11-STABLE #29: Thu Oct 12 01:23:20 MSD 2006 root@orion.ulstu.ru:/usr/obj/usr/src/sys/ORION i386 >Description: >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: