|
|
Jeremy Zawodny of Craiglist has written a kind article about MySQL Sandbox. The article, MySQL Sandbox: Treat MySQL Instances like Virtual Machines, is a practical test of MySQL Sandbox with usage examples and warm appreciation. Thanks, Jeremy! |
The article was published in July but I noticed it only today. I
guess I should pay more attention to my favorite topics when I
travel.
Recently Mark observed that we now all need a storage
engine independent test suite, Sun included! Well, as far as I
know, there is such a thing at Sun, sort of. Apparently it has
been used to test PBXT and other engines, but I've heard it is
not in good enough shape to be released.
But my question is, why not release it anyway? We could turn it
into an engine community project. I believe there are enough
engine developers out there to get this moving forward.
The secret is to start small, and just get a few tests to run
with all engines. Then additional tests can be added step by
step. Engines need a way to specify that they want to skip a test
entirely (e.g. transactional tests), and it should be easy to
customize results for various engines.
An example of a simple and elegant solution can be found in
Drizzle. As …
|
MySQL opens its labs to the community. Users who want to test the early builds, before they are released for general availability can get them from MySQL Labs. |
There is a detailed announcement that warns against using these binaries in production, but encourages everyone to test them. A companion tutorial explains how to use the snapshots to test the InnoDB plugin, which was released recently, and it is included in the latest MySQL …
[Read more]|
Users familiar with the MySQL development process will remember that our developers use a tool called pushbuild, which builds the server code with the latest changes, using several operating systems, and runs the test suite. |
This tool produces one binary package for each platform where the test runs, and every day there are a few dozen of such packages, waiting to be deleted and replaced by the ones created with the next build.
For long time, several people suggested publishing these binaries for the community. Each time, there was some minor or major impediment, such as getting together different teams and requesting resources from a third one. But the community …
[Read more]|
|
The cat is out of the bag. MySQL 5.1 will include the InnoDB plugin, and thanks to labs.mysql.com you can try the new version right away. Here is a step-by-step guide to testing the InnoDB plugin with MySQL snapshot 5.1.39 and MySQL Sandbox. |
|
Users familiar with the MySQL development process will remember that our developers use a tool called pushbuild, which builds the server code with the latest changes, using several operating systems, and runs the test suite. |
This tool produces one binary package for each platform where the test runs, and every day there are a few dozen of such packages, waiting to be deleted and replaced by the ones created with the next build.
For long time, several people suggested publishing these binaries for the community. Each time, there was some minor or major impediment, such as getting together different teams and requesting resources from a third one. But the community …
[Read more]|
Users familiar with the MySQL development process will remember that our developers use a tool called pushbuild, which builds the server code with the latest changes, using several operating systems, and runs the test suite. |
This tool produces one binary package for each platform where the test runs, and every day there are a few dozen of such packages, waiting to be deleted and replaced by the ones created with the next build.
For long time, several people suggested publishing these binaries for the community. Each time, there was some minor or major impediment, such as getting together different teams and requesting resources from a third one. But the community …
[Read more]In my last post I included some sample data which was useful for playing around with queries (once I published it, I realized it made my post look like some form of keyword stuffing, fortunately I don’t use adsense on my site so I hope I’m free of any suspicion :D). That sample data was … Continue reading Generating data with dbmonster →
Related posts:
I'm pleased to announce the release of SQL Bench, the benchmark
test suite the comes standard with MySQL, now as a separate
project targeted for testing any database. I have pulled it out
as a separate project so I can modify and improve it faster. With
this release, I have successfully used it for testing both
Drizzle and MySQL. Other RDBMSs, I have yet to test.
Modifications
I modified the connection test, which part of it is to connect,
run a single query for one row, disconnect, to iterate only
20,000 times vs. 100,000 times. The reason for this is to allow
this test to reasonably test databases that use TCP sockets. When
I added Drizzle support to SQL Bench, upon running the connect
test it would fail inexplicably. After some serious testing, it
was realized that since Drizzle uses TCP sockets, even when
connecting to localhost, that the connect test would fail because
of the result of sockets being kept around in …
A long standing bugAmong the many outstanding bugs for MySQL,
there is one that has sparked a fierce discussion, not only in
the bug report itself, but also in blogs, forums, mailing
lists.
Bug #19027: MySQL 5.0 starts even with Fatal InnoDB
errors was neglected for long time, until finally it got
fixed, and it is available in MySQL 5.1.36.
First off, what is it about?
In short, if an engine doesn't initialize correctly, the MySQL
server starts anyway, without the offending engine. Depending on
how you use the failing engine, this could be either a minor
annoyance or a complete disaster.
Annoyance: ARCHIVE fails to initialize, and you create
tables with the default engine (usually MyISAM), and after a
while you realize that the disk is filling up faster than you
expected. You will find out eventually.
Disaster: ARCHIVE fails to …