• mycheckpoint (Rev. 118): alerts, email notifications and more

    March 25, 2010

    Revision 118 of mycheckpoint has been released. New and updated in this revision: Conditional alerts Email notifications Revised HTML reports, including 24/7 reports. Updated documentation With this new revision mycheckpoint turns into a monitoring solution for MySQL. One can now: Store measure metrics Query for raw, aggregated or digested metrics Generate charts for selected metrics […]

  • oak-hook-general-log: streaming general log

    March 21, 2010

    I'm seeking input on a new openark kit utility I've started to implement. The tool, oak-hook-general-log, will hook up to a MySQL (>= 5.1) server, and stream the general log into standard output. It looks like this: bash$ python src/oak/oak-hook-general-log.py --socket=/tmp/mysql.sock --user=root 2010-03-21 10:18:42     root[root] @ localhost []       79      1       Query   SELECT COUNT(*) FROM City […]

  • But I DO want MySQL to say "ERROR"!

    March 12, 2010

    MySQL is known for its willingness to accept invalid queries, data values. It can silently commit your transaction, truncate your data. Using GROUP_CONCAT with a small group_concat_max_len setting? Your result will be silently truncated (make sure to check the warnings though). Calling CREATE TEMPORARY TABLE? You get silent commit. Issuing a ROLLBACK on non-transactional involved […]

  • Proper SQL table alias use conventions

    March 11, 2010

    After seeing quite some SQL statements over the years, something is bugging me: there is no consistent convention as for how to write an SQL query. I'm going to leave formatting, upper/lower-case issues aside, and discuss a small part of the SQL syntax: table aliases. Looking at three different queries, I will describe what I […]

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

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

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

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

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

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

Powered by Wordpress and MySQL. Theme by openark.org