in reply to Re^2: MySQL 5.1.11 Select Query
in thread MySQL 5.1.11 Select Query

Are you sure one of those sleeping connections is the one you ran the query on? Another thing you might try is DBI_TRACE. That shows you what DBI is doing.

Replies are listed 'Best First'.
Re^4: MySQL 5.1.11 Select Query
by bkiahg (Pilgrim) on Aug 05, 2008 at 19:11 UTC
    Yes I'm sure, I ran it several times and each time a new instance showed up right after I initiated the query.

    How do I do a DBI_TRACE? I apologize, new to that function.

    I think what the problem might be is my DBD-MySQL is version 2.9002 and the latest is 4.005. I'm going to upgrade that after hours tonight and see if that fixes this issue.
[reply]
      You can read about DBI_TRACE in the DBI documentation.
[reply]
        Got DBI_TRACE to work, thank you for that suggestion. Here is the output from it.
        Read more... See the output from DBI_TRACE (4 kB)
[reply]
[d/l]

In Section Seekers of Perl Wisdom