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

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

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


Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org
Creative Commons License
MySQL Fan Boy by Mark Grennan is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.