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
p5-Class-DBI Simple Database Abstraction
3.0.17_3 databases on this many watch lists=10 search for ports that depend on this port Find issues related to this port Report an issue related to this port 3.0.17Version of this port present on the latest quarterly branch.
Maintainer: perl@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2002-05-27 09:45:11
Last Update: 2018-10-06 14:06:45
SVN Revision: 481365
Also Listed In: perl5
License: ART10 GPLv1+
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (33 items)
  1. /usr/local/share/licenses/p5-Class-DBI-3.0.17_3/catalog.mk
  2. /usr/local/share/licenses/p5-Class-DBI-3.0.17_3/LICENSE
  3. /usr/local/share/licenses/p5-Class-DBI-3.0.17_3/ART10
  4. /usr/local/share/licenses/p5-Class-DBI-3.0.17_3/GPLv1+
  5. lib/perl5/site_perl/Class/DBI.pm
  6. lib/perl5/site_perl/Class/DBI/Attribute.pm
  7. lib/perl5/site_perl/Class/DBI/Cascade/Delete.pm
  8. lib/perl5/site_perl/Class/DBI/Cascade/Fail.pm
  9. lib/perl5/site_perl/Class/DBI/Cascade/None.pm
  10. lib/perl5/site_perl/Class/DBI/Column.pm
  11. lib/perl5/site_perl/Class/DBI/ColumnGrouper.pm
  12. lib/perl5/site_perl/Class/DBI/Iterator.pm
  13. lib/perl5/site_perl/Class/DBI/Query.pm
  14. lib/perl5/site_perl/Class/DBI/Relationship.pm
  15. lib/perl5/site_perl/Class/DBI/Relationship/HasA.pm
  16. lib/perl5/site_perl/Class/DBI/Relationship/HasMany.pm
  17. lib/perl5/site_perl/Class/DBI/Relationship/MightHave.pm
  18. lib/perl5/site_perl/Class/DBI/SQL/Transformer.pm
  19. lib/perl5/site_perl/Class/DBI/Search/Basic.pm
  20. lib/perl5/site_perl/Class/DBI/Test/SQLite.pm
  21. lib/perl5/site_perl/man/man3/Class::DBI.3.gz
  22. lib/perl5/site_perl/man/man3/Class::DBI::Attribute.3.gz
  23. lib/perl5/site_perl/man/man3/Class::DBI::Cascade::Delete.3.gz
  24. lib/perl5/site_perl/man/man3/Class::DBI::Cascade::Fail.3.gz
  25. lib/perl5/site_perl/man/man3/Class::DBI::Cascade::None.3.gz
  26. lib/perl5/site_perl/man/man3/Class::DBI::Column.3.gz
  27. lib/perl5/site_perl/man/man3/Class::DBI::ColumnGrouper.3.gz
  28. lib/perl5/site_perl/man/man3/Class::DBI::Iterator.3.gz
  29. lib/perl5/site_perl/man/man3/Class::DBI::Query.3.gz
  30. lib/perl5/site_perl/man/man3/Class::DBI::Relationship.3.gz
  31. lib/perl5/site_perl/man/man3/Class::DBI::SQL::Transformer.3.gz
  32. lib/perl5/site_perl/man/man3/Class::DBI::Search::Basic.3.gz
  33. lib/perl5/site_perl/man/man3/Class::DBI::Test::SQLite.3.gz
Collapse this list.
Dependency lines:
  • p5-Class-DBI>0:databases/p5-Class-DBI
To install the port: cd /usr/ports/databases/p5-Class-DBI/ && make install clean
To add the package: pkg install p5-Class-DBI
PKGNAME: p5-Class-DBI
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. p5-Class-Accessor>=0 : devel/p5-Class-Accessor
  2. p5-Class-Data-Inheritable>=0 : devel/p5-Class-Data-Inheritable
  3. p5-Class-Trigger>=0 : devel/p5-Class-Trigger
  4. p5-Clone>=0 : devel/p5-Clone
  5. p5-Ima-DBI>=0 : databases/p5-Ima-DBI
  6. p5-UNIVERSAL-moniker>=0 : devel/p5-UNIVERSAL-moniker
  7. perl5>=5.26<5.27 : lang/perl5.26
  8. perl5>=5.26<5.27 : lang/perl5.26
