How can I see the query from a remote session against my server
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
ANN: Database Workbench 4.0.2 released - including Free Lite Editions
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.0.2 Pro Version 4 introduced full Unicode support, 4.0.2 fixes some issues found in that initial release, like ODBC connectivity issues, BLOBs taking too much memory, the ability to specify file encoding when saving SQL Scripts and several other errors. For a full list of fixes in version 4.0.2 and previous versions, see: http://www.upscene.com/go/?go=trackerv=4.0.2id=1 http://www.upscene.com/go/?go=trackerv=4.0.1id=1 http://www.upscene.com/go/?go=trackerv=4.0id=1 Database Workbench supports: - Borland InterBase ( 4.x - 9.x ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10 and 11 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How can I see the query from a remote session against my server
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=arch...@jab.org
Authentication issue
Hi list, I'm migrating a Java application from it's local MySQL server (5.0) to a remote 5.1 server. I've transferred the data and slaved the new server to keep it in sync, but when I try to switch out the datasource (that is, just change from localhost to the remote server), the application refuses to connect, claiming that an invalid user or password. Whenever I try to connect from the commandline, there's not a problem to be seen - connection is quick and good. I already tried with connecting to the IP, adding the IP to the server's access tables (should be an issue, it's in the hosts file anyway), flush hosts/privileges and whatnot. Also upgraded the java connector to the latest version on mysql.com. All to no avail - it keeps saying the user or password is invalid, regardless of how many succesful connects I do on the commandline. Has anyone ever seen similar behaviour, and managed to fix it ? /johan -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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
Re: How can I see the query from a remote session against my server
binlogs only contain data modifications, it won't show you the SELECT queries; I don't think that path is worth your time for the problem at hand. I suggest you explicitly enable the gebneral query log and restart if need be. - md On Wed, Jun 9, 2010 at 9:47 AM, Anirudh Sundar sundar.anir...@gmail.com wrote: 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 -- - 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
MySQL University session on June 10: Securich - Security Plugin for MySQL
MySQL University: Securich - Security Plugin for MySQL http://forge.mysql.com/wiki/Securich_-_Security_Plugin_for_MySQL This Thursday (June 10th, 14:00 UTC), Darren Cassar will rerun his February 25 presentation of Securich - Security Plugin for MySQL. (Recording of the session failed in February; hopefully it will succeed this time.) According to Darren, the author of the plugin, Securich is an incredibly handy and versatile tool for managing user privileges on MySQL through the use of roles. It basically makes granting and revoking rights a piece of cake, not to mention added security it provides through password expiry and password history, the customization level it permits, the fact that it runs on any MySQL 5.0 or later and it's easily deployable on any official MySQL binary, platform independent. More information here: http://www.securich.com/about.html. For MySQL University sessions, point your browser to this page (you need a browser with a working Flash plugin): http://webmeeting.dimdim.com/portal/JoinForm.action?confKey=mysqluniversity MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone. All sessions (slides audio) are recorded; the links will be on the respective MySQL University session pages which are listed on the MySQL University home page. -- Cheers, Stefan Hinz stefan.h...@sun.com, MySQL Documentation Manager Phone: +49-30-82702940, Fax: +49-30-82702941, http://dev.mysql.com/doc Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Juergen Kunz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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=arch...@jab.org
RE: How can I see the query from a remote session against my server
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
FLUSH LOCAL LOGS
Hello ! Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: FLUSH LOCAL LOGS
Ok now -Original Message- From: Darvin Denmian [mailto:darvin.denm...@gmail.com] Sent: Wednesday 09 June 2010 19:00 To: mysql@lists.mysql.com Subject: FLUSH LOCAL LOGS Hello ! Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=azzopa...@eib.org Les informations contenues dans ce message et/ou ses annexes sont reservees a l'attention et a l'utilisation de leur destinataire et peuvent etre confidentielles. Si vous n'etes pas destinataire de ce message, vous etes informes que vous l'avez recu par erreur et que toute utilisation en est interdite. Dans ce cas, vous etes pries de le detruire et d'en informer la Banque Europeenne d'Investissement. The information in this message and/or attachments is intended solely for the attention and use of the named addressee and may be confidential. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error and that any use of it is prohibited. In such a case please delete this message and kindly notify the European Investment Bank accordingly. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: FLUSH LOCAL LOGS
On Jun 9, 2010, at 11:59 AM, Darvin Denmian wrote: Hello ! Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ? Yes. http://dev.mysql.com/doc/refman/5.1/en/flush.html says: By default, FLUSH statements are written to the binary log so that they will be replicated to replication slaves. Logging can be suppressed with the optional NO_WRITE_TO_BINLOG keyword or its alias LOCAL. Note FLUSH LOGS, FLUSH MASTER, FLUSH SLAVE, and FLUSH TABLES WITH READ LOCK are not written to the binary log in any case because they would cause problems if replicated to a slave. -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: FLUSH LOCAL LOGS
Thanks Paul you opened my eyes !!! On Wed, Jun 9, 2010 at 2:27 PM, Paul DuBois paul.dub...@oracle.com wrote: On Jun 9, 2010, at 11:59 AM, Darvin Denmian wrote: Hello ! Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ? Yes. http://dev.mysql.com/doc/refman/5.1/en/flush.html says: By default, FLUSH statements are written to the binary log so that they will be replicated to replication slaves. Logging can be suppressed with the optional NO_WRITE_TO_BINLOG keyword or its alias LOCAL. Note FLUSH LOGS, FLUSH MASTER, FLUSH SLAVE, and FLUSH TABLES WITH READ LOCK are not written to the binary log in any case because they would cause problems if replicated to a slave. -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Questions regarding Query cache usage
On Tue, Jun 8, 2010 at 10:57 PM, Machiel Richards machi...@rdc.co.za wrote: Good morning all I would like to try and find out how you can see what is using the query cache. My reason for asking is the following: On one of our client databases, the query cache is set to 128Mb and the usage always varied between 5% and 53% and basically never went above that. However, this morning I noticed that the query cache usage is at 99.98% which is very odd for the database. How are you determining the cache usage? I don't think 99.98% utilitzation is a bad thing. It would be preferable to wasting memory on a cache that is under-utilized. Does anybody have an idea on how to determine why this usage is suddenly this high and if we should look at increasing the query cache size or not? Has a new workload been introduced to the server? The cache utilization may be indicative of a lot of small repeated queries being introduced. You can monitor the Qcache_lowmem_prunes and Qcache_free_blocks to determine if you can benefit from increased query cache size. http://www.mysqlperformanceblog.com/2006/07/27/mysql-query-cache/ I also have a second question relating to a previous post I sent through but never really received a definitive answer. The client database is setup with a master slave replication, the master Innodb buffer pool usage is at 4Gb at present (no more system memory available to increase this) We are starting to receive errors on the slave server however relating to the innodb buffer pool size being used up and there is no place to add more locks. This was found to be related to the slave server's innodb buffer pool size that is currently still set to 8mb. I would like to know whether it will be worth changing the value on the slave server to match that of the master server or will this cause more problems? If the memory is available, why not use it? It seems like the default buffer pool size out of the box was just never changed. Kyong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Questions regarding Query cache usage
On Wed, Jun 9, 2010 at 8:04 PM, Kyong Kim kykim...@gmail.com wrote: If the memory is available, why not use it? It seems like the default buffer pool size out of the box was just never changed. Agreed, of course, but if something happens on a system that is out of the ordinary, it's very good practice to hunt the cause down before it makes more undesireable things happen. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How can I see the query from a remote session against my server
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
Re: Questions regarding Query cache usage
Absolutely. You don't want to obscure the cause by just throwing more hardware at things. That approach just buys you time until a bigger pile hits the fan if the underlying issue remains unresolved. At the same time, though, 8 MB production innodb buffer pool allocation should be fairly high on the list of things to scrutinize. Kyong On Wed, Jun 9, 2010 at 12:12 PM, Johan De Meersman vegiv...@tuxera.be wrote: On Wed, Jun 9, 2010 at 8:04 PM, Kyong Kim kykim...@gmail.com wrote: If the memory is available, why not use it? It seems like the default buffer pool size out of the box was just never changed. Agreed, of course, but if something happens on a system that is out of the ordinary, it's very good practice to hunt the cause down before it makes more undesireable things happen. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
2 servers 1 common data base
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 We have 2 mysql servers - one active , second standby. The data base is on nsf storage file system mounted on the active server. We want to turn on active the second server and to be able to use both servers with the same nfs mounted data base. Just now when I try to start mysqld on the second server I get an error that says data base cannot be opened is locked by another mysql instance. What can be done to run on both servers mysqld simultaneously and use the same data base? - -- Camelia Botez Unix/Linux/HPC administrator Weizmann Institute of Science Tel: 972-89344964 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEVAwUBTBBzhSE/LWeWdItOAQJFEAgAg5zq+ocqLnQxJT0PxSmvJ6bSMRA3hESg jAE5x5/55gbRQEMW5py3TD5PToBLROsdza4JlVyfQ/zo62ePaB2uX5zSNcPrN3hs VVclktDFwejCkDdmKH4a/p9284K3UhPgNItmSFQKNsAZJhznoIs9ld5jZ8MiQWjP ZPjjalhII/IMQTODTGwzs00uW1wAXsQcATJlE/JdjwqKaBx6Xq64IQNgj4CNxeMS 2leZiINK/aAL9oi1Qssqx/AzfOm9Cz5+hSKkqxWW7DahoLtDw02zRwf8ERgzuRXS 2GaTXqbRicLzFYXvFJBruNKnMvNfap3Q3YhuzcLVWQ7aSUxeyBSEPg== =SiGe -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org