• Checking for string permutation

    January 20, 2010

    A permutation is a change of places. Thus, 'lolhe' is a permuted 'hello' (commonly referred to as 'scrambled text'). I wish to present an SQL solution for checking if two strings are permutations of the same text. About permutations So, if 'lolhe' is a permutation of 'hello', then 'hello' is a permutation of 'lolhe', as […]

  • Misimproving performance problems with INSERT DELAYED

    January 14, 2010

    INSERT DELAYED may come in handy when using MyISAM tables. It may in particular be useful for log tables, where one is required to issue frequent INSERTs on one hand, but does not usually want or need to wait for DB response on the other hand. It may even offer some performance boost, by aggregating […]

  • mycheckpoint rev. 76: OS monitoring, auto deploy, brief HTML and 24/7 reports

    January 5, 2010

    Revision 76 of mycheckpoint comes with quite a few improvements, including: OS monitoring (CPU, load average, memory) Auto-deploy Improved charting Brief HTML reports 24/7 charts OS Monitoring When monitoring the local machine, mycheckpoint now monitors CPU utilization, load average, memory and swap space. This only applies to the Linux operating system; there is currently no […]

  • Tales of the Trade #2: The Oracle-Sun deal

    January 3, 2010
Powered by Wordpress and MySQL. Theme by openark.org