The latest from the MySQL community

SpringSource acquires Covalent. XAware obtains $7.4m in additional funding. Sun announces details of its $1m open source awards. (and more)

SpringSource Acquires Covalent Technologies, SpringSource / Covalent Technologies (Press Release)

XAware Secures $7.4 Million in Additional Funding to Further its Open Source Data Integration Business Initiatives, XAware (Press Release)

Open Source Communities Announce Participation Details For Sun Sponsored $1Million Innovation Awards Program, Sun Microsystems (Press Release)

…

It's only Tuesday and there have been two more acquisitions in the open source market. While these aren't huge deals on the scale of JBoss or MySQL, they do signify ongoing consolidation in the market. -Nokia acquires Trolltech -SpringSource acquires Covalent Both these acquisitions seem to make sense from a perspective of customers, users, and the companies on both sides. It's also interesting that these two recent deals show both the adoption of open source technology by a non-open source company and the combination of two open source companies to build a larger open source entity.... READ MORE

The last few days before the Sun-MySQL Integration Kickoff happening 29-31 January 2008 at Sun’s headquarters in Menlo Park, quite a few European MySQLers have approached me with concerns related to the potential danger of a skewed focus on the US in the integration discussions. After all, MySQL AB originates in Scandinavia and almost a majority of our employees work outside the US, so some aspects of MySQL AB should remain Scandinavian or European, even though we’re been acquired by a Silicon Valley based company.

While this geographic concern will remain on my agenda, yesterday evening provided some peace of mind on this account. Summoned by our Scandinavian CEO, a group of MySQLers (American and European) met at the Ikea restaurant in East Palo Alto.

Both the furniture and the food at Ikea looked much like in Gloms, Esbo (in my native Finland), or Kungens kurva close to Stockholm, or anywhere …

As MySQL Manual Says Query Cache works with transactions with Innodb tables but it does not tell you how and with which restrictions.

According to my tests it works but it is very restricted and one could expect it to work much better:

The result set can be retrieved from query cache (for statements both inside and outside of transactions) until there is a statement inside transactions which modifies the table. As soon as table is modified in transaction it becomes uncachable by query cache until that transaction is committed. Not only query cache can't be used inside the same transaction which modified data but also in other concurrent transactions which do not even see the changes done yet

Of course such implementation is rather restricted. Queries outside of transactions well could use query cache until it is invalidated by …

So my challenge last week was to convert almost a billion records in 37 databases and 74 tables. Oh, and I wanted to do it only during the night (between 12:30AM and 6AM) and in the least number of nights.

This was not my first massive MyISAM to InnoDB migration, nonetheless, I still manged to learn a few things. We're at a stage where MyISAM just isn't the solution any more. Our plans are to go almost 100% InnoDB and this migration project completes yet another massive step towards that direction.

The first night was depressing. I applied every trick up my sleeve but only ended up getting 9.48% complete. Second night was only half depressing allowing me to complete ~ 33%. Third night was a charm and I got ~42.5% done. I would have finished the project that night but there was some storage issue …

Obviously, 2008 is off to a roaring start for open soure M&A. Amid all of the deals and our usual discussions with open source software vendors, we’re hearing more and more executives talk about the long-term potential of business based on open code. The SpringSource acquisition of Covalent is a perfect example. We had just written about how Covalent was an attractive M&A target, and even though we may have viewed the acquirer, SpringSource, as more of a fellow target, the deal illustrates an interesting approach to the open source opportunity.

Both Covalent CEO Mark Brewer, who with other company executives bought out Covalent’s original investors, and SpringSource CEO Rod Johnson said their deal was not an effort to get dressed up for acquisition. While the combined company will remain an attractive acquisition target to SIs, OS vendors and others …

MySQL 5.0.51a was released today, which is a security hotfix release without any new features compared with 5.0.51. It fixes CVE-2007-6303, CVE-2007-6304, CVE-2008-0226 and CVE-2008-0227. These problems are already fixed in Debian with 5.0.32-7etch4 and …

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 …