Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Thanks all for the help on getting my log_addpartition event
running, dynamic SQL was just the ticket.
I'm now focusing on writing the sister event:
'log_removepartition', which will find and purge partitions older
than some time interval. The information schema comes in quite
handy here, as I can query the PARTITIONS table to see all
partitions.
Last time, I introduced the notion of strict and lenient updates. Now it’s time to see what the performance characteristics are of each.
Just to rehash, we are focusing on the storage engine (a la MySQL) level, and we are looking at a database on a single disk—the one we are using for illustration is the 1TB Hitachi Deskstar 7K1000. It has a disk seek time 14ms and transfer rate of around 69MB/s [See tomshardware.com] We will insert and delete random pairs, each 8 bytes. So that’s 62.5 billion pairs to fill the disk.
Strict Updates
These are the easier update types to analyze. Please review the definition of strict updates from the last blog entry. Now notice that each insertion or deletion requires a point query. For example, during an insertion, in order to determine if there’s already a row with a particular key value in the database, one must look up that key. In order …
[Read more]
I’m following what ezComponents doing for sometime now.
Quite nice framework for whatever you need.
I gave a try to write a mysql schema sync.
Real easy to write. only 4-5 lines of code to sync schemas.
It would have been great if it was actually working. The outout
sql ddl is not runnable in some cases (syntax errors). Or the
order of the columns are different.
I’m sure they’ll fix it soon but this tells me they are not yet
ready for production quality.
See the code below, maybe I’m doing something wrong.
<?php
require_once "ezcomponents/Base/src/base.php";
function __autoload( $className ){
ezcBase::autoload( $className );
}
$sourcedb['host']= isset($_POST['sourcedb']['host'])?
$_POST['sourcedb']['host']:”;
$sourcedb['port']= …
mysqlcompiler
We recently integrated MySQL 5.0.45 version with Open Solaris.
MySQL 5.0.45 is available in SXDE 01/08. Sun Studio was used to
compile MySQL on both Solaris SPARC and Solaris AMD64
platform.
This blog entry describes the changes that were made to improve
MySQL performance using Sun Studio:
mysqlcompiler
We recently integrated MySQL 5.0.45 version with Open Solaris.
MySQL 5.0.45 is available in SXDE 01/08. Sun Studio was used to
compile MySQL on both Solaris SPARC and Solaris AMD64
platform.
This blog entry describes the changes that were made to improve
MySQL performance using Sun Studio:
There are currently three derivates of MySQL Cluster 5.1:
In this post I will explain what features exists where, what they
do and what they mean and how they can be used. Why 5.1
The way to read it is as follows: Whatever is included in MySQL
Cluster 5.1, is also in MC 6.2 and 6.3. Whatever is in 6.2 is
also in 6.3.
What version you should use depends on what features you need,
but MC6.2 is more mature than 6.3 at the point of writing and is
used in production in a number of places of some of the largest
telco's in the world. MC 6.3 is a version that many of our
customers are developing and testing on right now.
Moreover, the MC versions are currently only available in source
distributions. Next post I will explain how to build it on the
Linux platform.
…
SuperDBA and SOA guru Robert Schneider over at PushToTest is putting on a 3-day test automation bootcamp in Silicon Valley Feb 26-28. It's a hands-on session with laptop required.
The role of testing and testing tools has evolved in recent years from simple record / playback tools (e.g. GUI monkey tools) to more sophisticated approaches that leverage a web services model with dynamic data. New technologies like soapUI, Selenium, and PushToTest, have been designed for Web app, Web services and Ajax testing. Pulling these tools and platforms together into something that the average database developer or tester can use can requires quite a bit of effort …
[Read more]
MySQL 5.0.45 is integrated with Open Solaris build 79. It is
available in Solaris Express Developer Edition (SXDE) 01/08.
MySQL 5.0.45 is integrated with Solaris Service Management
Facility (SMF).
This blog entry describes the steps that were taken to integrate
MySQL with SMF.
First a quick recap of what is SMF:
SMF is the core component of the predictive self-healing
technology available in Solaris 10, which provides automatic
recovery from software and hardware failures as well as
adminstrative errors.
Some of the advantages of using SMF are as under:
Failed services are automatically restarted in dependency order, whether they failed as the result of administrator error, software bug, or were affected by an uncorrectable hardware error.
More information is available about misconfigured or misbehaving …
MySQL 5.0.45 is integrated with Open Solaris build 79. It is
available in Solaris Express Developer Edition (SXDE) 01/08.
MySQL 5.0.45 is integrated with Solaris Service Management
Facility (SMF).
This blog entry describes the steps that were taken to integrate
MySQL with SMF.
First a quick recap of what is SMF:
SMF is the core component of the predictive self-healing
technology available in Solaris 10, which provides automatic
recovery from software and hardware failures as well as
adminstrative errors.
Some of the advantages of using SMF are as under:
Failed services are automatically restarted in dependency order, whether they failed as the result of administrator error, software bug, or were affected by an uncorrectable hardware error.
More information is available about misconfigured or misbehaving …
As part of planning our integration into Sun, we surveyed all MySQLers on their opinions regarding Sun, their concerns and ideas. Amongst concerns, “retaining the MySQL Culture” ranked second.
MySQL Staff Meeting in Budapest 2003; time off in the Gellért Baths
But what exactly is “The MySQL Culture”? That’s never been written down, and defining culture is usually a matter for anthropologists, not Open Source companies.
So we decided to ask. Instead of engaging field anthropologists, we just added a question to the survey. And did we get answers! This is what the foremost experts, i.e. our employees, think constitutes MySQL Culture:
