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 simply replacing the CSV file. I figured this would also be true of a MyISAM file and it is. I use this perl script to replace MyISAM tables forcast and current observation weather data. The processing and tables are created on another computer. Weather forecasting is CPU and database expensive. I then copy (rsync) the files to the production system and run this script.
#!/usr/bin/perl ################################################################################ ################################################################################ # mg_hot_replace_table.pl - Hot Replace a MySQL table. # # 2010-05-01 …[Read more]