search

box / Anemometer

Box SQL Slow Query Monitor
Apache License 2.0
1.39k stars 316 forks source link

pt-query-digest hangs #74

Closed baygithub closed 10 years ago

baygithub commented 11 years ago

Hi, the following command hangs when I run the following command, the review and review_history table is still empty after 30 min execution, had to terminate it since it never finishes. pt-query-digest --user=anemometer --password=superSecurePass \ --review h=localhost,D=slow_query_log,t=global_query_review \ --history h=localhost,D=slow_query_log,t=global_query_review_history \ --no-report --limit=0% \ --filter=" \$event->{Bytes} = length(\$event->{arg}) and \$event->{hostname}=\"$HOSTNAME\"" \ mysql-slow.log

would u please advice me on what I have done wrong?

baygithub commented 11 years ago

this issue is resolved

geoffreyanderson commented 11 years ago

What was the resolution? Did you simply need to wait longer because of a large slow log, or was there a mistake in the command we should take note of?

gtowey commented 10 years ago

closing due to age. It's good to note that if the mysql-slow.log file is very big this can take a long time to run.