'MySQL' Category

  • mk-schema-change? Check out ideas from oak-online-alter-table

    March 10, 2010

    In response to Mark Callaghan’s post mk-schema-change.
    I apologize for not commenting on the post itself, I do not hold a Facebook account. Anyway this is a long write, so it may as well deserve a post of its own.
    Some of the work Mark is describing already exists under openark kit’s oak-online-alter-table. Allow me to explain [...]

  • Things to monitor on MySQL, the user’s perspective

    March 10, 2010

    Working on mycheckpoint, I have the intention of adding custom monitoring. That is, letting the user define things to monitor. I have my own thoughts, I would be grateful to get more input!
    What would the user want to monitor?
    Monitoring for the number of SELECT statements per second, InnoDB locks, slave replication lag etc. is very [...]

  • Tip: faster than TRUNCATE

    March 9, 2010

    TRUNCATE is usually a fast operation (much faster than DELETE FROM). But sometimes it just hangs; I’ve has several such uncheerful events with InnoDB (Plugin) tables which were extensively written to. The TRUNCATE hanged; nothing else would work; minutes pass.
    TRUNCATE on tables with no FOREIGN KEYs should act fast: it translate to dropping the table [...]

  • Quick reminder: avoid using binlog-do-db

    March 2, 2010

    Nothing new about this warning; but it’s worth repeating:
    Using binlog-do-db is dangerous to your replication. It means the master will not write to binary logs any statement not in the given database.
    Ahem. Not exactly. It will not write to binary logs any statement which did not originate from the given database.
    Which is why a customer, [...]

  • Static charts vs. interactive charts

    March 2, 2010

    I’m having my usual fun with charts. Working on mycheckpoint, I’ve generated monitoring charts using the Google Chars API. But I’ve also had chance to experiment and deploy interactive charts, JavaScript based. In particular, I used and tweaked dygraphs.
    I’d like to note some differences in using charts of both kinds. And I think it makes [...]

  • What I look forward to hear on “State of the Dolphin”, 2010

    March 1, 2010

    Though most probably I won’t be there in person, here’s what I expect to hear from Edward Screven, Oracle, on the State of the Dolphin keynote, coming MySQL Conference & Expo.
    I’m under the assumption that no shocking news are delivered. That is, that for the near future, it’s business as usual for MySQL.
    Last year’s great [...]

  • 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 the longest downtime you [...]

  • 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 preferring CPAN [...]

  • 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 perhaps all three of them) share the same mount point. [...]

  • 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 f(x) [...]

 
Powered by Wordpress and MySQL. Theme by openark.org