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