• New and Noteworthy in openark kit

    June 30, 2009

    A new release of openark kit is out. Some interesting additions.changes are: oak-online-alter-table: now works with multicolumn UNIQUE KEYs New: oak-chunk-update: break an long running or non indexed UPDATE/DELETE to small chunks oak-purge-master-logs, oak-show-replication-status: support for non standard slave ports openark kit is a set of utilities for MySQL, helping in easing out everyday's work. […]

  • Unwalking a string with GROUP_CONCAT

    June 16, 2009

    "Walking a string" is an SQL technique to convert a single value into multiple rows result set. For example, walking the string 'hello' results with 5 rows, each of which contains a single character from the text. I'll present a brief example of walking a string, and then show how to "unwalk" the string: do […]

  • Even more on MySQL password security

    June 8, 2009

    This post follows Ronald Bradford's More Basic MySQL Security, and Lenz Grimmer's Basic MySQL Security: Providing passwords on the command line and More on MySQL password security. In Ronald's post I've argued that passwords provided on command line are visible in plaintext on "ps aux". Lenz has argued that this is incorrect, providing the source […]

 
Powered by Wordpress and MySQL. Theme by openark.org