Wider images in Cacti

I like to have wider images in Cacti, the system we use to monitor our servers.

Specifically, I like to have images that are 750px wide instead of the default 500px. It can be cumbersome to change the templates individually, so the following SQL can be executed against your Cacti database and they’ll all be changed at once:

UPDATE graph_templates_graph SET width = 750 WHERE ID > 0;

I’ve found that some templates can’t jam all their information into a 500px wide image, so this SQL fixes that. It’s annoying having to reverse-engineer the database every time I add a new device template but now I have this post to refer back to.