Runtime dependencies:
  1. p5-Class-Accessor>=0 : devel/p5-Class-Accessor
  2. p5-Class-Data-Inheritable>=0 : devel/p5-Class-Data-Inheritable
  3. p5-Class-Trigger>=0 : devel/p5-Class-Trigger
  4. p5-Clone>=0 : devel/p5-Clone
  5. p5-Ima-DBI>=0 : databases/p5-Ima-DBI
  6. p5-UNIVERSAL-moniker>=0 : devel/p5-UNIVERSAL-moniker
  7. perl5>=5.26<5.27 : lang/perl5.26
This port is required by:
for Build
  1. databases/p5-Class-DBI-AbstractSearch
  2. databases/p5-Class-DBI-AsForm
  3. databases/p5-Class-DBI-AutoLoader
  4. databases/p5-Class-DBI-BaseDSN
  5. databases/p5-Class-DBI-DATA-Schema
  6. databases/p5-Class-DBI-DDL
  7. databases/p5-Class-DBI-FromCGI
Expand this list (34 items / 27 hidden)
  1. databases/p5-Class-DBI-LazyInflate
  2. databases/p5-Class-DBI-Loader
  3. databases/p5-Class-DBI-Oracle
  4. databases/p5-Class-DBI-Pager
  5. databases/p5-Class-DBI-Pg
  6. databases/p5-Class-DBI-Plugin
  7. databases/p5-Class-DBI-Plugin-AbstractCount
  8. databases/p5-Class-DBI-Plugin-DeepAbstractSearch
  9. databases/p5-Class-DBI-Plugin-Iterator
  10. databases/p5-Class-DBI-Plugin-Pager
  11. databases/p5-Class-DBI-Plugin-RetrieveAll
  12. databases/p5-Class-DBI-Plugin-Senna
  13. databases/p5-Class-DBI-Plugin-Type
  14. databases/p5-Class-DBI-Replication
  15. databases/p5-Class-DBI-SAK
  16. databases/p5-Class-DBI-SQLite
  17. databases/p5-Class-DBI-Sweet
  18. databases/p5-Class-DBI-ToSax
  19. databases/p5-Class-DBI-Untaint
  20. databases/p5-Class-DBI-mysql
  21. lang/p5-JSAN
  22. www/p5-Catalyst-Enzyme
  23. www/p5-Catalyst-Helper-Controller-Scaffold
  24. www/p5-Catalyst-Model-CDBI
  25. www/p5-Catalyst-Model-CDBI-Plain
  26. www/p5-Class-DBI-FromForm
  27. www/p5-Maypole
  28. Collapse this list.
for Run
  1. databases/p5-Class-DBI-AbstractSearch
  2. databases/p5-Class-DBI-AsForm
  3. databases/p5-Class-DBI-AutoLoader
  4. databases/p5-Class-DBI-BaseDSN
  5. databases/p5-Class-DBI-DATA-Schema
  6. databases/p5-Class-DBI-DDL
  7. databases/p5-Class-DBI-FromCGI
Expand this list (32 items / 25 hidden)
  1. databases/p5-Class-DBI-LazyInflate
  2. databases/p5-Class-DBI-Loader
  3. databases/p5-Class-DBI-Oracle
  4. databases/p5-Class-DBI-Pager
  5. databases/p5-Class-DBI-Pg
  6. databases/p5-Class-DBI-Plugin
  7. databases/p5-Class-DBI-Plugin-AbstractCount
  8. databases/p5-Class-DBI-Plugin-DeepAbstractSearch
  9. databases/p5-Class-DBI-Plugin-Pager
  10. databases/p5-Class-DBI-Plugin-RetrieveAll
  11. databases/p5-Class-DBI-Plugin-Type
  12. databases/p5-Class-DBI-Replication
  13. databases/p5-Class-DBI-SAK
  14. databases/p5-Class-DBI-SQLite
  15. databases/p5-Class-DBI-Sweet
  16. databases/p5-Class-DBI-ToSax
  17. databases/p5-Class-DBI-Untaint
  18. databases/p5-Class-DBI-mysql
  19. lang/p5-JSAN
  20. net-mgmt/netdot
  21. www/p5-Catalyst-Enzyme
  22. www/p5-Catalyst-Helper-Controller-Scaffold
  23. www/p5-Catalyst-Model-CDBI
  24. www/p5-Class-DBI-FromForm
  25. www/p5-Maypole
  26. Collapse this list.

Configuration Options

USES:

Master Sites:
  1. ftp://ftp.auckland.ac.nz/pub/perl/CPAN/modules/by-module/Class/
  2. ftp://ftp.cpan.org/pub/CPAN/modules/by-module/
  3. ftp://ftp.cpan.org/pub/CPAN/modules/by-module/Class/
  4. ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module/Class/
  5. ftp://ftp.kddlabs.co.jp/lang/perl/CPAN/modules/by-module/Class/
  6. ftp://ftp.mirrorservice.org/sites/cpan.perl.org/CPAN/modules/by-module/Class/
  7. http://backpan.perl.org/modules/by-module/Class/
  8. http://ftp.jaist.ac.jp/pub/CPAN/modules/by-module/Class/
  9. http://ftp.twaren.net/Unix/Lang/CPAN/modules/by-module/Class/
  10. https://cpan.metacpan.org/modules/by-module/
  11. https://cpan.metacpan.org/modules/by-module/Class/
  12. https://www.cpan.org/modules/by-module/Class/

Number of commits found: 47

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
06 Oct 2018 13:06:45
Original commit files touched by this commit  3.0.17_3
Revision:481365
des search for other commits by this committer
Fix every instance of RUN_DEPENDS:=${BUILD_DEPENDS} in p5 ports, except
for where it resulted in a change in output from build-depends-list or
run-depends-list.

Approved by:	portmgr (adamw)
27 May 2018 20:15:20
Original commit files touched by this commit  3.0.17_3
Revision:470993
sunpoet search for other commits by this committer
Update WWW

search.cpan.org is shutting down.
It will redirect to metacpan.org after June 25, 2018.

With hat:	perl
28 Feb 2018 15:12:28
Original commit files touched by this commit  3.0.17_3
Revision:463216
sunpoet search for other commits by this committer
Add LICENSE

- Add NO_ARCH
24 Feb 2018 14:02:00
Original commit files touched by this commit  3.0.17_3
Revision:462819
sunpoet search for other commits by this committer
Remove outdated post-configure:
01 Apr 2016 14:00:57
Original commit files touched by this commit  3.0.17_3
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
12 Mar 2015 23:00:03
Original commit files touched by this commit  3.0.17_3
Revision:381151
adamw search for other commits by this committer
Some OCD cleanups on some of the perl@ ports.

- Remove dependencies in core
- Put testing depends in TEST_DEPENDS
- Remove unnecessary bsd.port.options.mk inclusions
- Remove checks for Perl versions that no longer exist in the ports tree
- Sort plists, some of which were so jumbled that I have to assume
  the plist was randomized before committing

A lot of the plist changes in this commit are moving PERL5_MAN3 after
SITE_PERL. It's repo churn now, but it makes updating the ports later
far easier.
26 Nov 2014 13:08:38
Original commit files touched by this commit  3.0.17_2
Revision:373448
mat search for other commits by this committer
Change the way Perl modules are installed, update the default Perl to 5.18.

Before, we had:

  site_perl :           lib/perl5/site_perl/5.18
  site_perl/perl_arch : lib/perl5/site_perl/5.18/mach
  perl_man3 :           lib/perl5/5.18/man/man3

Now we have:

  site_perl : lib/perl5/site_perl
  site_arch : lib/perl5/site_perl/mach/5.18
  perl_man3 : lib/perl5/site_perl/man/man3

Modules without any .so will be installed at the same place regardless of the
(Only the first 15 lines of the commit message are shown above View all of this commit message)
20 Oct 2014 10:41:13
Original commit files touched by this commit  3.0.17_1
Revision:371255
bapt search for other commits by this committer
Cleanup plist
03 Nov 2013 06:53:55
Original commit files touched by this commit  3.0.17_1
Revision:332592
vanilla search for other commits by this committer
Support STAGEDIR.
20 Sep 2013 16:13:49
Original commit files touched by this commit  3.0.17_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)
02 Aug 2013 18:52:11
Original commit files touched by this commit  3.0.17_1
Revision:324174
mat search for other commits by this committer
- Convert to new perl framework
- Trim Makefile header
- Remove MAKE_JOBS_SAFE=yes, it's the default.
03 Jun 2012 18:57:30
Original commit files touched by this commit  3.0.17_1

crees search for other commits by this committer
SITE_PERL --> package dependencies, chunks 2-3

Submitted by:   az
07 May 2012 15:42:51
Original commit files touched by this commit  3.0.17_1

skv search for other commits by this committer
Pass maintainership of almost of my "p5-*" ports to "perl@".

(I hope updating of them will be improved).
21 Jan 2012 17:40:15
Original commit files touched by this commit  3.0.17_1

eadler search for other commits by this committer
At the moment 1385 ports use BUILD_DEPENDS= ${RUN_DEPENDS} and 450
ports use BUILD_DEPENDS:= ${RUN_DEPENDS}. This patch fixes ports that are
currently broken. This is a temporary measure until we organically stop using
:= or someone(s) spend a lot of time changing all the ports over.

Explicit duplication > := > = and this just moves ports one step to the left

Approved by:    portmgr
20 Mar 2011 12:54:45
Original commit files touched by this commit  3.0.17_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  3.0.17_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)
17 Apr 2008 14:30:31
Original commit files touched by this commit  3.0.17

araujo search for other commits by this committer
- Take advantage of CPAN macro from bsd.sites.mk, change
${MASTER_SITE_PERL_CPAN} to CPAN.

PR:             ports/122674
Submitted by:   Philip M. Gollucci <pgollucci@p6m7g8.com>
Reworked by:    araujo (myself)
Approved by:    portmgr (pav)
15 Jan 2008 21:49:48
Original commit files touched by this commit  3.0.17

skv search for other commits by this committer
Update to 3.0.17
08 Sep 2007 00:54:37
Original commit files touched by this commit  3.0.16

linimon search for other commits by this committer
Welcome bsd.perl.mk.  Add support for constructs such as USE_PERL5=5.8.0+.
Drop support for antique perl.

Work done by:   gabor
Sponsored by:   Google Summer of Code 2007
Hat:            portmgr
20 Nov 2006 07:45:48
Original commit files touched by this commit  3.0.16

skv search for other commits by this committer
Update to 3.0.16

Changes:        http://search.cpan.org/src/TMTM/Class-DBI-v3.0.16/Changes
23 Aug 2006 15:57:55
Original commit files touched by this commit  3.0.15

skv search for other commits by this committer
Update to 3.0.15

PR:             ports/102330
Submitted by:   Gea-Suan Lin <gslin xx gslin.org>
22 Jan 2006 01:29:10
Original commit files touched by this commit  3.0.14

edwin search for other commits by this committer
Replace ugly "@unexec rmdir %D... 2>/dev/null || true" with @dirrmtry

Approved by:    krion@
PR:             ports/88711 (related)
18 Jan 2006 13:04:11
Original commit files touched by this commit  3.0.14

skv search for other commits by this committer
Update to 3.0.14

Changes:        http://search.cpan.org/src/TMTM/Class-DBI-v3.0.14/Changes
29 Dec 2005 13:40:27
Original commit files touched by this commit  3.0.13_1

skv search for other commits by this committer
Add missed dependency: devel/p5-Clone.

Pointed by:     kuriyama [by email], fenner [PR 90991]
16 Dec 2005 09:10:12
Original commit files touched by this commit  3.0.13

skv search for other commits by this committer
Update to 3.0.13

Changes:        http://search.cpan.org/src/TMTM/Class-DBI-v3.0.13/Changes
08 Nov 2005 17:32:00
Original commit files touched by this commit  3.0.12

skv search for other commits by this committer
Update to 3.0.12

Changes:        http://search.cpan.org/src/TMTM/Class-DBI-v3.0.12/Changes
12 Oct 2005 11:00:53
Original commit files touched by this commit  3.0.10

skv search for other commits by this committer
Update to 3.0.10

Changes:        http://search.cpan.org/src/TMTM/Class-DBI-v3.0.10/Changes
PR:             ports/87252
Submitted by:   Gabor Kovesdan <gabor.kovesdan * t-hosting.hu>
11 Oct 2005 06:20:25
Original commit files touched by this commit  3.0.9

