After some stagnation, the test creator is on the move. Currently it can record the client's input and the server's response to write the .test file and the .result file. The implementation of some major test keywords are on the way as well.

The site for the project is http://code.google.com/p/mysql-test-creator

The milestones:
-July 23: testing keywords and a basic test
-July 30: test to prove test works
-August 6: handle multiple connections
-August 13: multiple connections / complete the macro module
-August 20: full test suite w/ documentation
-August 27: fix bugs, test with different versions of MySQL

They did it

The order had been delayed. Shipping should now happen somewhere in September. Two more months?! Amazon had to be kidding. I want that book and I want it now. Or tomorrow. Or before the weekend — BUT NOT IN SEPTEMBER.

This was last Wednesday and my shouting must have been heard. I got a mail later that day telling me my order had been shipped. Nice. It arrived on Thursday afternoon, good job Amazon.

The book is a full 209 pages including index and glossary and I love the index: It has soaking and NIH and freakouts and Spiderman. Rands has quite a vocabulary, a vocabulary that is perfectly suited for a …

All content on these blogs are copyright (c) M. Zack Urlocker 2005-2007.  All rights reserved. Material may not be reproduced without explicit permission from the author. 

I’m at Ubuntu Live today in Portland, Oregon, with my colleague Jay Lyman. Jay and I both live in Portland, making this the shortest conference trip of the year, traffic permitting. The conference takes place just prior to OSCON in the same venue, produced by O’Reilly Media.

MySQL AB CEO Mårten Mickos just finished a keynote this morning. During the Q&A portion following his talk, an audience member inquired about MySQL’s potential adoption of the GPLv3. The answer? “I think it very well might happen,” said Mickos. He went on to discuss the successes of the GPLv2 and the point that even if it takes three to five years for MySQL to embrace the GPLv3, a waiting period isn’t a big deal. Mickos sees no benefit in rushing the process to adopt the new license as the MySQL project is successful today …

Since we released our first Beta, we have been working on various examples to demonstrate the capabilities and benefits of a resource oriented approach to data integration.

One of the examples we have been working on is a data mart for SugarCRM opportunity analysis. We have now published that example on our content download site, packages.snaplogic.org , where you can download it, and try it out. (You will also need a SnapLogic server installation, to run the pipelines.)

The general idea behind data marts is simple – they are subject specific alternatives to a full blown data warehouse. The primary benefits of using a separate database to analyze an operational system are the ability to look at a snapshot of the constantly changing data, and the offloading of the queries to a separate database which is optimized for analysis using a star schema instead of a normalized …

It was very scary seeing a jet-ski headed full-speed straight for a moored boat, but Monty's quick thinking and reactions saved the day (last minute full reverse) and the outcome was good.




Also, in addition to quick reflexes, you need to know that Monty is a very persistent fellow.

The following is proof.

If at first you don't succeed with the Russian-made water bug




Persistence will reward you!

Is mysqlnd stable, is mysqlnd ready for wider consumption? Judging from the latest set of tests: yes!

During the development of mysqlnd, the MySQL native driver for PHP - an alternative to libmysql, a good number of new tests have been written. Let’s see how ext/mysql and ext/mysqli perform when running the test suite. Please note that this is a snapshot and figures might be slightly different when you repeat the test runs: mysqlnd is under constant development and your setup is likely to differ from mine.

Is mysqlnd stable, is mysqlnd ready for wider consumption? Judging from the latest set of tests: yes!

During the development of mysqlnd, the MySQL native driver for PHP - an alternative to libmysql, a good number of new tests have been written. Let’s see how ext/mysql and ext/mysqli perform when running the test suite. Please note that this is a snapshot and figures might be slightly different when you repeat the test runs: mysqlnd is under constant development and your setup is likely to differ from mine.

I have run in to the issue where I wanted to change some configuration on our production MySQL server but did not want to restart MySQL since its in production.  One of the parameters we like to change time to time is the “log_slow_queries” so we can see what queries are slow in production environment.  [...] …

So, I had written a while back: “We currently have a DataMemory of 4GB and IndexMemory of 2GB. Based on the crude methods we have to monitor it, I think we are at about 40% capacity.” Boy, I was wrong.

After that post, I started looking at this more in detail because we were considering buying more RAM “just in case”. I figured out how to use the super secret command “all dump 1000″. The command is not documented in the MySQL documentation that I could find. I did find it in the NDB API documentation before writing this post however. Not sure why I could not find it before.

For those that still don’t know how to use it, simply type “all dump 1000″ from your management console. Then check your cluster log files …