• On free and open blog posts: this post is free

    October 21, 2009

    I'd like to criticize and stress some opinions on free and open blog posts, including such appearing on planet MySQL. Some rants follow; skip if you're only after technical stuff 1. On free reading This post is completely free. You don't need to pay or register to read it, not will you require to pass […]

  • How to calculate a good InnoDB log file size - recap

    October 20, 2009

    Following Baron Schwartz' post: How to calculate a good InnoDB log file size, which shows how to make an estimate for the InnoDB log file size, and based on SQL: querying for status difference over time, I've written a query to run on MySQL 5.1, which, upon sampling 60 seconds of status, estimates the InnoDB […]

  • SQL: querying for status difference over time

    October 20, 2009

    The InnoDB plugin has a nice INFORMATION_SCHEMA concept: resetting tables. For example, the INNODB_CMP table lists information about compression operation. A similar table, INNODB_CMP_RESET, provides the same information, but resets the values. The latter can be used to measure, for example, number of compression operations over time. I wish to present a SQL trick which […]

  • How to export OpenOffice presentations to PDF

    October 16, 2009

    OpenOffice 3.x has an improved PDF export mechanism. With File->Export as PDF..., one can export a presentation file (*.odp) to PDF format. [Edit: see updated notes at the end of this post] But there is a "feature" which is very annoying. One can export the presentation: Without notes, in which case the presentation frames are […]


    October 14, 2009

    MySQL 5.1 boasts some new and useful INFORMATION_SCHEMA tables. Among them is the GLOBAL_STATUS table. At last, it is possible to ask questions like: node1> SELECT * FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'innodb_os_log_written'; +-----------------------+----------------+ | VARIABLE_NAME         | VARIABLE_VALUE | +-----------------------+----------------+ | INNODB_OS_LOG_WRITTEN | 512            | +-----------------------+----------------+ 1 row in set (0.00 sec) node1> SELECT * […]

  • How NOT to test that mysqld is alive

    October 1, 2009

    I had a call from a new customer last week. They had issues with their MySQL server. Apparently, it was repeatingly crashing, every few hours. To have their production system kept alive, they used a script to periodically see if MySQL was still alive, and if not - start it. I was first thinking in […]

Powered by Wordpress and MySQL. Theme by openark.org