(At least in Drizzle)

Brian merged my jay-and-stewart-remove-pack_flag branch and it’s now in trunk. Removing pack_flag was a task for the bell milestone and in true collaborative effort, it took more than one person to unravel its dark mysteries. Hats go off to Jay who bravely ripped more of it out with the aid of excellent Seattle coffee. I finished it off with removing the last remnants and fixing an outstanding bug (and at the same time making us look at the DECIMAL code and shuddering in fear of what it may mean).

With pack_flag gone, we can now do insane things like remove the last bits of TINYINT from the code, as previous to removing pack_flag, if you did that, things …

I use sysbench a lot for performance tests. It is a great tool and on top of that the code is easy to read and modify. I added a few changes to my Launchpad branch. I will describe the changes by the new options:

• --seed-rng -- sets the seed for the random number generator. I used this when running query cache tests to increase the cache hit rate. I ran sysbench twice with the same seed and as a result, most of the queries on the second run match those from the first run and re-use results from the query cache.
• --oltp-point-select-mysql-handler -- apart from having a really long name, this makes sysbench use HANDLER READ statements rather than SELECT …

Recently I decided to build my own forum software so I'm able to better control spam posts and make posting easier than it ever was.

All user accounts including passwords were imported into my new database. Only the name of the permanent cookie has changed so you might have to login once before posting now.

Email addresses are nowhere displayed, except for the settings page where you only see the more compact options, including a checkbox to turn email notification on replies on and off.

I'm going to add some formatting buttons to the posting form, and maybe some pulldown for smilies. Currently you can only post plain text messages, which is sufficient in many cases.

I'm also going to add support for creating Subversion revision URLs, automatically created if you type

r1234

. Same goes for issue ids when you want to refer to a bug report.

I hope you like …

(This note should not go to PlanetMySQL, sorry if it goes).
We again have problem with comments to blog posts. It's technical problem, we did upgrade some components and it seems it affected captcha. We are working on fix.
We are sorry for the inconvenience and thank for reports about the problem.

Entry posted by Vadim | No comment

Add to: | | …

Lot of talk lately about the effectiveness or lack thereof of the MySQL query cache.  I’m kind of surprised we are still having this discussion in late 2009, I really thought these issues have been long settled.

It’s well known that the query cache is terrible for environments with a constant stream of writes.  Each write invalidates the cached results for every query touching that table.  This means that your database needs to be constantly inserting and purging the query cache in an environment with mixed reads and writes (aka the most common type of “Web …

The open-source database company's one-time chief executive is now entrepreneur in residence at a leading Silicon Valley venture capital firm.

6.3.27a source release is now available from ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/

The source version for MySQL Cluster 6.3.27 has now been made available at ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.37-ndb-6.3.27/

You can either wait for the binaries to be released or if you’re in a rush then you can find instructions on building the binaries for yourself in the earlier article: “MySQL Cluster 7.0.7 source released“.

A description of all of the changes (fixes) that have gone into MySQL Cluster 6.3.27 (compared to 6.3.26) can be found in the …

7.0.8aa source release is now available from ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/

The source version for MySQL Cluster 7.0.8 has now been made available at ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.37-ndb-7.0.8/

You can either wait for the binaries to be released or if you’re in a rush then you can find instructions on building the binaries for yourself in the earlier article: “MySQL Cluster 7.0.7 source released“.

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.0.8 (compared to 7.0.7) can be found in the …

MySQL Cluster 7.0.8 was released as a source distribution 30th of Sept 2009. You should upgrade if you can build from source or use the Configurator.

See below how to upgrade when using the Configurator.

7.0.8 contains a number of fixes in almost every area and you are recommended to upgrade if you experience problems with earlier version(s). Especially if you have encountered the "error 306" problem.

The Configurator v2.9 has been updated to use this version.

If you are already using the Configurator and build from source you can upgrade from MySQL Cluster 7.0.7 to 7.0.8 (and you are recommended to …

On Monday, October 12, 2009* from 7-9 pm at MIT, I will be giving a presentation explaining SHOW ENGINE INNODB STATUS for the Boston MySQL User Group. There is information about foreign keys, transactions, deadlocks and mutexes just waiting to be discovered, and I will show how to decipher the information.

For all those in the Boston area, I hope to see you there! For those who cannot be there, we will video this presentation and make it available online, and post here when the video/slides are up.

*Yes, I realize that this is a bank holiday in the US.