'Analysis' Tag

• common_schema 1.1 released: split(), try-catch, killall(), profiling

  September 4, 2012

  I'm very happy to announce the release of common_schema, version 1.1 (revision 300). This version boasts with compelling new features: innovative QueryScript syntax, libraries, views which add to your skills as a DBA, making some maintenance and management tasks a breeze. QueryScript, split statement: automagically break long queries into smaller chunks, avoid long locks and [...]

  posted in MySQL by shlomi

• common_schema, rev. 178: foreach(), repeat_exec(), Roland Bouman, query analysis

  December 1, 2011

  common_schema, revision 178 is now released, with major additions. This revision turns common_schema into a framework, rather than a set of views and functions. common_schema provides with query scripting, analysis & informational views, and a function library, allowing for easier administration and diagnostics for MySQL. It introduces SQL based tools which simplify otherwise complex shell [...]

  posted in MySQL by shlomi

• MySQL Global status difference using single query

  August 12, 2011

  Have just read MySQL Global status difference using MySQL procedures / functions, by Andres Karlsson. Have commented, but realized I did not provide with a direct answer. In the comment, I suggested checking out a solution based on views, found in common_schema. But the solution in common_schema is split into two views, due to the [...]

  posted in MySQL by shlomi

• Announcing common_schema: common views & routines for MySQL

  July 13, 2011

  Today I have released common_schema, a utility schema for MySQL which includes many views and functions, and is aimed to be installed on any MySQL server. What does it do? There are views answering for all sorts of useful information: stuff related to schema analysis, data dimensions, monitoring, processes & transactions, security, internals... There are [...]

  posted in MySQL by shlomi

• Checking for AUTO_INCREMENT capacity with single query

  April 5, 2011

  Darn! This means oak-show-limits becomes redundant. Am I not supposed to speak about it on my coming presentation? Bad timing! You have AUTO_INCREMENT columns. How far are you pushing the limits? Are you going to run out of AUTO_INCREMENT values soon? Perhaps you wonder whether you should ALTER from INT to BIGINT? The answer is [...]

  posted in MySQL by shlomi

• oak-hook-general-log: your poor man's Query Analyzer

  December 15, 2010

  The latest release of openark kit introduces oak-hook-general-log, a handy tool which allows for some analysis of executing queries. Initially I just intended for the tool to be able to dump the general log to standard output, from any machine capable to connect to MySQL. Quick enough, I realized the power it brings. With this [...]

  posted in Development, MySQL by shlomi

• openark-kit (rev. 170): new tools, new functionality

  December 15, 2010

  I'm pleased to announce a new release of the openark kit. There's a lot of new functionality inside; following is a brief overview. The openark kit is a set of utilities for MySQL. They solve everyday maintenance tasks, which may be complicated or time consuming to work by hand. It's been a while since the [...]

  posted in Development, MySQL by shlomi

• EXPLAIN: missing db info

  May 11, 2010

  I'm further developing a general log hook, which can stream queries from the general log. A particular direction I'm taking is to filter queries by their type of actions. For example, the tool (oak-hook-general-log) can be instructed to only stream out those queries which involve creation of a temporary table; or those which cause for [...]

  posted in MySQL by shlomi

• Static charts vs. interactive charts

  March 2, 2010

  I'm having my usual fun with charts. Working on mycheckpoint, I've generated monitoring charts using the Google Chars API. But I've also had chance to experiment and deploy interactive charts, JavaScript based. In particular, I used and tweaked dygraphs. I'd like to note some differences in using charts of both kinds. And I think it [...]

  posted in MySQL by shlomi

• Performance analysis with mycheckpoint

  November 12, 2009

  mycheckpoint (see announcement) allows for both graph presentation and quick SQL access to monitored & analyzed data. I'd like to show the power of combining them both. InnoDB performance Taking a look at one of the most important InnoDB metrics: the read hit ratio (we could get the same graph by looking at the HTML [...]

  posted in MySQL by shlomi