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

• MySQL GIS – Part 1

  August 23, 2010

  In my business (weather) we use lots map based (Geo) information.  Almost every table has latitude and longitude. Working with this kind of data can be exciting and frustrating.  This should give you a quick start into GIS with MySQL. “A geographic information system (GIS), or geographical information system, is any system that captures, stores, [...]

  posted in GIS, HOW TO, Tips & Tricks by mark

• 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

• Slapping MySQL-Proxy

  June 28, 2010

  I have old applications that need to read (and write) MyISAM tables that themselves receive lots of bulk updates. Time to try MySQL-Proxy. MySQL Proxy is light on documentation and very few people written anything about working.   Most of what I have read says MySQL-Proxy is not ready for prim time.  I have hope so [...]

  posted in Commentary by mark

• The OpenArk Kit

  March 25, 2010

  Shlomi Noach is DBA,  authorized MySQL instructor software developer and Winner of the MySQL Community Member of the Year, 2009. He has published his own collections of MySQL scripts and you might find them useful.  Shlomi calls them the “openark kit“. The available tools are: oak-apply-ri: apply referential integrity on two columns with parent-child relationship. [...]

  posted in Tips & Tricks by mark