'Code' Category

• 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

• HandlerSocket plugin – NoSQL/SQL interactions

  December 28, 2010

  HandlerSocket is cool. But, it turns out there are a few issues. Justin Swanhart points out HandlerSocket currently lacks atomic operations . Since HandlerSocket uses different connections for reading and writing, you can’t increment/decrement a value without creating a race condition. Still, the idea of skipping SQL interpretation and just reading the data you know [...]

  posted in Code, Commentary by mark

• Using HandlerSocket Plugin for MySQL with PHP

  December 28, 2010

  This document was updated and tested for CentOS 6.0 In my last two posts I installed the HandlerSocket plugin into MariaDB and showed how to use it with Perl.  That’s good, but if you are thinking of using HandlerSocket  I’m guessing you have a very high traffic website and it’s written in PHP.  In this [...]

  posted in CentOS, Code, HOW TO by mark

• MyTOP Upated

  June 24, 2010

  MyTOP is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL. UPDATE – I just fond Jeremy did update MyTOP in 2009 and released it on GitHub.  He fixed the 64x and 5.x bugs. He also incremented the version number to 1.7.  So, I’m bumping my number to 1.8. Jeremy [...]

  posted in Code, MyTOP, Tips & Tricks 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

• New AutoMySQLBackup Script

  April 19, 2010

  (2010/11/04) NEWS: Life has been restored in the source forge project after four years!  A new version 2.5.1-01 has been released.  I am working on merging my modifications with the new code and contacting the developers in the project with the new code. MySQL Backup Script has been around for a long time.  I have [...]

  posted in Code, Tips & Tricks by mark