Google Summer of Code 2008 officially ended on August 18th. Since that deadline, I have been working to solve a few non-functional problems I discovered during testing stage.

• By week 11, Skoll Client was collecting runtime information for each of the MySQL tests. During the development stage, I only tested this feature with a few MySQL tests. However, during testing stage I discovered this feature would take way too much time and resources for majority of the users. To completely test one configuration of MySQL, it took Skoll Client over 10 hours because MySQL server must be restarted after each test. Also, the runtime information collected was over 3 GB (zipped!). If the user is only interested in the coverage of the MySQL test suite, the per-test runtime information is a major overkill. The solution was to have two runtime information collection flags in the Skoll Client, --gcov and --detailed_gcov, to collect runtime information for …

After running symfony propel-build-all on a new symfony installation got this error. The solution is to install the php-xml rpm (deb).

[root@devel2 cms]# symfony propel-build-all
>> schema converting "/home/sfprojects/cm...lugin/config/schema.yml" to XML
>> schema putting /home/sfprojects/cms/pl...erated-sfGuardPlugin-schema.xml
>> file+ config/generated-sfGuardPlugin-schema.xml
>> file- /home/sfprojects/cms/plugins/sf...erated-sfGuardPlugin-schema.xml
Buildfile: /usr/share/pear/symfony/vendor/propel-generator/build.xml
[resolvepath] Resolved /home/sfprojects/cms/config to /home/sfprojects/cms/config

propel-project-builder > check-project-or-dir-set:

propel-project-builder > check-project-set:

propel-project-builder > set-project-dir:

propel-project-builder > check-buildprops-exists:

…

We’re getting some high quality Use Cases from our user base, related to the MySQL 5.1 Use Case Competition.

The first one is by Greg Haase of Lotame, based in Elkridge, Maryland (USA), a company dedicated to providing solutions within social media. His article is about an innovative use of MySQL 5.1 partitioning and Event Scheduler to prune ARCHIVE tables.

There are more articles in the pipeline. And there is still time for you to submit your story by 30 September 2008. We’re all excited to read them, and with your permission, we’ll share them with …

Say you want to randomly select your employee of the month, but not so randomly, better, you'd like to give your best employees a bigger chance to be selected based on their rating.This is just an example, you could be randomly displaying ads from your customers, but giving an higher chance to be displayed to those who are paying more, there can be a million other example, but I hope you got the

SetFileValidData Function (Windows)

There seems to be two options on Win32 for preallocating disk space to files.

Basically, I want a equivilent to posix_fallocate or the ever wonderful xfsctl XFS_IOC_RESVSP64 call.

The idea being to (quickly) create a large file on disk that is stored efficiently (i.e. isn’t fragmented).

From SQL, you’d do something like “CREATE LOGFILE GROUP lg1 ADD UNDOFILE ‘uf1′ INITIAL_SIZE 1G;” and expect a 1GB file on disk. One way of getting this is calling write() (or WriteFile() on Win32) repeatedly until you’ve written a 1GB file full of zeros. This means you’re generating approximately 1GB of IO.

Except it’s worse than that: every time you extend the file, you’re going to be changing the metadata (file and free space information). If you’re lucky, you won’t be …

Innovation Everywhere! That’s the motto of the MySQL Conference & Expo 20-23 April 2009, in Santa Clara.

If April next year sounds like the distant future to you, then you’re evidently not planning to be a presenter. Since if you do plan to present, there’s a very close date relevant for you: 22 October 2008. That’s when the Call for Papers closes.

If you’re an innocent bystander and don’t plan on presenting, you may still enjoy lurking at the MySQL Conference Website, for instance looking at some of the full-length keynote videos already posted from the 2008 conference.

On the other hand, if you’re …

Still no official news on the rumour that Monty Widenius has left Sun, but Dave Rosenberg confirmed over the weekend that he is leaving MuleSource, the open source ESB vendor he founded in 2006 with Ross Mason, creator of the Mule project.

“After two and a half years I’ve decided to transition out of my operating role at MuleSource and will be devoting my full time efforts to a new company I have been working on,” he wrote on Friday. “I initiated a CEO search in June and we expect to have a new person in place by the end of the year at the latest.

“I started the search because I felt like a more …

Users, in the context of databases, especially open ones, means developers. Do you feel like hacking some database project? If your database of choice is open (MySQL, PostgreSQL, JavaDB, SQLite, Firebird), you may give the OpenSQLCamp a try!

Building MySQL on Windows - MySQL Forge Wiki

This one covers running mysqld in the VisualStudio debugger, which can be useful.

I have no special ndb_mgmd.exe or ndbd.exe in debugger instructions or wisdom (running them from mysql-test-run.pl at least). I’ve attached debugger to already running (started by mysql-test-run.pl) ndb processes, but haven’t made any changes to mtr to make it like the mysqld of “go and enter this”.