'Code' Tag

• 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

• Developer Tips using MySQL

  April 19, 2010

  I get ask, by application developers,  “how do you optimize MySQL”.  I do lots of things that don’t really relate to a developer. I analyze the percent of queries are being pulled from cache for instance.  What a developer can do to optimize the SQL they develop is a different questions.   So here is a […]

  posted in Tips & Tricks by mark