Not the answer you need?
Register and ask your own question!

Cacti per-minute graphs

mohmoh EntrantCurrent User Role Beginner
Thank you for the Mysql monitoring templates for Cacti!

I have configured cacti to run per-minute and my graph looks like a hedgehog (sample attached). Is this actually because my mysql data sources update less often than 1 minute, causing every nth sample to have a delta of 0? ...or is it something else, and maybe something I could fix?
Attachment not found.

Thanks for your help!

Comments

  • mohmoh Entrant Current User Role Beginner
    Answering my own post for others experiencing the same issue. The polling interval is hardcoded into the Percona scripts. Here are the places I changed the polling interval from 300 to 60:
    ./ss_get_mysql_stats.php:44:$poll_time  = 60;     # Adjust to match your polling interval.
    ./ss_get_rds_stats.py:44:    result = cw.get_metric_statistics(60,
    ./ss_get_rds_stats.py:45:        datetime.datetime.utcnow() - datetime.timedelta(seconds=60),
    ./ss_get_by_ssh.php:38:$poll_time  = 60;     # Adjust to match your polling interval.
    

    Which had this effect:
    Attachment not found.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.