• 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 […]

  • 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 […]

  • Where's my cnf file?

    December 7, 2010

    So you have a running MySQL server, it's working well and everyone's happy. You want to make a minor change to the configuration file, so you edit the file, restart MySQL - but the change doesn't catch! Or maybe you want to check that some global variable has not been dynamically changed without an update […]

  • Guide to MySQL installation files

    December 1, 2010

    Even for DBAs already familiar with MySQL, the choice of installation methods and the variety of install/package files is overwhelming and confusing. I'll make a (very!) brief introduction to the various installation options, concentrating on the Linux operating system, and provide with a simple shopping list. For illustration, I'll refer to the MySQL 5.1.52 community […]

 
Powered by Wordpress and MySQL. Theme by openark.org