MySQL log reader

Question

So, I'm trying to analyse some of my program's MySQL queries. However, while I've got MySQL general query logging turned on, and can view the log file in a text editor (eg. notepad++), the program writes 1000s of lines of query a minute, so I could do with a slightly better program for reading the logs. Things that would be nice:

Better syntax highlighting.
Real-time updating.
doesn't get too slow when looking at long files
Handles random binary sequences in the log without breaking

Any suggestions?

Edit: Windows-7 compatible programmes only

I typically just tail -f the log. . .

jchapa
– jchapa

2012-12-12 16:06:10 +00:00
Commented Dec 12, 2012 at 16:06 — jchapa
– jchapa, Commented Dec 12, 2012 at 16:06

jchapa · Accepted Answer · 2012-12-12 16:07:17Z

1

You can try using tail -f <file_path>. That will follow the log as it's appended to.

Additionally, you could give multitail a try. It supports syntax highlighting (through regex).

answered Dec 12, 2012 at 16:07

jchapa

4,0363 gold badges28 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Wrikken · Accepted Answer · 2012-12-12 16:07:09Z

0

pt-query-digest from the Percona Toolkit (= Maatkit, but Maatkit will not be developed any further, so switch to the Percona Toolkit). Don't use as a 'live' inspector though, but just as a bulk tool.

answered Dec 12, 2012 at 16:07

Wrikken

70.8k8 gold badges99 silver badges136 bronze badges

Comments

Saharsh Shah · Accepted Answer · 2012-12-13 05:00:15Z

0

Use mysql log tables like general log and slow query log.

Update your mysql config file with:

general_log=1
slow_query_log=1
slow-launch-TIME = 2
log-output = TABLE

OR

You can use MySQL Administrator to view logs(general log, slow query log, error log).

OR

You can also view that log file using TextPad software. It can support a file more than a GB to read write.

edited Dec 13, 2012 at 5:00

answered Dec 12, 2012 at 16:44

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

So far, from testing out a bunch of programmes, the best option I've found is baretail, which has good real-time updating and handles large files reasonably well. It could do with better MySql-specific syntax, but it's not bad.

Alternatively, it turns out that there are actually options in notepad++ (in preferences: misc) to turn on real-time updating, but this doesn't work well unless you have focus on the notepad++ window

There's also a windows implementation of tail

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Dec 13, 2012 at 9:43

RoryB

1,0578 silver badges28 bronze badges

1 Comment

user10044145 Over a year ago

INMO, Navicat Monitor is a better tool and easier to use.

Collectives™ on Stack Overflow

MySQL log reader

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related