openark forge

Open source utilities
 

Protected: mysqlawards2013 II

February 12, 2013

This content is password protected. To view it please enter your password below:

Protected: mysqlawards2013

February 6, 2013

This content is password protected. To view it please enter your password below:

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

December 2, 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 and client scripts, allowing the DBA to be independent of operating system, installed packages and dependencies.

There’s no Perl nor Python, and no dependencies to install. It’s just a schema.

Some highlights for the new revision:

  • foreach(), aka $(): loop through a collection, execute callback commands per element.
  • repeat_exec(): a repeat-until device: execute queries until some condition holds.
  • exec_file(): execute files a-la SOURCE, but on server side
  • Query analysis: analyze query text, view or routine definitions to detect dependency objects.
  • Improvements to views and routines, new routines introduced.

Read complete announcement here.

Announcing common_schema: common views & routines for MySQL

July 13, 2011

common_schema is released, at revision 50.

common_schema is a utility schema for MySQL, consisting of views, tables & routines to assist in analysis, monitoring, managing security, refactoring and more operations.

Downloads can be found at the common_schema project page.

mycheckpoint revision 208 is available

November 8, 2010

Revision 208 of mycheckpoint has been released. New and updated in this revision:

  • Aggregation tables: aggregated data makes for fast reports on previously slow queries.
  • Enhanced charting: interactive charts now present time stamps dynamically (see demo); “Zoom in” charts are available (see demo) on mycheckpoint‘s HTTP server.
  • RPM distribution: a “noarch” RPM mycheckpoint build is now available.
  • Initial work on formalizing test environment

Read the full announcement on openark.org blog.

mycheckpoint (rev. 192): update for rev. 190

September 14, 2010

Revision 192 is released, and fixes Issue 16 found in revision 190, and which relates to usage with remote monitoring along with custom queries and alerts.

mycheckpoint revision 190 is available

September 7, 2010

Revision 190 of mycheckpoint has been released. New and updated in this revision:

  • HTTP server: mycheckpoint can now act as a web server. Point your browser and start browsing through HTML reports. See mock up demo.
  • Interactive charts: HTML line charts are now interactive, presenting with accurate data as you move over them. See sample.
  • Enhanced auto-deploy: now auto-recognizing failed upgrades.
  • Reduced footprint: much code taken out of the views, leading to faster loading times.
  • Better configuration file use: now supporting all command line options in config file.
  • Remote host monitoring accessibility: now supporting complete configurable accessibility details.
  • Bug fixes: thanks to the bug reporters!

Read the full announcement on openark.org blog.

mycheckpoint revision 174 is available

July 23, 2010

This is a bugfix version for revision 170. No new features are added.

mycheckpoint revision 170 is available

July 16, 2010

Revision 170 of mycheckpoint has been released. New and updated in this revision:

  • Improved custom queries: lifting of limitations from previous, introductory revision; better HTML presentation
  • Local, inline charting: no rendering of Google Charts, unless explicitly requested. All charts are now rendered locally using JavaScript. No data is now sent over the network.
  • Page/Swap I/O monitoring: now monitoring for page ins and outs, swap ins and outs (Linux only).
  • Improved HTML reports: several improvements on presentation (see sample).

Read the full announcement on openark.org blog.

mycheckpoint revision 132 is available

June 4, 2010

Revision 132 of mycheckpoint has been released. New and updated in this revision:

  • Custom monitoring: monitoring & charting for user defined queries
  • HTML reports for custom monitoring
  • Process list dump upon alert notifications

Read the full announcement on openark.org blog.

 
Powered by Wordpress and MySQL. Theme by openark.org