I'm trying to use Percona Toolkit (pt-query-digest) in Windows XP.

I've download a portable version of perl (5.10) and work.

But I've problems using group-by clause ({user} or {fingerprint} or
whatelse is not working, it says: "Use of uninitialized value"

Also with --type genlog I can't use {user} (for example). If I take
out --filter "$event->{user} ...." it works well.

So, until now, with --group-by or --type genlog, I can't use "$event"
for doing --filter

Does anybody know if I can't do this in windows ?
Does anybody do in windows ?

Thanks a lot.

I don't know what might be wrong here. I don't know of any Windows-specific bugs.  I would suggest using PTDEBUG=1 pt-query-digest <options> to try to see more about what is happening.

Regards,
Baron

On Apr 18, 2012, at 10:29 AM, Fernando Ortega wrote:

Fisrt of all, thanks a lot for your time.

I'll try to define what I'm doing. These days I've installed a Ubuntu
VM with VirtualBox and do some check in it, with percona toolkit
correctly and full installed

I have Mysql 5.5.22 GA (windows machine), and I've done some test with
a slow log with only one query. (I read an article from Jonathan
Levin: http://www.jonathanlevin.co.uk/2012/04/mastering-mysql-indexing.html)

Then, in Ubuntu with percona-toolkit installed, the next commands work
perfectly:

1. pt-query-digest slow_short.log
2. pt-query-digest slow_short.log --filter '($event->{user} =~ m/
vostro230/)'
3. pt-query-digest pcclonico-slow.log --filter  '($event-

4. pt-query-digest slow_short.log --filter '($event->{Rows_read} >
1000)'
5. pt-query-digest pcclonico-slow.log --filter  '($event-

Both of them say that: "Pipeline process 10 (filter) caused an error:
Use of uninitialized value in pattern match (m//) at (eval 21) line 1,
<> line 1."

So my problem is about eventattributes.

I've read all about Maatkit Wiki, but I don't understand it well. I
can work only with USER, ROWS_EXAMINED, and ROWS_SENT,etc (these are
in my Mysql5.5.22GA(windows version) slow query log.

So If anyone could explain me how to use FINGERPRINT in --group-by
tables ? (may be is something about having percona server ?, or a
patch ? could I install that patch in my mysql windwos version
server ?)

Why can I execute command 3 but not 5 ? Why can I not use fingerprint
in --group-by clauses ?

Sorry for my poor knowledge but If you find easy to explain, I'd
appreciate you.

Bye,

On Apr 24, 5:10 pm, Baron Schwartz <ba...@percona.com> wrote:

On Apr 25, 2012, at 5:59 PM, Fernando Ortega wrote:

My slow-log is a normal Mysql 5.5 log.

Here you have an example of it:

# Time: 120425 13:47:40
# User@Host: vostro220[vostro220] @  [192.168.0.201]
# Query_time: 0.562500  Lock_time: 0.000000 Rows_sent: 15773
Rows_examined: 1340790
SET timestamp=1335354460;
SELECT p.idProducto, (....) FROM producto, (....) WHERE (....)

I've understood that I can only use Rows_sent or Rows_examined, buy
WHY I can't use --group-by tables option ? Does that option requerie
also a Mysql Percona server ?

As I say last week:
3. pt-query-digest pcclonico-slow.log --filter  '($event-

The onyl difference is the group-by clause. I think that percona-
toolkit get the table name from sql clause, but why it doesn't work ?

Could you make any test ?

Thanks a lot.

Why can I executte command 3 but not 5 ? The change is only about --
group-by clause             (neither 'tables')

On Apr 27, 9:45 pm, Baron Schwartz <ba...@percona.com> wrote: