… the way, we can also help you install and configure monitoring and graphing systems, if you don’t have any. These… have died. The ORM should just be running the query, and if the query fails, then you know from the error code…. We also frequently bring the discussion to topics such as monitoring, alerting, backups, caching, reverse proxies, and high availability solutions, all…
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… to query the cluster status. root@monitor:~# crm status ============ Last updated: Tue Jun 29 13:56:04 2010 Stack: Heartbeat Current DC: monitor… 2 Nodes configured, unknown expected votes 1 Resources configured. ============ Online: [ monitor hamysql ] Install MySQL For the sake of simplicity, we will…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… slave server As part of its safeguards, pt-table-checksum monitors lag on replicas, and pauses as needed to let them… at a time, checksumming each chunk with a single query. It monitors master load to suspend itself if there is impact, and… all nagios plugin doesn’t output performance data? The Percona Monitoring Plugins include cacti templates and nagios plugins, and each should…
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… text? Does the database server respond okay to a sample query that your application actually uses? Is the disk getting full… this otherwise, while checking dozens of possible causes? Unlike with monitoring, you should measure and store everything you can, for as…
Post: Living with backups
November 6, 2008 By 28 Comments
… disk operations are scheduled and executed which converts into slower queries execution and significantly degraded performance. Anything else? All modern systems… next step was to constantly monitor the database status and if any problems were noticed, the monitoring would simply pause the copying…
Comment: How to Monitor MySQL with Percona's Nagios Plugins
February 23, 2012 By 11 Comments
… things very differently from Shlomi’s mycheckpoint and the PalominoDB monitoring tool. However, I do have to say that your experience… in place for a ratio or threshold (say, long-running query) just to get some data (for example, how many times… do choose to monitor ratios/thresholds, think about what purpose the monitoring serves” – and that goes for whether the monitoring is alerts or…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…/5.5.8 tmpdir=/home/mysqld/mdmp/tmp slow_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size…-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor boonton: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character…-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor ======== ==> max_heap_table_size=128M
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… 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… STARTING BY ‘salaries\t’ (emp_no, from_date, salary, to_date); Query OK, 3 rows affected (0.01 sec) Records: 3 Deleted…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
… deletion. By the way, this is a good reason to monitor existence of these files! But after the restart InnoDB will… application or lock tables: mysql> flush tables with read lock; Query OK, 0 rows affected (0.37 sec) Now let’s… dirty pages are flushed on disk. For that we will monitor checkpoint age. The checkpoint age is a difference between current…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
… -uroot –protocol=tcp –port=9317 test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is… rows affected (0.11 sec) mysql> insert into t1 values (),(),(),(),(); Query OK, 5 rows affected (0.06 sec) Records: 5 Duplicates… get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is…
