List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:June 9 2010 8:46pm
Subject:Re: How can I see the query from a remote session against my server
View as plain text  
This is awhile ago, but I seem to recall it just dumping loads of
stuff into System32

On Wed, Jun 9, 2010 at 11:43 AM, Jerry Schwartz <jerry@stripped> wrote:
> 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
>
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
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