'Code' Category

• Indexed CSV

  July 26, 2012

  Why is there no index for CSV files?  Indexes are very simple. If the first column of your CSV file is in sorted order you can do a binary search to find your data.  But what if you need to find data in the second or third column? If you have a separate index file […]

  posted in Code, Commentary by mark

• automysqlbackup 2.5.5

  July 12, 2011

  I spent my day doing updates to the automysqlbackup script.  Here is some of what I’ve added over the last year. The bug number fixes are from SourceForge.  https://sourceforge.net/tracker/?atid=628964&group_id=101066&func=browse # 2.5.5 MTG – (2011-07-21) #    – Bug – Typo Ureadable Unreadable config file line 424 – ID: 3316825 #    – Bug – Change “#!/bin/bash” to […]

  posted in Code by admin

• mg_hot_replace_table.pl

  May 1, 2010

  Do you have MyISAM tables you reload with new data? Do your queries, using that table, get blocked because the table is locked? Do the waiting queries create idle connections slowing down the table load? Do you wish you could just replace the table? Years ago I was told you can replace CSV tables by […]

  posted in Code by admin