Jason Hull of OpenSource Connections, a company in my town, posted an article on what Sun's acquisition of MySQL means for the US government. I thought Planet MySQL readers might appreciate a different angle on the issue than many of the Planet MySQL posts, which are often focused on business or community more than government. (I'm just passing the link along, not agreeing or disagreeing).

American LaFrance has filed for Chapter 11 after not being able to properly migrate from their ex-parent company's ERP system to a new one that was being implemented by IBM. They said that the new system caused production disruptions and left the company with a $100m debt. The company is now taking action "based upon services provided by IBM in connection with the problem-riddled transition to the ERP system."

Hmmm... since the transition was done last year, I wonder whether IBM really is to blame? Did they not have a QA environment?

A useful SQL query I worked out yesterday.

It finds all the indexes in the database "my_database" that have a cardinality/count ratio of less than 0.1%

Such indexes are probably not very useful, and should be looked at carefully to justify their existence.


use information_schema;

select tables.table_name, statistics.index_name, statistics.cardinality, tables.table_rows

  from tables

  join statistics

  on (statistics.table_name = tables.table_name

   and statistics.table_schema = 'my_database'

   and ((tables.table_rows / statistics.cardinality) > 1000));



I worked this out on my current MySQL PS gig. The client has indexes on nearly every column of nearly every table. For example, all of their customers are in Texas, but they …

And on goes my fascination with open source companies and their valuations…

I was reading Stephen O’Grady’s commentary on open source companies and their valuations prompted by the recent acquisition of MySQL by Sun for $1 billion. He quotes Jeff Gould who logically questions whether Sun can make the acquisition pay-off.

Stephen also quotes a piece from Knowledge@Wharton on the myth of market share.

It is a common practice of many companies to focus their attention on grabbing market share from their competitors. But such efforts can actually be detrimental to the firm’s profitability, according to Wharton marketing professor J. Scott …

The purpose of this post isn't by any way to bad mouth MySQL but rather to show the impact of lack of qualified DBAs to those who use MySQL.

I was shocked last year, when a CTO of a large company confided in me and said basically that they are so tired of searching for qualified MySQL DBAs that they may switch to Oracle. At some point, I guess the frustration alone can justify an otherwise unneeded cap-ex of such magnitude.

Today, I hear that ValueCentric, a pharmaceutical technology consulting firm based in New York, has decided to let go of MySQL in their environment and instead switched to Oracle on Oracle Linux.
"as the firm expanded and began taking on bigger clients like AstraZeneca, Roche and P&G Pharmaceuticals, company officials …

The rate of open source M&A continues apace, this time involving two open source software vendors. SpringSource has announced plans to acquire Covalent Technologies for an undisclosed fee. At first glance the deal makes a lot of sense as it marries SpringSource’s Spring Framework-related products and services with the Apache support and services offered by Covalent.

Coincidentally, as news of the deal filtered through to me I happened to be on the phone with …

While helping a user with some questions about the geospatial extensions of MySQL on the #mysql-dev IRC channel on Freenode, I stumbled over this blog: How to use MySQL Spatial Extensions. There currently is just one post, but it was exactly what we were looking for: "Using Circular Area Selection". Nice work! I hope the author will soon provide more examples of how to make use of this functionality.

By the way, there is work in progress to improve the GIS functionality in MySQL - if you are looking for new GIS functions that do not use …

This weekend we're hearing great news from Michael "Monty" Widenius - one of the Fathers of MySQL. Monty finally found a time to create his own blog with very descriptive name Monty Says. At the same time Monty finally announces Maria - the MyISAM successor storage engine he has been working for last few years. You can now get Maria from MySQL BitKeeper Server.

I'm really excited to see Monty speaking publicly again in the free form rather than in form of sanitized interviews and press releases we've seen during recent years.

I'm also excited to see Monty finally releasing his new brainchild and putting his personal commitment behind it: "NOTE: The opinions and promises stated in this FAQ is by the Maria development …

For some reason the MySQL examinations have escaped the notice of the test bank world. I will admit to being a little disappointed when I was studying for my CMDBA exams (before I was a MySQL employee) to find no additional study materials other than the MySQL 5.0 Certification Study Guide. The study guide is great but grad school taught me their is no preperation better than overkill. Today I was forwarded the question that titles this entry and I replied that the test bank companies offer no sample exams.

There are some example questions that I modeled closely to the questions you will see on the six MySQL exams. Previously there had been some questions from the 4.x exams that did not reflect the current material.

Test banks are not a panacea. Some are a pan of #$%@!!! I spent twenty bucks on one when studying for the Linux …

As you might know even if you're only using Innodb tables your replication is not completely crash safe - if Slave MySQL Server crashes/power goes down it is likely for relay logs to run out of sync (they are not synced to the disk) plus position on the master which slave remembers becomes stale.

During MySQL 4.0 and 4.1 series there was a great workaround if you're using only Innodb tables - Innodb when Innodb does crash recovery it would print position in master log files up to which replication was done:

PLAIN TEXT SQL:

1. InnoDB: IN a MySQL replication slave the last master binlog file
2. InnoDB: position 0 115, file name portland-bin.001717

All you needed to do is to use --skip-slave-start on the slave server and have a little script which will do CHANGE MASTER TO to specified location to restore replication in case of crash (assuming …