Solid's storage engine for MySQL (MySQL/solidDB) brings in an unexpected species to your computer. A small tree will grow in your computer's memory to ease the burden of the transaction processing. It is called "Bonsai Tree" and is a part of innovative Solid technology. Bonsai tree serves as a "smart cache", collecting the data that are being processed, have been recently processed, or are likely to be processed. In other words, Bonsai Tree is a highly efficient implementation of a hot spot -- the part of the database that is subject to high activity. All real-life databases have hot spots that are typically a few per cent of the total database size.

You might say: isn't the traditional page buffer pool (database cache) supposed to take care of that, by maintaining the most commonly used pages in main memory?

The answer is yes, it does--but not in the most …

Today’s been interesting. Its labour day here in Melbourne, so I believe a lot of people are enjoying the long weekend. I on the other hand, have been labouring over the long weekend, and we have stuff to show for it. Via the Forge Wiki:

• Google Summer of Code 2007 - we’ve applied, we’ve identified mentors, and we’ve also identified some project ideas. Last week was rather busy sorting all this out. My boss, Kaj explains it a lot better in his post, Global Warming & Google Summer of Code. Students, do apply to come code with us!
  Keep the March 14 - 24, 2007 dates (Cupertino, California time) in your mind students… Thats when the Google SoC opens up. Of course, come March 14 we …

<p>Transaction performance relates among other things from I/O performance. This means hard disk performance.</p>

<p><b>Hard disk performance</b></p>

<p>When you select a hard disk, an important feature to consider is the performance (speed) of the drive. Hard disks come in a wide range of performance capabilities. As is true of many things, one of the best indicators of a drive?s relative performance is its price. An old saying from the automobile-racing industry is appropriate here: "Speed costs money. How fast do you want to go?"</p>

<p>The performance of a hard disk depends on several delays associated with reading or writing data on a computer's disk drive.</p>

<p>A measurement, called average access time (AAT), involves the elements, average seek time (AST), average rotational latency (ARL) and transfer time (TT).</p>

Don't miss this date! March 14th is the last date to get a $200 discount for a MySQL Users Conference registration.

Watch out for the Tutorials, Sessions, Speakers and Events and take the opportunity to Get MySQL Certified during the Conference!

I'm looking forward to meeting you!

What happened with the MySQL Winter of Code? It was hit by Global Warming. Specifically, the Community Team got heated up working on the MySQL Conference & Expo 23-26 April 2007, left with little bandwidth to pursue the ideas and action items for Winter of Code.

When winter warms up, it slowly turns into summer. But the coding work remains. Colin Charles was smart enough to combine these two facts with Sheeri Kritzer’s blog entry and hints about the Australian Winter, and took action related to the Google Summer of Code. Colin spoke to Chris DiBona and Leslie Hawthorn of Google and has now signed us up for Google Summer of Code.

In short: …

Its that time of the year again when time changes and we have to make sure our servers are using the right zone with right time. Out of many servers I admin, I found 3 servers which had wrong time displaying. All of them had one thing in common, Fedora Core 4. So I fixed it by doing the folowing.

mv /etc/localtime /etc/localtime.old

ln -s /usr/share/zoneinfo/PST8PDT /etc/localtime

March 12, 2007 -- The schedule is nearly complete for the 2007 MySQL Conference & Expo, happening April 23-26 at the Santa Clara Convention Center in Santa Clara, California. This year's program promises to be the most exciting ever, offering more than 110 sessions and workshops for every type of user -- from experienced database administrators and programmers to MySQL beginners. Attendees who register by March 14 will save $200 off the standard fee. Other discounts are also available that may be used in conjunction with early registration for additional savings.

So, within MySQL it's not 'allowed' to release or name anything prefixed with 'My' (but MySQL of course). An example is MyODBC doesn't exists anymore, it's Connector/ODBC.

But you see lots of successful MyThis and MyThats.

• 
  
• MySQL.com (duh)
  
• MySpace.com
  
• MyVideo.de
  
• MyWunderwelt.prosieben.de
  

Bah, anyway, there are lots of them of course. What's 'yours' on the net?

In August 2006 I made a post about the MySQL blackhole engine and its possible use for replication scenarios.

Back then the primary focus was to reduce the amount of data being transferred between master and possible many slaves during normal business. This speeds up processing on the slaves, because they have considerably less data to first store to their relay logs and then immediately discard again.

What still takes a lot of time is the initial setup of a slave system. This is because there is a potentially large SQL based dump file to be executed on maybe relatively low-end systems (e. g. Celeron CPUs and single IDE hard drives). While this can be made to work reliably with a set of scripts to automate the process of downloading a zipped SQL file from a local server and running it against the clients' databases, it …

In August 2006 I made a post about the MySQL blackhole engine and its possible use for replication scenarios.

Back then the primary focus was to reduce the amount of data being transferred between master and possible many slaves during normal business. This speeds up processing on the slaves, because they have considerably less data to first store to their relay logs and then immediately discard again.

What still takes a lot of time is the initial setup of a slave system. This is because there is a potentially large SQL based dump file to be executed on maybe relatively low-end systems (e. g. Celeron CPUs and single IDE hard drives). While this can be made to work reliably with a set of scripts to automate the process of downloading a zipped SQL file from a local server and running it against the clients' databases, it …