… for the next release of MHA. Q: How do you monitor MySQL to determine when it’s not responsive? A: The… example, if you see a large number of long-running queries in the output of SHOW PROCESSLIST that might be a… and PRM simply attempt to connect and run a simple query, but it’s always possible to build something more involved…
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 11 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 MySQL Webinar: Really Large Queries: Advanced Optimization Techniques, Feb. 27
February 18, 2013 By 2 Comments
…caption id=”attachment_12964″ align=”alignright” width=”285″] Really Large Queries: Advanced Optimization Techniques: Wednesday, February 27, 2013 10 a.m… query execution time from 10s of seconds to a fraction of a second. More info: Imagine a query that barely fits your monitor… the gap between reading explain output and optimizing really large queries. Practical techniques used to address real-world situations will be…
Post: Quality Assurance: Percona Server Development Now Monitored by Automated Sysbench Performance Regression Checks!
October 23, 2012 By Leave a Comment
… within Percona, we now have exactly such automated performance regression monitoring in place: Live Percona Server Performance Regression Checks Using Sysbench… 15 minutes each. We then extract the total number of queries executed during each run and plot them (using the Jenkins…
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 …
