ports/105834: [New Port] databases/mysqlsla Mysqlsla analyzes general, slow, and raw MySQL statement logs

[Alexander Zhuravlev]

>Number:         105834
>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:   Fri Nov 24 18:20:18 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 at 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.

	WWW: http://hackmysql.com/mysqlsla

>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 at 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 at 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: