Many of us deal with MySQL databases that are accessed exclusively via Perl. If performance isn't up to expectations, Perl can get blamed. To make matters worse, some of us get little or no DBA support when dealing with MySQL performance. ("You're not using Oracle|SQL Server? You're on your own.")

With that in mind, here is a no-direct-Perl-content recommendation for two Linux Magazine articles on MySQL performance (found via blakem's post about an upcoming Silicon Valley Perl Mongers talk):

There's stuff in here that can save you hours of pouring over the docs.

The author also has a presentation on Building Maintainable and Fault-Tolerant MySQL Applications with Perl.

  • Comment on OT: MySQL performance when the problem isn't Perl

Replies are listed 'Best First'.
Re: OT: MySQL performance when the problem isn't Perl
by BUU (Prior) on Jun 03, 2002 at 21:20 UTC
[reply]
Re: OT: MySQL performance when the problem isn't Perl
by derby (Abbot) on Jun 04, 2002 at 12:55 UTC
    dws++. And just announced on the dbi mailing list - DBI::Profile (may not be on cpan yet). A snippet from the pod: 

    The DBI::Profile module provides a simple interface to collect and
report performance and benchmarking data from the DBI.

    -derby

[reply]
Re: OT: MySQL performance when the problem isn't Perl
by Stegalex (Chaplain) on Jun 04, 2002 at 12:54 UTC
    You're not using Oracle|SQL Server? You're on your own

    As someone who deals with Oracle server, I often feel very much alone when it comes to diagnosing server problems as Oracle's frontline support gets worse with each passing year.

    That being said, my tuning woes have been ameliorated by throwing more memory at the problem in addition to common sense tips like putting indexes and tables on different physical disks and tuning the efficiency of my sql.

    ~~~~~~~~~~~~~~~
    I like chicken.
[reply]
Re: OT: MySQL performance when the problem isn't Perl
by dthacker (Deacon) on Jun 04, 2002 at 15:32 UTC
    I've been through the app vs DB meat grinder several times. My shop uses Informix. There is a wealth of tuning information available at the International Informix Users Group. Membership is available at no charge, and gives access to a software repository that contains a lot of useful tools.

    Dave

    Code On!
[reply]
(wil) Re: OT: MySQL performance when the problem isn't Perl
by wil (Priest) on Jun 05, 2002 at 22:43 UTC
[reply]

Back to Meditations