… extract all the pages we’ll use the page_parser tool. This tool will find and extract all the pages of the… also be taken directly from MySQL using the InnoDB Tablespace Monitor. This monitor will write all the information related with tables and…) to the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name employees/salaries, id 18…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
… internal network of the other host. On the monitor host, we will have: root@monitor:/etc/ha.d# cat ha.cf autojoin… 212 We can also use the “crm” tool to query the cluster status. root@monitor:~# crm status ============ Last updated: Tue Jun 29… 2 Nodes configured, unknown expected votes 1 Resources configured. ============ Online: [ monitor hamysql ] Install MySQL For the sake of simplicity, we will…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, which is synonymous with Valgrind itself, is relatively widely used…_last_monitor_time” ==9090== declared at srv0srv.c:424 This is a race between srv_monitor_thread and srv_error_monitor_thread InnoDB threads storing to srv_last_monitor_time. It’s hard…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… a time, checksumming each chunk with a single query. It monitors master load to suspend itself if there is impact, and… same attendee asked about any performance differences when using the tool with or without innodb_file_per_table, and the first… all nagios plugin doesn’t output performance data? The Percona Monitoring Plugins include cacti templates and nagios plugins, and each should…
Post: Living with backups
November 6, 2008 By 28 Comments
… work so much. ionice -c3 /root/backup-tools/tar … ionice -c2 -n7 /root/backup-tools/tar … Please cosult ionice man page for… next step was to constantly monitor the database status and if any problems were noticed, the monitoring would simply pause the copying…, etc. In this case tar is actually launched by the monitoring script directly, but that’s not really necessary. It simply…
Post: Give me 8 hours, and I'll help you build a better application
August 29, 2009 By 4 Comments
… archiving can help do that. 2. Monitor Your Servers Everybody should have an automated monitoring system that is watching key elements of… up monitoring can seem to be a daunting task, in part because of the steep learning curve that comes with most tools… misguided advice and plugins for such tools, which will lead you to believe that you should monitor every ratio and counter there…
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
…, all the current SST methods are just commonly used backup tools, and the SST is, in reality, just doing a full… question about availability of Nagios or other monitoring plugins, and I misspoke: The Percona Monitoring Plugins have a check that enables you… on the monitored MySQL server in question. It should be easy to use this tool to monitor at least some of the monitoring recommendations…
Comment: The perils of uniform hardware and RAID auto-learn cycles
November 17, 2010 By 16 Comments
… let the boxes run themselves, use tools to ensure uniform config, then then use remote monitoring to try to pick up things… whatnot. And as others have pointed out, monitoring is never a perfect game. If you monitor everything, you A) produce more data… is the cost to monitor parameter X vs what is the likely cost if I don’t monitor it? There’s always…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… have a good level of availability, you need a good monitoring and alerting system to quickly react to replication issue and… HA levels, failover or recovery should be automatic. There are tools to manage automatic failover with replication like MMM, Flipper and… that is running on each server. The manager controls and monitors the state of the replication and assign virtual IPs for…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…of printout Innodb will print: ===================================== 060717 3:07:56 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 44 …so SHOW INNODB STATUS can also be used as debugging tool. Next section you will find in SHOW INNODB STATUS …
