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 <je...@gii.co.jp> 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.anir...@gmail.com] >>Sent: Wednesday, June 09, 2010 9:47 AM >>To: mysql@lists.mysql.com >>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 <mdyk...@gmail.com> 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.doss...@pb.com> 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 >>> - mdyk...@gmail.com >>> >>> 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=sundar.anir...@gmail.com >>> >>> > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com 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=arch...@jab.org
