… Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug… rebuilt the poller cache under Cacti -> System Utilities. Also the following Cacti graphs need to be recreated: MySQL “MySQL Threads”, Linux “Network Traffic”. A…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log_at_trx_commit=1. Also … pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what … yet installed something for graphing check out Cacti Tempates which have a lot of such goodness…
Post: Why don't our new Nagios plugins use caching?
February 19, 2012 By 1 Comment
… high-quality Cacti templates for MySQL a few years ago (which are now replaced by the new project), making the Cacti templates use… retrieved from MySQL, I cached the resulting metrics. This avoids having to do InnoDB parsing repeatedly, too. With this approach, Cacti is capable… retrieved from MySQL. It’s worth noting that Cacti doesn’t do this itself, which I consider to be a Cacti design shortcoming…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… machine from another, which takes about 10 or 12 hours. InnoDB is not optimized for rollbacks, it’s optimized for transactions…) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 Here’s the result of loading the entire 4GB file in one chunk: time mysql -e “set… expect for B-Tree indexes. The two curves on the Cacti graph actually show both files being loaded. It might seem…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
… help, for example MySQL CACTI Templates will have the graphs you need. If you’re looking at SHOW INNODB STATUS this is how…’re running Percona Server the following can be helpful: mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_id | space_id | zip_size | page_no…
Post: Percona sessions at the MySQL conference
March 15, 2010 By 6 Comments
… Schwartz: MySQL Graphing and Trending with Cacti Vadim Tkachenko: XtraBackup: Hot Backups and More Aleksandr Kuzminsky: Recovery of Lost or Corrupted InnoDB Tables… Systems for MySQL Peter Zaitsev: Instrumenting your Application for MySQL and Memcached Peter Zaitsev: InnoDB Architecture and Performance Optimization – Part 1 and InnoDB Architecture…
Post: Effect of adaptive_flushing
December 4, 2009 By 5 Comments
… …. We enabled innodb_adaptive_flushing just before 10am, which resulted in a few changes which were recorded by the Cacti MySQL Templates. The most important change for the client here is the recovery time — by enabling adaptive flushing, InnoDB purged…
Post: Presentations Announcement: 2010 O'Reilly MySQL Conference & Expo
April 29, 2010 By 4 Comments
… Kinoshita Innodb Architecure And Performance Optimization Author: Peter Zaitsev Instrumenting PHP applications Author: Peter Zaitsev, Justin Swanhart MySQL Graphing and Trending with Cacti Author: Baron Schwartz Percona’s Performance and Feature Enhancements to MySQL and InnoDB Author: Bill…
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
… clauses with columns that had single-column indexes on them, MySQL could sometimes make use of the multiple indexes. For instance…_id), INDEX `status` (status), INDEX `user_type` (user_type) ) ENGINE=InnoDB; SELECT user_id FROM user WHERE user_type=2 AND… back the next day and we looked at the Cacti reports, the “InnoDB rows examined” graph had dropped several orders of magnitude…
Post: Researching your MySQL table sizes
March 17, 2008 By 28 Comments
… | total_size | idxfrac | +——–+——————–+——-+——-+——-+————+———+ | 48 | cacti | 0.01M | 0.00G | 0.00G | 0.00G | 0.72 | | 17 | mysql | 0.00M | 0.00G | 0… | 941.06M | 244.09G | 4.37G | 248.47G | 0.02 | | InnoDB | 280 | 682.82M | 63.91G | 32.49G | 96.40G | 0…
