MySQL Fanboy

'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
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
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
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