I gave up using CGI.pm years ago when I went to mod_perl and never looked back. I use $r->args() or Apache::Request. I don't think the performance difference you describe is enough to merit choosing one way of reading args over the other. Pick whichever one is easier to read for you. Either way, I think CGI.pm will give you an array ref if you send in identically named args.

Are you using Apache::DBI? That would explain why you have connections open to MySQL.

As for the timing, it's hard to say based on the code you've shown. It's possible that some processes are failing to get database connections, or your machine is swapping, or any number of other things. Your plan to take things out until it stops and then slowly add them back in is a good idea. That always works for me.

In reply to Re: Re: "caching" issue with mod_perl? by perrin
in thread "caching" issue with mod_perl? by hacker

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.