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:je...@gii.co.jp] Sent: 09 June 2010 16:43 To: 'Anirudh Sundar'; mysql@lists.mysql.com 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.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=bi...@emtex.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
