• Defined your MySQL backup & recovery plan recently?

    February 17, 2010

    Following up on Ronald Bradford's Checked your MySQL recovery process recently? post, I wish to add a prequel. To see whether you have a clear definition of your backup requirements, ask yourself these questions: Is there a backup/restore plan? Is there a written backup/restore plan? How fast do you need to recover a backup? What's […]

  • To not yum or to not apt-get?

    February 16, 2010

    I've written shortly on this before. I like yum; I love apt-get; I prefer not to use them for MySQL installations. I consider a binary tarball to be the best MySQL installation format (source installations being a different case altogether). Why? I use yum and apt-get whenever I can and for almost all needs (sometimes […]

  • mycheckpoint (rev. 88): mount points monitoring, improved charting, enhanced auto-deploy

    February 10, 2010

    Revision #88 of mycheckpoint is released. In this revision: Disk space monitoring Improved charting Enhanced auto-deploy And more... Disk space monitoring mycheckpoint now monitors (on Linux only) three mount points: The "/" (root) mount point The datadir mount point The tmpdir mount point It may well be the case that two of the above (or […]

  • Monotonic functions, SQL and MySQL

    February 9, 2010

    In mathematics, a monotonic function (or monotone function) is a function which preserves the given order. [Wikipedia] To be more precise, a function f is monotonic increasing, if for every x ≤ y it holds that f(x) ≤ f(y). f is said to be strictly monotonic increasing is for every x < y it holds that […]

  • Beware of implicit casting

    February 2, 2010

    Ever so often a query provides a "bad" execution plan. Adding a missing index can many times solve the problem. However, not everything can be solved with an index. I wish to highlight the point of having an implicit cast, which negates the use of an index on MySQL. I see this happening a lot […]

 
Powered by Wordpress and MySQL. Theme by openark.org