'Tips & Tricks' Category

• The Full Monty – CentOS 5.5, drbd, PaceMaker, MySQL, Tunsten Replication and more

  August 1, 2011

  PART 1 – This will be a multi part post. After years of supporting MySQL, for many different companies, I’ve seen this story played out again and again. The company: chooses a Database Management System (MySQL) installs the DBMS on a computer with other processes writes many programs to access the data (Without concern on [...]

  posted in CentOS, DRDB, HA, Heartbeat, HOW TO, Tips & Tricks by mark

• What is this MySQL file used for?

  February 16, 2011

  MySQL keeps many different files, some contain real data, some contain meta data. Witch ones are important? Witch can your throw away? This is my attempt to create a quick reference of all the files used by MySQL, whats in them, what can you do if they are missing, what can you do with them. [...]

  posted in Tips & Tricks by mark

• 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

• 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

• Does Size or Type Matter?

  July 27, 2010

  MySQL seems to be happy to convert types for you. Developers are rushed to complete their project and if the function works they just move on. But what is the costs of mixing your types? Does it matter if your are running across a million rows or more? Lets find out. Here is what the [...]

  posted in Tips & Tricks, Tunning by mark

• Federated Tables

  July 7, 2010

  Your searching for how to create a join across two databases on two different servers and it can’t be done directly.   select  d1.a, d2.b from db1@server1 join db2@server2 where db1.c = db2.c; does not work. You learn about federated databases.  The federated storage engine allows accesses data in tables of remote databases.  Now how do [...]

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

• 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

• Compiling Drizzle on CentOS 5.4

  April 6, 2010

  I was able to compile Drizzle on CentOS today thanks to Neil Armitage post on his website. Clean install centos 5.4 with Development Tools and Development Libraries yum groupinstall “Development Tools” yum groupinstall “Development Libraries” Setup the drizzle user account and allow it to sudo /usr/sbin/visudo uncomment %wheel ALL=(ALL) NOPASSWD: ALL useradd drizzle gpasswd -a [...]

  posted in Tips & Tricks by mark