Most of the Nagios plugins included with the Percona Monitoring Plugins are purpose-built for specific scenarios that I found … change over time for one or more counters (e.g. queries per second) The documentation contains examples of how to do…
Post: Using flow control functions for performance monitoring queries
May 24, 2008 By 12 Comments
… IF or CASE used in MySQL Queries as they are often abused used to create queries which are poorly readable as well… | 0.0017 | +———+——————+——–+——–+——–+ 1 row in set (7.51 sec) This query scans through page generation log for some site and reports… well as classifies requests to multiple classes. From the same query we can see portion of requests which were over 300ms…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… yet another set of MySQL monitoring plugins? The typical problem with Nagios monitoring (and indeed with most other monitoring systems) is the alert spam. I’ve spoken to a lot of users with monitoring… the incremental increase in a variable such as Queries and alert on a queries-per-second threshold. (I don’t suggest doing…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
…, primitively, tells Innodb that it should start the Table monitor. The monitor itself dumps the contents of the Data dictionary to the… looks something like this: =========================================== 090420 12:09:32 INNODB TABLE MONITOR OUTPUT =========================================== ————————————– TABLE: name SYS_FOREIGN, id 0 11, columns 7… the system, but also there were over a hundred user queries in SHOW PROCESSLIST that were stuck in the ‘Opening Tables…
Post: Query Response time histogram - new feature in Percona Server
July 11, 2010 By 11 Comments
Recently we had couple posts dedicated to performance monitoring, i.e. Color code your performance numbers, Performance Optimization and … implemented this feature. The feature adds new INFORMATION_SCHEMA table QUERY_RESPONSE_TIME ( full docs are on page response_time_distribution…
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
… the protocol. This lets us gather queries from servers that don’t have a slow query log enabled, at very high time… functionality, it becomes possible for mk-query-digest to stand on the sidelines and watch queries fly by over TCP. It is… every bit of information about queries that mysql-proxy can, making this a viable way to monitor servers without the disadvantages of…
Post: Percona's Commitments to MySQL Users
November 5, 2010 By 10 Comments
…. We have also worked to create open-source tools for monitoring, query analysis, replication management, and other capabilities. If you’re worried…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…printout Innodb will print: ===================================== 060717 3:07:56 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 44…STATUS, such as statement which is being executed, query id, query status etc. Next section you will see is …
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: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… 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…
