'Commentary' Category

• It’s about Time.

  January 27, 2011

  WHAT TIME IS IT? This post started with a simple question: “Does the function NOW() get executed every time a row is examined?” According to the manual,  “Functions that return the current date or time each are evaluated only once per query …. multiple references to a function such as NOW() … produce the same [...]

  posted in Commentary, Tips & Tricks, Tunning by mark

• 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 Perl

  December 23, 2010

  In my last post I installed the HandlerSocket plugin into MariaDB and tested it.  Like the last post these examples are done with Linux CentOS 5.5. HandlerSocket some with Perl code for the Net:: module group. When you build and install the HandlerSocket plugin it does not build the Perl module. I looked and it [...]

  posted in Commentary, HOW TO by mark

• Book Review: Web Operations

  October 19, 2010

  Web Operations - Keeping the Data On Time ByJohn Allspaw, Jesse Robbins Publisher:O’Reilly Media Released:June 2010 This is simply the best book on running a commercial web services I have ever read.  Lots of texts cover parts and pieces of the what it takes from to manage a website. They will tell you how to configure Apache or how [...]

  posted in Commentary by mark

• MySQL GIS – Part 5

  September 28, 2010

  VIEWING THE DATA You’ve seen in the last few postings how to find, import and use GIS data with MySQL. But, the ‘G’ in geographical includes GRAPHIC and a little eye candy never hearts your understanding of the curves. Everyone knows of  map.google.com.  Mark McClure has a great site explaining the use of Google’s APIs.  [...]

  posted in Commentary by mark

• Reply to – Finding a Good DBA

  September 17, 2010

  On DBA Survivor, Thomas LaRock blogged about “Finding a Good DBA“.  This is a reply. Tweet

  posted in Commentary by mark

• MySQL GIS – Part 2

  August 30, 2010

  The “DATA” “The wonderful thing about standards is that there are so many of them to choose from.” – Grace Hopper A Shape file is the most common format for GIS vector data and just about every GIS program can use them.  Unfortunately not all GIS data come in a shape file format. An E00 [...]

  posted in Commentary 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

• Install MariaDB on RedHat 5.4

  May 4, 2010

  Is MariaDB really a drop in replacement for MySQL?   I’m running CentOS 5.4.  What happens if… Use “mysqldump –all-databases > FullBackup.sql” to make a full backup. (Better safe then sorry) Go to http://askmonty.org/wiki/MariaDB:Download and download the CentOS 5 packages. Stop msql “service mysqld stop” Pull MySQL out by the roots with “rpm -e mysql-server mysql [...]

  posted in Commentary by mark

• Jonathan Schwartz leaves Sun/Oracle

  April 29, 2010

  I read in his blog Jonathan Schwartz is leaving Sun/Oracle.  Jonathan was the CEO, Sun Microsystems, Inc. Jonathan has been the force at Sun driving open source.  His voice will not be heard at Oracle so I’m wondering if this will make a change in the way projects like MySQL, Open Solaris and Open Office [...]

  posted in Commentary by mark