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

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

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

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

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

 
Powered by Wordpress and MySQL. Theme by openark.org