Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Memory usage with Perl/MySQL

by Anonymous Monk
on Feb 21, 2014 at 15:21 UTC ( [id://1075740]=perlquestion: print w/replies, xml ) Need Help??

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Sorry about the open ended question. I am looking for advice/direction. I wrote some CGI scripts a while back in Perl. The scripts use DBI to access MySQL. I suspect that the scripts are rather badly written. The scripts work, but once in a while they take enough memory to crash MySQL.

I would like to be able to narrow down the areas in my scripts which cause the problems. I am trying to see if there are any tools/methods can I use to detect this.

Replies are listed 'Best First'.
Re: Memory usage with Perl/MySQL
by ww (Archbishop) on Feb 21, 2014 at 16:08 UTC
      The OS is Linux
Re: Memory usage with Perl/MySQL
by stonecolddevin (Parson) on Feb 24, 2014 at 01:31 UTC

    MySQL has several ways to view query statuses. Look through the queries being run and see what optimizations need to be taken.

    Three thousand years of beautiful tradition, from Moses to Sandy Koufax, you're god damn right I'm living in the fucking past

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://1075740]
Approved by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (5)
As of 2024-03-28 23:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found