notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Why was the website so slow for so long?

The cause of the slowdown was a change to the ZFS dataset. In conjunction with the database server, very little caching was being done. This combination resulted in increased disk I/O as the system churned through the database. Details in the blog post which outlines the various things which changed. Many graphs.

Port details
mysqlidxchk Checks MySQL databases/tables for unused indexes
1.0_1 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port 1.0Version of this port present on the latest quarterly branch.
Broken BROKEN: unfetchable
Deprecated DEPRECATED: Broken for more than 6 months
Expiration Date EXPIRATION DATE: 2020-05-05
Ignore IGNORE: is marked as broken: unfetchable
Maintainer: rdna@rdna.ru search for ports maintained by this maintainer
Port Added: 2009-05-01 21:44:42
Last Update: 2020-04-04 21:51:41
SVN Revision: 530719
License: not specified in port
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (1 items)
  1. bin/mysqlidxchk
Collapse this list.
Dependency lines:
  • mysqlidxchk>0:databases/mysqlidxchk
To install the port: cd /usr/ports/databases/mysqlidxchk/ && make install clean
A package is not available for ports marked as: Forbidden / Broken / Ignore / Restricted
PKGNAME: mysqlidxchk
Flavors: there is no flavor information for this port.
distinfo:

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. perl5>=5.30.r1<5.31 : lang/perl5.30
Runtime dependencies:
  1. p5-Term-ReadKey>=0 : devel/p5-Term-ReadKey
  2. p5-DBI>=0 : databases/p5-DBI
  3. p5-DBD-mysql>=0 : databases/p5-DBD-mysql
  4. perl5>=5.30.r1<5.31 : lang/perl5.30
There are no ports dependent upon this port

Configuration Options

USES:

Master Sites:
  1. http://hackmysql.com/scripts/

Number of commits found: 11

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
04 Apr 2020 20:51:41
Original commit files touched by this commit  1.0_1
Revision:530719  Sanity Test Failure
antoine search for other commits by this committer
Deprecate ports broken for more than 6 months
06 Nov 2019 12:48:32
Original commit files touched by this commit  1.0_1
Revision:516880  Sanity Test Failure
antoine search for other commits by this committer
Mark a few ports BROKEN, unfetchable
01 Apr 2016 14:00:57
Original commit files touched by this commit  1.0_1
Revision:412346
mat search for other commits by this committer
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight
29 Jul 2014 19:11:53
Original commit files touched by this commit  1.0_1
Revision:363374
adamw search for other commits by this committer
Convert a bunch of EXTRACT_SUFX=... into USES=tar:...

Approved by:	portmgr (not really, but touches unstaged ports)
20 Mar 2014 08:34:41
Original commit files touched by this commit  1.0_1
Revision:348667
ehaupt search for other commits by this committer
- Support staging
- Use shebangfix
- Define DOCS option
20 Sep 2013 16:13:49
Original commit files touched by this commit  1.0_1
Revision:327717
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
10 Sep 2013 13:04:02
Original commit files touched by this commit  1.0_1
Revision:326900
az search for other commits by this committer
- convert to the new perl5 framework
- trim Makefile header

Approved by:	portmgr (bapt@, blanket)
30 Jun 2012 14:48:31
Original commit files touched by this commit  1.0_1

az search for other commits by this committer
- Remove SITE_PERL from *_DEPENDS

Approved by: portmgr@ (bapt@)
20 Mar 2011 12:54:45
Original commit files touched by this commit  1.0_1

miwi search for other commits by this committer
- Get Rid MD5 support
29 Jan 2010 04:56:59
Original commit files touched by this commit  1.0_1

kuriyama search for other commits by this committer
- Remove unneeded dependencies which is in perl-5.8.9 dist
  (part 17).

Approved by:    portmgr (itetcu)
01 May 2009 21:44:10
Original commit files touched by this commit  1.0

miwi search for other commits by this committer
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.

WWW: http://hackmysql.com/mysqlidxchk

PR:             ports/134107
Submitted by:   Andrey Ignatov <rdna at rdna.ru>

Number of commits found: 11

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
apache24Apr 02
cactiApr 02
chromiumApr 02
haproxyApr 02
haproxy18Apr 02
haproxy19Apr 02
haproxy21Apr 02
rubygem-json*Apr 02
gnutlsMar 31
postgresql10-serverMar 29
postgresql11-serverMar 29
postgresql12-serverMar 29
postgresql96-serverMar 29
gitlab-ceMar 26
jenkinsMar 25

12 vulnerabilities affecting 110 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-04-02 20:42:28


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 39072
Broken 587
Deprecated 1065
Ignore 858
Forbidden 5
Restricted 151
No CDROM 72
Vulnerable 22
Expired 2
Set to expire 1033
Interactive 0
new 24 hours 8
new 48 hours17
new 7 days58
new fortnight114
new month183

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2020 Dan Langille. All rights reserved.