pt-query-digest --processlist
Hi guys, I'm trying to use pt-query-digest on one of our Prod servers. The problem our slow log is disabled, no tcpdump is installed and I decided to use --processlist parameter which I never tried before. pt-query-digest version 2.2.2 I run to connect to remote node: pt-query-digest --processlist h=192.168.1.111,u=user -p PASSWORD --print --no-report --run-time 60 SERVER-`date +%Y%m%d-%H` I get: Unknown option: print Without --print parameter I don't have errors but I do not get any output into file. The prod server is very busy. How to make it work? Thanks, Igor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: pt-query-digest --processlist
Hi Claudio, Thanks for reply. Great. I was sure you can't enable slow log dynamically on 5.0 and 5.1. That solves my issue for 5.1 at least. Many thanks, Igor On 06/06/13 13:06, Claudio Nanni wrote: Hi, First of all I discourage you to use --processlist, I don't think it is enough an accurate method to analyse queries. You can dynamically enable the Slow Query Log with long_query_time=0 and get a way better data. Check the syntax for SET GLOBAL variables. Remember to disable it afterwards. Now to your question, pt-query-digest version 2.2.2 I run to connect to remote node: pt-query-digest --processlist h=192.168.1.111,u=user -p PASSWORD --print --no-report --run-time 60 SERVER-`date +%Y%m%d-%H` I get: Unknown option: print Maybe because such option does not exist? Cheers Claudio
Re: pt-query-digest --processlist
- Original Message - From: Claudio Nanni claudio.na...@gmail.com You can dynamically enable the Slow Query Log with long_query_time=0 Except when you have persistent connections on a stock mysqld. The recent Percona ones do have a way to change the settings of existing connections, iirc. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: pt-query-digest --processlist
Hi, First of all I discourage you to use --processlist, I don't think it is enough an accurate method to analyse queries. You can dynamically enable the Slow Query Log with long_query_time=0 and get a way better data. Check the syntax for SET GLOBAL variables. Remember to disable it afterwards. Now to your question, pt-query-digest version 2.2.2 I run to connect to remote node: pt-query-digest --processlist h=192.168.1.111,u=user -p PASSWORD --print --no-report --run-time 60 SERVER-`date +%Y%m%d-%H` I get: Unknown option: print Maybe because such option does not exist? Cheers Claudio