…’ value for this workload, so we would have lots of diagnostics information to review even if we couldn’t be logged… servers with thousands of connections. Enter pt-query-digest. The tool supports its share of format parsers, but the one that… ‘raw’ log parser. If you specify –format rawlog, then the tool expects the input to have one query per line, and…
Post: Basic performance and diagnostic tools on Solaris
February 14, 2011 By 7 Comments
…. Here’s a quick list of some key tools. Many of the tools you’re used to from Linux will work, although… preferred is top. Instead, you should use the native Solaris tool, prstat, which is more accurate. To display information about processors… gives you), use prtconf and/or sysdef. To print system diagnostic information, use prtdiag. To describe the hardware’s instruction set…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
… for MySQL: CPU, disks, memory, network; and how to use diagnostic tools in Linux. Investigate database trends via the counters exposed in… buffer, adaptive hash and double write buffer. Learn to read diagnostic information from InnoDB and make informed decisions while changing configuration…
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
…, and mk-query-digest is an excellent tool. I do not know of any comparable tool for mysql, but this one gives…. What would be a good help is to have a tool that can correctly rewrite the SQL statement, make several rewrites… a zillion times. Of course, this is not a diagnostic tool but a tool for finding a solution when the problem is identified…
Post: Percona Live Keynote Speaker: Mark Callaghan
January 12, 2011 By 3 Comments
… the community with a publicly available branch of enhancements, improved diagnostic tools, and bug reports which help make MySQL better. Mark’s…
Comment: MySQL 5.1 Stability
July 1, 2008 By 12 Comments
Mark, Indeed it would be great to get some platform independent diagnostic tool to see where things are stuck.
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… approach and good tools. The process is straightforward: Determine what conditions are observably abnormal when the problem occurs. Gather diagnostic data when… tools for troubleshooting intermittent problems: stalk, collect, and sift. As the names suggest, they are used to watch the server, gather diagnostic…
Post: Percona Server with XtraDB Case Study, Behind the Scenes
October 21, 2010 By 13 Comments
… about diagnosing the problem correctly. I used a variety of tools to help with this, foremost among them “stalk” and “collect… noise. Knowing when and how to get and interpret good diagnostic data is easily 95% or 98% of the work in… do was wait until the problem happened, look at the diagnostics, and a couple minutes later I had my answer. What…
Post: Logging Deadlock errors
September 19, 2012 By 4 Comments
The principal source of information for InnoDB diagnostics is the output of SHOW ENGINE INNODB STATUS but there … to talk about pt-deadlock-logger. pt-deadlock-logger The tool is very simple and useful. It monitors the output of… STDOUT the deadlocks that are happening on our database. This tool is usually run for a long period of time that…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
… Percona Server, a great deal of additional performance and other diagnostic information. But the execution time recorded in the log is… you can analyze it easily with tools such as Maatkit’s mk-query-digest. These tools can do a lot of work…
