… of downtime. As usual with these cases, we set up pt-stalk to trigger a capture if Threads_running went above a…. This is when the ‘SHOW FULL PROCESSLIST’ captures generated by pt-stalk come in handy, but if you’ve used them, you… –run-time snapshots separated by timestamps) and ran that by pt-query-digest –type rawlog –report-format profile, to get just…
Post: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 6, 2013 By 2 Comments
… have –help or –version Some tools use @@hostname without /*!50038*/ pt-stalk prints the wrong variable name in verbose mode when –function…-insert with UTF-8 data should definitely upgrade. Those using pt-heartbeat –utc should also definitely upgrade. Users may note the… in certain cases. A new –recursion-method was added to pt-table-checksum: cluster. This method attempts to auto-discover cluster…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… what you expect: pt-stalk -h dhb1 -u me. pt-stalk –no-stalk is no longer magical Originally, pt-stalk –no-stalk was meant to simulate pt-collect, i…: pt-stalk –no-stalk –iterations 1. pt-fk-error-logger and pt-deadlock-logger are standardized Similar to the pt-stalk –no-stalk changes, pt-fk-error-logger and pt…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… administration tasks. My focus will be on the following tools: pt-query-digest, to select the queries you should try to… tables pt-table-checksum/pt-table-sync, to check if data on replicas is in sync with data on the master pt-stalk, to gather data when performance problems happen randomly or are very short pt-online-schema-change, to…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… of the slow log on a Windows machine? A: Yes, pt-query-digest should work on Windows even if it’s… hosts and will work with Amazon RDS but others (like pt-stalk) are only useful when run locally with the root user… to have access to the slow query log file, so pt-query-digest is often used with the –processlist option. But…
Comment: Percona Toolkit by example - pt-stalk
May 9, 2013 By 3 Comments
Hello, Ive try the plugin, but always defaults to the command to pt-stalk like –variable=Threads_running –match= So, never triggers even if the plugin returns a threshold > than defined
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… to figure out, I started of data gathering metrics like: pt-stalk, vmstat, top, iostat, etc all saving to disk with the…
Post: Percona Toolkit by example - pt-stalk
January 3, 2013 By 3 Comments
… trg_plugin inside the script ./pt-stalk-function (–function ../pt-stalk-function) return more than 100 (–threshold 100) $ pt-stalk –function ./pt-stalk-function \ –threshold 100 — –defaults-file…}-status ; done } The pt-stalk command: Before collect the information, it will run the plugin ./pt-stalk-pidplugin (–plugin ./pt-stalk-pidplugin) $ pt-stalk –plugin ./pt-stalk-pidplugin \ –threshold 10…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… provide very good performance metrics. Q: Does pt-sift read pt-stalk‘s output? Yes, pt-sift does not collect any diagnosis data. It… captures) obtained with pt-stalk. If the latest release is invoked without arguments, it looks for captures under /var/lib/pt-stalk/ Q: Is there a way with pt-table-sync to determine when the differences…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
…/InnoDB mix, not heavily loaded. We used pt-stalk (at that time it was aspersa stalk) trying to figure out what is happening… what not. It seemed that the problem was gone before pt-stalk would kick-off and all I could see was symptoms… to potential performance impact. However, somehow I have noticed that pt-stalk kick-off time matched that of binary logs modification time…
