ports/134107: [NEW PORT] databases/mysqlidxchk Checks MySQL databases/tables for unused indexes

[Andrey Ignatov]

>Number:         134107
>Category:       ports
>Synopsis:       [NEW PORT] databases/mysqlidxchk Checks MySQL databases/tables for unused indexes
>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 Apr 30 09:30:03 UTC 2009
>Closed-Date:
>Last-Modified:
>Originator:     Andrey Ignatov
>Release:        FreeBSD 7.1-PRERELEASE amd64
>Organization:
>Environment:
System: FreeBSD rdna.yandex.ru 7.1-PRERELEASE FreeBSD 7.1-PRERELEASE #3: Thu Mar 19 14:53:05 MSK 2009 root at rdna.yandex.ru:/usr/obj/usr/src/sys/RDNA amd64


>Description:
mysqlidxchk (MySQL Index Checker) checks MySQL databases/tables for
unused indexes. Given one or more slow, general, or "raw" log files,
mysqlidxchk reports which indexes in the database schema are not used
by the queries in the log files.
>How-To-Repeat:
>Fix:

--- mysqlidxchk.shar 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:
#
#	/usr/ports/databases/mysqlidxchk
#	/usr/ports/databases/mysqlidxchk/Makefile
#	/usr/ports/databases/mysqlidxchk/distinfo
#	/usr/ports/databases/mysqlidxchk/pkg-descr
#
echo c - /usr/ports/databases/mysqlidxchk
mkdir -p /usr/ports/databases/mysqlidxchk > /dev/null 2>&1
echo x - /usr/ports/databases/mysqlidxchk/Makefile
sed 's/^X//' >/usr/ports/databases/mysqlidxchk/Makefile << '3ce13b112294d717172e06885f9556ee'
X# New ports collection makefile for:	mysqlidxchk
X# Date created:				29 April 2009
X# Whom:					Andrey Ignatov <rdna at rdna.ru>
X#
X# $FreeBSD$
X#
X
XPORTNAME=	mysqlidxchk
XPORTVERSION=	1.0
XCATEGORIES=	databases
XMASTER_SITES=	http://hackmysql.com/scripts/
XEXTRACT_SUFX=	.tgz
X
XMAINTAINER=	rdna at rdna.ru
XCOMMENT=	Checks MySQL databases/tables for unused indexes
X
XRUN_DEPENDS=	${SITE_PERL}/${PERL_ARCH}/Term/ReadKey.pm:${PORTSDIR}/devel/p5-Term-ReadKey \
X		${SITE_PERL}/Getopt/Long.pm:${PORTSDIR}/devel/p5-Getopt-Long \
X		${SITE_PERL}/${PERL_ARCH}/DBI.pm:${PORTSDIR}/databases/p5-DBI \
X		${SITE_PERL}/${PERL_ARCH}/DBD/mysql.pm:${PORTSDIR}/databases/p5-DBD-mysql
X
XNO_WRKSUBDIR=	yes
X
XUSE_PERL5=	yes
XNO_BUILD=	yes
X
XPLIST_FILES=	bin/mysqlidxchk
XPORTDOCS=	mysqlidxchkdoc.html mysqlidxchkguide.html
X
Xdo-install:
X	@${INSTALL_SCRIPT} ${WRKSRC}/mysqlidxchk ${PREFIX}/bin
X
X.if !defined(NOPORTDOCS)
X	@${ECHO_MSG} "===>   Installing documentation for ${PKGNAME}"
X	@${MKDIR} ${DOCSDIR}
X	@${INSTALL_DATA} ${PORTDOCS:S,^,${WRKSRC}/,} ${DOCSDIR}
X.endif
X
X.include <bsd.port.mk>
3ce13b112294d717172e06885f9556ee
echo x - /usr/ports/databases/mysqlidxchk/distinfo
sed 's/^X//' >/usr/ports/databases/mysqlidxchk/distinfo << '002a30cd4671ff7c41a25b04c11d9d10'
XMD5 (mysqlidxchk-1.0.tgz) = 552f979a1e80d05671f57be6969996a9
XSHA256 (mysqlidxchk-1.0.tgz) = 6c5f6c7f93c2bb68cfdc2a36d63528d16e74989b0f9563f1025a833521561d96
XSIZE (mysqlidxchk-1.0.tgz) = 13683
002a30cd4671ff7c41a25b04c11d9d10
echo x - /usr/ports/databases/mysqlidxchk/pkg-descr
sed 's/^X//' >/usr/ports/databases/mysqlidxchk/pkg-descr << 'acda6e125869988df41ab4615caa8366'
Xmysqlidxchk (MySQL Index Checker) checks MySQL databases/tables for
Xunused indexes. Given one or more slow, general, or "raw" log files,
Xmysqlidxchk reports which indexes in the database schema are not used
Xby the queries in the log files.
X
XWWW: http://hackmysql.com/mysqlidxchk
acda6e125869988df41ab4615caa8366
exit
--- mysqlidxchk.shar ends here ---


>Release-Note:
>Audit-Trail:
>Unformatted: