'Load' Tag

• MyTOP 1.9 released

  July 23, 2010

  MyTOP is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL created by Jeremy Zawodny. For months now I have been adding updates to mytop. When I started using version 1.6 it worked but didn’t return some data fields. After fixing these bugs I began to ideas for improvements. Here [...]

  posted in MyTOP by mark

• 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

• Loading Bulk CSV Tables

  March 23, 2010

  In my job I use many data tables that are transient.  New weather data is received all the time and old data is purged.  Most of these table are received as CSV files.  The data is then loaded into MySQL tables and indexed to be used with geographic queries. Most of these tables never see [...]

  posted in Tips & Tricks by mark