Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

OT: MySQL performance when the problem isn't Perl

by dws (Chancellor)
on Jun 03, 2002 at 20:41 UTC ( #171329=perlmeditation: print w/ replies, xml ) Need Help??

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
Re: OT: MySQL performance when the problem isn't Perl
by BUU (Prior) on Jun 03, 2002 at 21:20 UTC
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.
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

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!
(wil) Re: OT: MySQL performance when the problem isn't Perl
by wil (Priest) on Jun 05, 2002 at 22:43 UTC

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlmeditation [id://171329]
Approved by VSarkiss
Front-paged by crazyinsomniac
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (2)
As of 2014-09-18 02:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (105 votes), past polls