Date: Thu, 23 Nov 2006 18:49:50 +0300 (MSK) From: Alexander Zhuravlev <zaa@zaa.pp.ru> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/105788: [NEW PORT] databases/mysqlsla Mysqlsla analyzes general, slow, and raw MySQL statement logs Message-ID: <20061123154950.364C0B816@wave.zaa.local> Resent-Message-ID: <200611231600.kANG0Y1P007733@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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 <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?20061123154950.364C0B816>