… there. Percona Toolkit Percona Toolkit is a great set of tools for MySQL Performance Analyses and maintainence. Must know and have… lot about server run status. mysqlreport MySQL Report is a tool which would look at status variables same as mysqladmin extended… your tablespace or table on the file level ? iostat iostat tool is a great help investigating/troubleshooting IO problems – it will…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 10 Comments
… Percona Toolkit. Percona Toolkit is the essential suite of administrative tools for MySQL. With this release we introduce a new version… table with no interruption. With this new version of the tool, one of the most painful things anyone experiences with MySQL…. The new 2.1 version of the tool removes those limitations and makes the tool fully featured and much easier to use…
Post: Aspersa tools bit.ly download shortcuts
April 17, 2011 By 4 Comments
… can download maatkit with a simple wget maatkit.org/get/tool command so I made bit.ly shortcuts for all of the current aspersa tools. Here’s the full list with my favorite on the… useful too. Aurimas Update: I made an error with align tool which now links to the root directory of a trunk…
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 sometimes they output different information. An example is vmstat. Many tools such as uptime will work as you’re used to… preferred is top. Instead, you should use the native Solaris tool, prstat, which is more accurate. To display information about processors…
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
… not work. The fincore looks more like proof of concept tool – it is a bit simplistic, however being written in Perl… cache. This function is actually the real meat here – the tool is simplistic but it shows how to use the function so you can write real stuff. For example using this tool MySQL can easily add amount of cached data per table…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
…_slow_verbosity. Actually, this is a very simple and straightforward tool to browse slow queries. The web interface is AJAX-based… their stats and post reviews. Box Anemometer Anemometer is a tool for visualizing collected data from the MySQL Slow Query Log… them into a database for reporting. Personally, I find this tool as an advanced instrument that could be useful for: * browsing…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 13 Comments
… Ignacio) have worked together to create tcprstat[1], a new tool that times TCP requests and prints out statistics on them…, troubleshooting, and monitoring to name just a few. The tcprstat tool itself is a means of gathering raw statistics, which are… means there are no dependencies. You can just run the tool. In the future, packages in the Percona repositories will provide…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… which take most time to execute combined. There is a tool mysqldumpslow in MySQL distribution which kind of does the thing… queries will be looked at. The other problem with this tool is – it replaces all real values with “N”, “S” etc… copy-paste query to run EXPLAIN for it. Using this tool normally require you to keep the other window open and…
Post: Webinar: 10 Percona Toolkit tools every MySQL DBA should know about
December 12, 2012 By Leave a Comment
…, I will be giving a webinar entitled “10 Percona Toolkit Tools Every MySQL DBA Should Know About”. As a Consultant, I make heavy use of Percona Toolkit tools while solving customers’ problems, and I have used this experience… should know about. I will present each of the selected tools using examples based on real-world cases. You can sign…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
….cnf files” online. The ultimate tool for generating an optimal my.cnf is not a tool. It’s a human with many… performance penalty. If it were as easy as writing a tool to do this, don’t you think Maatkit would have…’ll ever even feel motivated to try creating such a tool. Don’t bother with scripts. Don’t waste your time…
