For about 5 years I've been using a set of scripts to download data from 2-300 remote sites and copy to a central DB. The main script forks 12 sub-scripts each of which brings down data from a specific location and uses DBI to write it locally. Once the data is copied, the sub-script exits. The main script cycles through the list running these 12 at a time. This has been all well and good with MySQL 5.1 and 5.5.

Page forward to about a month ago when I upgraded to v5.6. When running this same process it gets through 20-30 of the sub-scripts and then rejects every other connection until all remaining of the 2-300 have been finished. If I restart it the results are the same (20 or so and then errors for the rest).

Looking at the processlist on MySQL shows no more than 25 jobs at any given moment. There are no errors in the MySQL logs. If I set the fork limit to 5 jobs it gets through all of them without failing.
Suggestions on places to look for clues as to what is happening?

In reply to DBI + MySQL 5.6 = problems by ethrbunny

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.