Date: Thu, 30 Apr 2009 01:54:48 -0700 (PDT) From: Andrey Ignatov <rdna@rdna.ru> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/134107: [NEW PORT] databases/mysqlidxchk Checks MySQL databases/tables for unused indexes Message-ID: <49f96758.0f975e0a.3b25.5eff@mx.google.com> Resent-Message-ID: <200904300930.n3U9U3O2001946@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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@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@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@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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?49f96758.0f975e0a.3b25.5eff>