# Zabbix Graph data in text **URL:** \ **Category:** Percona Monitoring Plugins\ **Created:** [January 18, 2017, 7:46am UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353 "2017-01-18T07:46:04Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![adnan](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@adnan](https://forums.percona.com/u/adnan)\ **Post date:** [January 18, 2017, 7:46am UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/1 "2017-01-18T07:46:04Z")
Hi Folks, I had configure percona plugin on zabbix 3.0 for MySQL server, it is showing graphs but I want to know what query is creating locks. Is there any way to find which is query is slow or which is creating the deadlock / table locks ? Thanks, ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [January 18, 2017, 9:16am UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/2 "2017-01-18T09:16:30Z")
Hi Adnan, you can use Percona Monitoring and Management, it is fully open source and it has good query analytic inside. It will show you slow queries and explain them. [URL][https://www.percona.com/software/database-tools/percona-monitoring-and-management[/URL]](https://www.percona.com/software/database-tools/percona-monitoring-and-management%5B/URL%5D) ---
**Author:** ![adnan](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@adnan](https://forums.percona.com/u/adnan)\ **Post date:** [January 18, 2017, 10:20am UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/3 "2017-01-18T10:20:07Z")
Thank you Mykola. Using Percona plugin in zabbix i can see a graph that shows some tables are locked or creating deadlocks but I cannot see that which table or databases doing it. How can I check it in Percona plugin ? Or can i see this in Percona Monitoring and Management ? ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [January 18, 2017, 12:57pm UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/4 "2017-01-18T12:57:36Z")
Percona Monitoring and Management has Query Analytics tool. Query Analytics enables you to analyze MySQL query performance over periods of time. This tool shows queries and explain them. ---
**Author:** ![adnan](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@adnan](https://forums.percona.com/u/adnan)\ **Post date:** [January 20, 2017, 11:22am UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/5 "2017-01-20T11:22:46Z")
[LEFT] ---
**Author:** ![DBennett](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/dbennett/32/17_2.png) [@DBennett](https://forums.percona.com/u/DBennett)\ **Post date:** [January 23, 2017, 12:15pm UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/6 "2017-01-23T12:15:37Z")
Hi Adnan, Monitoring plug-ins should be quick and produce as minimal load as possible, deadlock investigation is not quick procedure. You may want to investigate the Percona Toolkit pt-deadlock-logger utility which may do what you want. You can read about it here: [url][https://www.percona.com/blog/2012/09/19/logging-deadlocks-errors/[/url]](https://www.percona.com/blog/2012/09/19/logging-deadlocks-errors/%5B/url%5D) –Dave ---
**Author:** ![adnan](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@adnan](https://forums.percona.com/u/adnan)\ **Post date:** [January 24, 2017, 10:58am UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/7 "2017-01-24T10:58:02Z")
I already check out the Toolkit but I am more towards self alerts and GUI based results, don’t want to run on terminal. ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [January 26, 2017, 4:34am UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/8 "2017-01-26T04:34:28Z")
Hi adnan, I created feature requests for you: deadlock monitoring in zabbix plugins: [url][https://bugs.launchpad.net/percona-monitoring-plugins/+bug/1659518[/url]](https://bugs.launchpad.net/percona-monitoring-plugins/+bug/1659518%5B/url%5D) deadlock monitoring in PMM: [url][Log in - Percona JIRA](https://jira.percona.com/browse/PMM-540%5B/url%5D) feel free to add any additional comments inside tickets. ---
**Author:** ![adnan](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@adnan](https://forums.percona.com/u/adnan)\ **Post date:** [January 26, 2017, 5:42am UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/9 "2017-01-26T05:42:43Z")
Thank you Mykola. It would be very helpful for me as well as for the community. ---
**Author:** ![adnan](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@adnan](https://forums.percona.com/u/adnan)\ **Post date:** [January 26, 2017, 7:44am UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/10 "2017-01-26T07:44:12Z")
I have an other question related to Percona Server. If I switched my MySQL to Percona MySQL then can I achieve the feature that I want ? Thanks, ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [January 26, 2017, 7:59am UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/11 "2017-01-26T07:59:20Z")
If you want get list of deadlocks in mysqld error log, you can enable innodb\_print\_all\_deadlocks feature in MySQL. [url][mysql - View last several innodb deadlocks - Database Administrators Stack Exchange](https://dba.stackexchange.com/questions/87350/view-last-several-innodb-deadlocks%5B/url%5D) You can use this option in any MySQL server. ---
**Author:** ![adnan](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@adnan](https://forums.percona.com/u/adnan)\ **Post date:** [January 26, 2017, 8:48am UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/12 "2017-01-26T08:48:37Z")
Buddy I clear my concern in the Reply #7. I can do this in my current environment but I want the feature that can alert when deadlock lock and it would be GUI based. Don’t want tun the CLI commands or append the output of that command ---
**Author:** ![DBennett](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/dbennett/32/17_2.png) [@DBennett](https://forums.percona.com/u/DBennett)\ **Post date:** [January 26, 2017, 11:42am UTC](https://forums.percona.com/t/zabbix-graph-data-in-text/5353/13 "2017-01-26T11:42:21Z")
Hi adnan, We don’t have a deadlock notification feature in our Zabbix plugin at this time. You may be able to create one using the pt-deadlock-logger CLI in conjunction with Zabbix actions and triggers. –Dave