kris search for other commits by this committer
BROKEN: Incomplete pkg-plist
06 Oct 2005 11:09:44
Original commit files touched by this commit  3.0.9

skv search for other commits by this committer
Update to 3.0.9

Changes:        http://search.cpan.org/src/TMTM/Class-DBI-v3.0.9/Changes
27 Sep 2005 16:21:45
Original commit files touched by this commit  3.0.8

leeym search for other commits by this committer
- backout previous commit
27 Sep 2005 14:44:48
Original commit files touched by this commit  3.0.8

leeym search for other commits by this committer
- fix plist
26 Sep 2005 14:56:19
Original commit files touched by this commit  3.0.8

skv search for other commits by this committer
Update to 3.0.8

Changes:        http://search.cpan.org/src/TMTM/Class-DBI-v3.0.8/Changes
16 Sep 2005 15:43:12
Original commit files touched by this commit  3.0.5

skv search for other commits by this committer
Fix plist.

Pointed by:     pointyhat (kris)
15 Sep 2005 10:28:07
Original commit files touched by this commit  3.0.5

skv search for other commits by this committer
Upgrade to 3.0.5, drop support for obsolete perl-5.00503

Changes:        http://search.cpan.org/src/TMTM/Class-DBI-v3.0.5/Changes
24 Oct 2004 17:29:18
Original commit files touched by this commit  0.96_2

skv search for other commits by this committer
Remove 'use warnings' if perl < 5.6.0

PR:             73086
Submitted by:   lth
12 Aug 2004 12:48:01
Original commit files touched by this commit  0.96_1

mat search for other commits by this committer
After devel/p5-File-Temp has gained an IGNORE for PERL_LEVEL > 500800, all
these ports were broken because they always depended on it. I've rearranged all
the dependencies to fit the new scheme.
11 Aug 2004 13:50:05
Original commit files touched by this commit  0.96_1

skv search for other commits by this committer
Add missing manpage

PR:             ports/70288
Submitted by:   Yen-Ming Lee <leeym@utopia.leeym.com>
12 Jul 2004 12:44:36
Original commit files touched by this commit  0.96

lth search for other commits by this committer
Update to 0.96

PR:             68291
Submitted by:   lth
Approved by:    maintainer
30 Mar 2004 13:39:33
Original commit files touched by this commit  0.95

mat search for other commits by this committer
Add 2 patches for 5.005.

Approved by:    maintainer timeout
01 Mar 2004 07:24:19
Original commit files touched by this commit  0.95

skv search for other commits by this committer
Updated to 0.95
02 Sep 2003 09:54:01
Original commit files touched by this commit  0.94

skv search for other commits by this committer
Update to 0.94
11 Jul 2003 17:15:54
Original commit files touched by this commit  0.93

skv search for other commits by this committer
Updated to 0.93

PR:             ports/54265
Submitted by:   Mathieu Arnold <m@absolight.net>
30 Apr 2003 14:55:37
Original commit files touched by this commit  0.92

skv search for other commits by this committer
Updated to 0.92

PR:     ports/51578
07 Mar 2003 05:58:32
Original commit files touched by this commit  0.90

ade search for other commits by this committer
Clear moonlight beckons.
Requiem mors pacem pkg-comment,
And be calm ports tree.

E Nomini Patri, E Fili, E Spiritu Sancti.
05 Feb 2003 11:52:53
Original commit files touched by this commit  0.90

skv search for other commits by this committer
Update to 0.90
25 Jun 2002 17:43:40
Original commit files touched by this commit  0.89

skv search for other commits by this committer
Updated to 0.89
27 May 2002 09:43:29
Original commit files touched by this commit  0.86

skv search for other commits by this committer
Add p5-Class-DBI 0.86, simple Database Abstraction.

Number of commits found: 47

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 39023
Broken 588
Deprecated 1068
Ignore 859
Forbidden 5
Restricted 151
No CDROM 72
Vulnerable 23
Expired 3
Set to expire 1038
Interactive 0
new 24 hours 6
new 48 hours19
new 7 days52
new fortnight107
new month169

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