Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re^3: MySQL 5.1.11 Select Query

by perrin (Chancellor)
on Aug 05, 2008 at 18:32 UTC ( [id://702440]=note: print w/replies, xml ) Need Help??


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.
      You can read about DBI_TRACE in the DBI documentation.
        Got DBI_TRACE to work, thank you for that suggestion. Here is the output from it.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (3)
As of 2024-03-29 07:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found