List:General Discussion« Previous MessageNext Message »
From:Bill Dossett Date:June 9 2010 3:48pm
Subject:RE: How can I see the query from a remote session against my server
View as plain text  
Thanks all for the replies, I seemed to have figured out why this was empty... they gave
me the wrong data to load into the test database and queries into it found no matches...
I assumed that would be the problem and they are sending new data...  however, I am going
to try and get the debug log working if possible as it sounds pretty useful, so thanks
again.

Bill


-----Original Message-----
From: Jerry Schwartz [mailto:jerry@stripped] 
Sent: 09 June 2010 16:43
To: 'Anirudh Sundar'; mysql@stripped
Subject: RE: How can I see the query from a remote session against my server

The Windows ODBC connector does have a logging function. It's in the 
"Details", on the "Debug" tab.

Unfortunately, I haven't been able to figure out where it puts the log file 
even after doing a full scan of my hard drive. I searched for myodbc.*, and 
didn't find anything that looked like a log file.

Either the feature doesn't work, or I'm blind.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com

>-----Original Message-----
>From: Anirudh Sundar [mailto:sundar.anirudh@stripped]
>Sent: Wednesday, June 09, 2010 9:47 AM
>To: mysql@stripped
>Subject: Re: How can I see the query from a remote session against my server
>
>Michael is right. But sometimes General log is not enabled and if that is
>the case then you need to refer to the "Binary" logs.
>
>But you cannot read the contents of the binlog just like that. You need to
>convert that to a readable format.
>
>mysqlbinlog bin.10001 > /tmp/read_bincontent.log
>
>Cheers,
>Anirudh Sundar
>DataVail Corp
>Mumbai
>
>
>On Wed, Jun 9, 2010 at 6:52 PM, Michael Dykman <mdykman@stripped> wrote:
>
>> You have 2 options here.  The Mysql General Query Log
>>
>> http://dev.mysql.com/doc/refman/5.1/en/query-log.html
>>
>> Alternatively, if it's windows ( I ask because of the ODBC connector)
>> and it's easier for you,
>> I haven't done windows in awhile, but I suspect you might find what
>> you want via that connector.  I seem to recall that you can, via
>> control panel, set debug options on the connector which will happily
>> create enormous logs of every query passing through.
>>
>> best of luck.
>>
>>  - md
>>
>>  (side-note: I would not recommend hosting data services without a DBA
>> to manage them)
>>
>> On Wed, Jun 9, 2010 at 6:48 AM, Bill Dossett <bill.dossett@stripped> wrote:
>> > Hi,
>> >
>> > I'm a real newb at admining MySQL.    We have a customer that uses our
>> software that scripts queries and they are using a MySQL backend.
>> >
>> > They have sent us a test script and their database and I have setup a
>> test server, loaded the data setup an ODBC connection and this all works
>> fine.
>> >
>> > The first job they sent us appears to be working fine, but the second one
>> throws an error saying the query is empty back at us.
>> >
>> > I am an IT manager and I don't know much about how our software scripting
>> system works or even if there is a debugger, so I was just trying to attack
>> the problem from the server side to see if I could see the query at the
>> server...   I thought profiling might help, but that only helps me with the
>> session that I am connected to as far as I can see anyway, I'm not seeing
>> any of the queries that are being generated by the remote seesion through
>> the odbc connector...
>> >
>> > Is there some way the I can see the queries that are being run against
>> this server from the remote session?  As this is a test system and it's
>> doing very little, I was hoping that if I could see the query I might get
>> some insight of what might be wrong in the script without having to learn
>> how our whole scripting software system works.
>> >
>> > I have done this with the MSSQL profiler in the past to locate slow
>> queries in the past, so I assume it is possible and I just can't make the
>> documents on the MySQL profiler make sense to me.
>> >
>> > Thanks for any help anyone could provide on this as I've got people that
>> expect miracles in the next 5 minutes here!
>> >
>> > Bill
>> >
>> >
>>
>>
>>
>> --
>>  - michael dykman
>>  - mdykman@stripped
>>
>>  May the Source be with you.
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=1
>>
>>




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


Thread
How can I see the query from a remote session against my serverBill Dossett9 Jun
  • Re: How can I see the query from a remote session against my serverMichael Dykman9 Jun
    • Re: How can I see the query from a remote session against my serverAnirudh Sundar9 Jun
      • Re: How can I see the query from a remote session against my serverMichael Dykman9 Jun
      • RE: How can I see the query from a remote session against my serverJerry Schwartz9 Jun
        • RE: How can I see the query from a remote session against my serverBill Dossett9 Jun
        • Re: How can I see the query from a remote session against my serverMichael Dykman9 Jun