# cacti  empty mysql graphs

**URL:** <https://forums.percona.com/t/cacti-empty-mysql-graphs/3485>\
**Category:** Percona Monitoring Plugins\
**Created:** [May 19, 2014, 3:11am UTC](https://forums.percona.com/t/cacti-empty-mysql-graphs/3485 "2014-05-19T03:11:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ece.saikumar](https://avatars.discourse-cdn.com/v4/letter/e/ee59a6/32.png) [@ece.saikumar](https://forums.percona.com/u/ece.saikumar)\
**Post date:** [May 19, 2014, 3:11am UTC](https://forums.percona.com/t/cacti-empty-mysql-graphs/3485/1 "2014-05-19T03:11:07Z")

</div>

we are configuring the percona mysql monitoring plugin with cacti …first we are testing with a local test bed with cacti and mysql server in same server .cacti can display linux parameters but it is not displaying the mysql parameters in graphs

---

<div class="post-metadata">

**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\
**Post date:** [May 19, 2014, 7:17am UTC](https://forums.percona.com/t/cacti-empty-mysql-graphs/3485/2 "2014-05-19T07:17:49Z")

</div>

Have you set mysql credentials in the config file /etc/cacti/ss\_get\_mysql\_stats.php.cnf?

---

<div class="post-metadata">

**Author:** ![Hooper](https://avatars.discourse-cdn.com/v4/letter/h/c77e96/32.png) [@Hooper](https://forums.percona.com/u/Hooper)\
**Post date:** [August 12, 2014, 3:38am UTC](https://forums.percona.com/t/cacti-empty-mysql-graphs/3485/3 "2014-08-12T03:38:43Z")

</div>

Hope ok if I jump in on this as I too have the same issue with MySQL graphs not showing data. First I thought it might be a firewall issue with remote servers but then I noticed even the mysql on local Cacti host is not graphing for MySQL.

I have the ss\_get\_mysql\_stats.php.cnf in /etc/cacti/, I have the user and password in all the MySQL databases with correct privileges. The Percona Toolkit is installed on the servers. The graphs are there but they are empty.

Is there a way I can run the query manually from terminal on Cacti server? Do i need to open MySQL ports to and from the remote MySQL servers?

Many Thanks.

---

<div class="post-metadata">

**Author:** ![tokar86a](https://avatars.discourse-cdn.com/v4/letter/t/ccd318/32.png) [@tokar86a](https://forums.percona.com/u/tokar86a)\
**Post date:** [November 29, 2014, 10:11am UTC](https://forums.percona.com/t/cacti-empty-mysql-graphs/3485/4 "2014-11-29T10:11:02Z")

</div>

I have this problem to. Nothing is happen.

---

<div class="post-metadata">

**Author:** ![tinhkt5491](https://avatars.discourse-cdn.com/v4/letter/t/e8c25b/32.png) [@tinhkt5491](https://forums.percona.com/u/tinhkt5491)\
**Post date:** [June 11, 2015, 1:47am UTC](https://forums.percona.com/t/cacti-empty-mysql-graphs/3485/5 "2015-06-11T01:47:55Z")

</div>

have the ss\_get\_mysql\_stats.php.cnf in /etc/cacti/, I have the user and password in all the MySQL databases with correct privileges. The Percona Toolkit is installed on the servers. The graphs are there but they are empty.