473,320 Members | 2,052 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Monitoring MYSQL use

Is there a way to watch what queries come into the MYSQL server? What
application should I use to do this?

Thanks!
Jul 20 '05 #1
2 1288

"Jon Glazer" <jg**************@adconn.com> wrote in message
news:BX***************@fe2.columbus.rr.com...
Is there a way to watch what queries come into the MYSQL server? What
application should I use to do this?


I use the following:

mysql> show binlog events;

Or, if using Unix

$ mysqlbinlog <logfile>

For setup and more examples reference (TIP 24)
http://prdownloads.sourceforge.net/s...l.txt?download

Hope this helps,

Mike Chirico
Jul 20 '05 #2

"Mike Chirico" <mc******@comcast.net> wrote in message
news:Zd********************@comcast.com...

"Jon Glazer" <jg**************@adconn.com> wrote in message
news:BX***************@fe2.columbus.rr.com...
Is there a way to watch what queries come into the MYSQL server? What
application should I use to do this?


I use the following:

mysql> show binlog events;

Or, if using Unix

$ mysqlbinlog <logfile>

Setting the binary log file. This can be configured in /etc/my.cnf

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
log-bin = /usr/local/var/mysqlLOGb.log
log = /usr/local/var/mysqlLOG.log

or for the default hostname just log-bin

[mysqld]
port = 3306
socket = /tmp/mysql.sock
log-bin

IMPORTANT: The default my.cnf has a "log-bin" entry. Make sure it is not
listed twice.

It's also possible to set the text log file. Note both "log-bin" and
"log" are set here:

[mysqld]
port = 3306
socket = /tmp/mysql.sock
log-bin = /usr/local/var/mysqlLOGb.log
log = /usr/local/var/mysqlLOG.log

Note, (see TIP 24 - link below) the binary log file works with the "show
binlog events command" and shows, updates,
creates, deletes, and drops, but no select statements. In contrast, the
text log-file "/usr/local/var/mysqlLOG.log"
shows the user, and the select statement, all of the above, but it's in a
text file. I believe the text
format is going away with version 5.0.

The following command "DOES NOT" give information about these log files:

http://osdn.dl.sourceforge.net/sourc...ADME_mysql.txt

Regards,

Mike Chirico
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Sven Dzepina | last post by:
Hi All, how I can make a simply HostWatch - system which use a mysql DB and send me an e-Mail if the Server goes off and again on? I began to programm this last night, but the MySQL inquiry is...
1
by: Ron | last post by:
I am trying to run asp.net pages. The server is accessed via http://sitename/username I have verified it is using port 80 and aspx extensions are configured. But when I run and asp.net page I...
0
by: Jay Blanchard | last post by:
-----Original Message----- From: Moritz Steiner =20 Sent: Wednesday, July 16, 2003 10:46 AM To: Jay Blanchard Subject: AW: monitoring I want to see: Number of queries =20
4
by: johnm | last post by:
Hello, We currently are running a CRM application that uses DB/2 7.2 for the data repository. We will be upgrading to 8.2 later this year....maybe....time and resources permitting. The...
3
by: JSheble | last post by:
I have a windows service that in the OnStart it creates a thread and runs a loop forever and ever, assuming the service is running. The loop stops during the OnStop event, and everything works...
0
by: Jeff Reed | last post by:
I am experiencing the the problem outlined the below. Unfortunately, I am using WinXP and I not sure if I can apply the solution due to lack of security control Any feed back would be apreciated ...
0
by: Ron Simpson | last post by:
I am trying to run asp.net pages. The server is accessed via http://sitename/username I have verified it is using port 80 and aspx extensions are configured. But when I run and asp.net page I...
9
by: Tim D | last post by:
Hi, I originally posted this as a reply to a rather old thread in dotnet.framework.general and didn't get any response. I thought it might be more relevant here; anyone got any ideas? My...
4
by: natG | last post by:
Well folks, I didn't heed the warnings (that excessive monitoring, statistics, etc. can cause a performance hit) and I have been playing around with all kinds of monitors, snapshots, especially...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.