I’ve written shortly on this before. I like yum; I love apt-get; I prefer not to use them for MySQL installations. I consider a binary tarball to be the best MySQL installation format (source installations being a different case altogether). This article explains why.

tutorial de mysql workbecnch

Maximize your strengths, minimize your weaknesses. You can apply this approach to many things in life, I apply it to describing and using MySQL the product, and it’s components. The Query Cache like many features in MySQL, and indeed features in many different RDBMS products (don’t get me started on Oracle *features*) have relative benefits. In one context it can be seen as ineffective, or even detrimental to your performance, however it’s course grain nature makes it both trivial to disable dynamically (SET GLOBAL query_cache_size=0;), and also easy to get basic statistics on current performance (SHOW GLOBAL STATUS LIKE ‘QCache%’;) to determine effectiveness and action appropriately.

Install isolated side-by-side MySQL instances right the first time with this time-saving virtual manager. Jeremy Zawodny tests MySQL Sandbox with a thorough description.

MySQL DML Statistics using mysqlbinlog - 1 liner

This is an issue that keeps rearing its ugly head over and over again, and since it greatly affects performance, it is most important that DBAs of any DMBS running on Linux come to grips with it. So I decided to do some research and try different settings on my notebook. Here are my findings.What can you find on the web?A Wikipedia search for the word swappiness will come up empty (any volunteers out there want to write an article?). A Google search will show some pretty old material---the best article I found is from 2004: Linux: Tuning Swappiness. This article includes a detailed discussion with some interesting remarks by Andrew Morton, a Linux kernel maintainer.So, what is swappiness?

REPLACE does the equivalent of "find and replace".

An useful collection of places where you can find data available for benchmarks

inotify is a handy standard Linux kernel tool to track file access/writes under a live server.

The title says it all, and the explanation is very interesting. The consequences of disabling binlog due to lack of storage are catastrophic. Entertaining and worrying at the same time.

This post builds upon the earlier article (Creating a simple Cluster on a single LINUX host) which explained how to install and run a Cluster where all of the nodes run on the same physical host. The single host solution is not great for a real deployment - MySQL Cluster is designed to provide a High Availability (HA) solution by synchronously replicating data between data nodes - if all of the data nodes run on a single host that that machine is a single point of failure. This article demonstrates how to split the nodes between hosts; the configuration will still be fairly simple, using just 2 machines but it should be obvious how to extend it to more.

Based on a real-world case study from a comprehensive market intelligence product - developed for Boats.com/YachtWorld.com by Breadboard BI, Inc - this 45 minute presentation describes a multi-source, enterprise data warehouse developed on a 100% open source stack - MySQL 5.1 (with partitioning), Pentaho Business Intelligence Suite, Linux OS.