During last couple of months I had number of consulting projects with MySQL Query Cache being source of serious problems. One would see queries both for MyISAM and Innodb tables mysteriously stalling for few seconds with "NULL" in State column.

These could be troubleshooted to waiting on Query Cache which at the same time had massive amount of entries invalidated by some batch data load job.

When you should worry ? If you set query_cache_size relatively high at 256MB or more. It can be seen worse if your query cache size is in Gigabytes. At the same time check how many queries do you have in cache - Qcache_queries_in_cache - if it is in hundreds of thousands it may take a while to invalidate them. But first of all you should have something which causes massive amount of invalidations like tens-hundreds of thousands queries being invalidated by single insert - this typically happens if you have …

In just about 12 hours, we will close Proven Scaling’s Free Ride to MySQL Conference and Expo 2007 form to new entries, and start deliberating on the winners. Get your entry in now if you want a chance to go to the MySQL event of the year for free!

Guy Bowerman has published on Informix Application Development, the 37th edition of Log Buffer, the weekly compendium of database blogs. Log Buffer always wants more editors and story suggestions, so if you read it, please also look at Log Buffer’s homepage to see how you can get involved. Next week, LB will appear on Padraig [...]

The Open Source thinker and BSD advocate Gianugo Rabellino just made me aware of a year-old blog entry by Susan Wu in Planet Apache on “Should OSI redefine the label Open Source?”. As I read the entry, it proposes a term “Open Development” and lists these “first stab” requirements:

1. an Open Source license, of course;
2. a non-discriminatory access to the developer?s community;
3. a well-defined and stated process for people to get involved;
4. a neutral and self-elected governing body;
5. (more difficult, could mean having a preferential lane) a neutral party such as a foundation owning the code.

I think Gianugo and Susan are …

As Kaj Arnö already mentioned in his blog, we have a vision for MySQL and it is called a scalable BLOB streaming infrastructure. Our plan is to build this into and around the MySQL architecture with the help of MySQL and the community.

It is a "big picture" idea and in this way a response to Robin Schumacher's question: The MySQL Vision - What do you see?. But at the same time it is very relevant and practical in the context of the Web 2.0 world.

The design of the system includes a client-side library which extends the existing MySQL client API, a stream based communications protocol and a scalable back-end which is (at least partially) linked into the MySQL server. In short, we want to make it possible to put BLOBs of any size in the database.

The …

Hello,

For those of you interested in learning about how to design high availability architectures using MySQL, DRBD and Linux Heartbeat, please check out next Wednesday's (3/28) webinar.

Info and registration:

http://www.mysql.com/news-and-events/web-seminars/mysql-drbd.php

See you there,

Jimmy

One of our product managers sent around a link to the site www.crankypm.com which describes the fictional life of a product manager at a mythical software company.  Having read a few of the essays on "A Day in the Life" and "All the Responsibility and No Authority" I think it's a pretty accurate description of life in the trenches in product management. 

Product Management is not an easy job, but its an …

MySQL Connector/Net 5.0.6 a new version of the all-managed .NET driver for MySQL has been released.
This is a bug fix release for the current production branch of Connector/Net.

 
Version 5.0.6 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0, MySQL-5.1 beta or the MySQL-5.2 Falcon "Preview".
It is now available in source and binary form from the Connector/Net download pages at http://dev.mysql.com/downloads/connector/net/5.0.html and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.)

 
This release comes shortly after 5.0.5 due to an incompatibility with Tools for Visual Studio.  With 5.0.5, we changed how the connector respects binary data …

New research data shows increased MySQL usage by developers…GoDaddy donates cash to two open source projects…open source mobile company Funambol releases survey data on mobile email…and more…

MySQL Gains 25% Market Share of Database Usage, Latest Evans Data Survey Shows, Evans Data (Press Release)

Funambol Study Reveals Millions of Consumers to Start Using Mobile Email Shortly, Funambol (Press Release)

World’s Domain Name & Hosting Leader Backs Open Source Community - GoDaddy.com Donates $10K to Both Joomla & Simple Machines, GoDaddy.com (Press Release)

CollabNet partners with …