From owner-freebsd-ports-bugs@FreeBSD.ORG Thu Apr 30 09:30:04 2009 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 4DAF3106564A for ; Thu, 30 Apr 2009 09:30:04 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id D95FA8FC20 for ; Thu, 30 Apr 2009 09:30:03 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.3/8.14.3) with ESMTP id n3U9U3v8001947 for ; Thu, 30 Apr 2009 09:30:03 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.3/8.14.3/Submit) id n3U9U3O2001946; Thu, 30 Apr 2009 09:30:03 GMT (envelope-from gnats) Resent-Date: Thu, 30 Apr 2009 09:30:03 GMT Resent-Message-Id: <200904300930.n3U9U3O2001946@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Andrey Ignatov Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id CA8AD106566C for ; Thu, 30 Apr 2009 09:26:00 +0000 (UTC) (envelope-from rdna@rdna.ru) Received: from mail-bw0-f213.google.com (mail-bw0-f213.google.com [209.85.218.213]) by mx1.freebsd.org (Postfix) with ESMTP id 4AD898FC08 for ; Thu, 30 Apr 2009 09:26:00 +0000 (UTC) (envelope-from rdna@rdna.ru) Received: by bwz9 with SMTP id 9so1660983bwz.43 for ; Thu, 30 Apr 2009 02:25:59 -0700 (PDT) Received: by 10.204.97.204 with SMTP id m12mr1259358bkn.22.1241081690206; Thu, 30 Apr 2009 01:54:50 -0700 (PDT) Received: from localhost (dhcp170-128-red.yandex.net [95.108.170.128]) by mx.google.com with ESMTPS id y15sm2650076fkd.23.2009.04.30.01.54.48 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 30 Apr 2009 01:54:48 -0700 (PDT) Message-Id: <49f96758.0f975e0a.3b25.5eff@mx.google.com> Date: Thu, 30 Apr 2009 01:54:48 -0700 (PDT) From: Andrey Ignatov To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: Subject: ports/134107: [NEW PORT] databases/mysqlidxchk Checks MySQL databases/tables for unused indexes X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Andrey Ignatov List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 30 Apr 2009 09:30:04 -0000 >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 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 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: