'Examples' Tag

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

• 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

• MySQL GIS – Part 6

  November 12, 2010

  Is MySQL’s GIS really worth using? Is GIS worth using in MySQL? In the past few post, I have explored what GIS is and how it is used. GIS encoded data is wonderful and can help with all kinds of cool queries.  I’m late getting this article written so lets get right to it. The [...]

  posted in GIS by mark

• MySQL HA with DRDB and Heartbeat on CentOS 5.5

  July 20, 2010

  This is one of a few MySQL High Availability strategies.  I have used this for years and found it work great.  If you don’t know about DRBD and MySQL you should read Peter’s comments. These are step by step instructions for Redhat 5 or CentOS. If you need more details please refer to: http://www.drbd.org/users-guide/ Configuring [...]

  posted in CentOS, DRDB, HA, Heartbeat, Redhat by mark

• MySQL Network Connections

  May 7, 2010

  If your MySQL server has hundreds of clients (applications) and tens of thousands of queries per second,  MySQL default network settings may NOT be for you.  Network performance is not often a significant factor in the performance of MySQL.  That said, there are things to consider. If you are building new applications make these changes [...]

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