Date: Mon, 27 Nov 2006 12:03:51 +0300 (MSK) From: Alexander Zhuravlev <zaa@zaa.pp.ru> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/105905: [New Port] databases/mysqlsla Mysqlsla analyzes general, slow, and raw MySQL statement logs Message-ID: <20061127090351.1E38F1AF2@orion.ulstu.ru> Resent-Message-ID: <200611270910.kAR9ANGB080794@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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 <zaa@zaa.pp.ru> 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 <bsd.port.pre.mk> 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 <bsd.port.post.mk> 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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20061127090351.1E38F1AF2>