• Passwords which are bad for your health

    December 20, 2009

    I’ve seen some passwords to take a few years from my life.
    I mean, we all know about dictionary words, right? And we’ve all seen Spaceballs, right? But choosing 12345 as your password is not the only careless option: there are many more! The more I get familiar with user’s password, the more I see how [...]

  • New and noteworthy in mycheckpoint (rev. 57)

    December 16, 2009

    Rev. 57 of mycheckpoint has been released and is available for download.
    New and updated in this revision:

    Remote host monitoring
    Improved charting
    Flexible charting
    Fix to questions vs. queries issues

    Remote host monitoring
    It is now possible to monitor one host, while writing into another. Either or both could be remote hosts:

    mycheckpoint –host=localhost –monitored-host=192.168.10.178

    The above monitors the MySQL server on 192.168.10.178, [...]

  • In favour of a milestone based release model

    December 15, 2009

    I like milestone based release models.
    The advantages I find in this model are in particular beneficial for MySQL. What I find good about this model are:

    Things are unstable for shorter periods. Even if some feature is not full stable in some milestone, the model encourages that such a feature is fixed on higher priority.
    It is [...]

  • RPM builds for openark kit

    December 10, 2009

    Thanks to Lenz Grimmer, openark kit is now available in RPM format.
    .DEB or python packages are available, as usual, on project page on Google Code.
    Thank you, Lenz!

  • Useful temporal functions & queries

    December 8, 2009

    Here’s a complication of some common and useful time & date calculations and equations. Some, though very simple, are often misunderstood, leading to inefficient or incorrect implementations.
    There are many ways to solve such problems. I’ll present my favorites.
    Querying for time difference
    Given two timestamps: ts1 (older) and ts2 (newer), how much time has passed between them?
    One [...]

  • On restoring a single table from mysqldump

    December 1, 2009

    Following Restore one table from an ALL database dump and Restore a Single Table From mysqldump, I would like to add my own thoughts and comments on the subject.
    I also wish to note performance issues with the two suggested solutions, and offer improvements.
    Problem relevance
    While the problem is interesting, I just want to note that it [...]

 
Powered by Wordpress and MySQL. Theme by openark.org