Arjen has mentioned prior, Brian Aker will be speaking at Linux.conf.au (Dunedin, NZ) next week, then at the Brisbane, Adelaide and Melbourne MySQL user groups (I'll be there for Brisbane & Dunedin talks).

A *questionable* program means that Arjen will be speaking on 'Concurrency Control in RDBMS' at the same time as Rasmus' 'Building Rich Web applications with PHP 5', and Brian's talk conflicts with Stewart's MySQL Cluster talk.

Oh well, can't win every time.

... as long as they are related to MySQL or database topics.

Unfortunately, there were often comments on my articles that were just spam and they had nothing to do with MySQL or databases at all. I always deleted them manually and one day I decided to only allow comments to people who are logged in.

But I received quite a lot of feedback from people who wanted to post relevant comments, but they didn't have an account and so couldn't answer. Now I have changed the setting back to its original state, because I'm quite curious about what people think about what I write and so, they should have a chance to tell me and the blog's readers :-).

I have just discovered that the MySQL 5.0 Beta Certification Exams are available. The Developer Exams are available now, the Administrator Exams are scheduled to be available by the end of January.

The way to get MySQL 5.0 certified has changed a bit compared to the 4.x exams. There are 2 exams for each the Developer and Administrator Certifications. Only if one passes both exams, somebody can title himself either a CMDEV (Certified MySQL Developer) or CMDBA (Certified MySQL Database Administrator). There are no more prerequisites, so the exams can be taken in any order (which was not the case with the 4.x exams where the Core exam was a prerequisite for the Professional exam).

There are also upgrade exams for people who have already passed the 4.x exams. One exam is necessary to upgrade from 4.x Core to 5.0 CMDEV and one exam from 4.x Professional to 5.0 CMADM. Unfortunately, there is no more detailed information about …

In the process of cleaning up unused db4free.net database accounts, the first databases with their users have now been deleted.

During the last month I've sent out emails to all users asking them whether they would like to keep their account. Today I have deleted 966 database accounts, where people have either decided not to use it anymore, or where no data has been stored and the database hasn't been accessed within the last month.

Other 817 accounts, where the users didn't give me a decision, have been set inactive - they can still login but don't have access to their (still existing) database anymore. So there is still a final chance to get access again, if the database is really needed. Until the end of January I will also delete those accounts, where the user didn't ask for re-creation.

Before, there were 3,206 accounts from which 966 have been …

The Boston MySQL Meetup Group was successful yet again! I was a bit worried about my presentation, that it would be too basic or folks would have wanted to see actual code and scripts, but it turned out well.

You may notice that the links at the side (http://www.sheeri.com if you’re reading a feed) include a category called “Presentations”. Currently the December presentation is linked to, direct to Google Video, and the slides from tonight’s meeting are also up in PDF format as well as macromedia flash. And, of course, tonight’s video, thanx to Mike Kruckenberg. Mike also took pictures!

Folks who were at the presentation — feel free to let me know what you thought of it. Folks not at the presentation — feel free to watch the video and let me know what you think. I’m especially interested for those folks …

VMWare recently released a freeware called VMWare Player that can play a pre-built virtual machine file. A virtual machine is an OS bundled with whatever the virtual machine creator put there. This is perfect for people to test-drive various operating systems and software, without going through the hassle of installing themselves. VMWare currently provides virtual machines preloaded with RedHat, Novell Suse, ubuntu, Oracle, MySql, and Bea, among others.

Memory used to be a bottleneck for virtualization software to take off. However, on the hardware side of things, both Intel and AMD are pushing 64-bit processors pretty aggressively now. With 64-bit architecture, the memory space the operating system can access increases exponentially (from 2^32 to 2^64). With the push towards 64-bit and the emergence of virtualization technology, I wonder what kind of impact this will have …

Ben Forta sent me a copy of his latest book: MySQL Crash Course a book based on his: Teach yourself SQL in 10 minutes book.

MySQL Crash Course is a concise guide (it's actually about the size of a novel, but 300 pages) to MySQL. I am a big fan of short and to the point books. Good job keeping it short Ben, I know you have written some hefty ones. ;)

The book doesn't focus on the system administration of MySQL, but rather the programming side of things - SQL.

I think this book would be great for someone who doesn't do a …

Backups of your database data and database maintenance are essential things that everybody should do who runs database servers in production.

I used to do this with a little batch that looks like this:

mysqldump --add-drop-table --default-character-set=utf8 
  --databases mysql -h localhost -u [my root user] -p 
  > "E:\mysql_dump\dump_mysql.sql"


mysqldump --add-drop-table --default-character-set=utf8 
  --all-databases -h localhost -u [my working user] -p 
  > "E:\mysql_dump\dump.sql"


mysqlcheck -u [my root user] -p --all-databases --analyze --optimize

This little batch creates two dump files - one with the mysql database which stores all the privilege data and a second dump file with the rest of the data (my working user has privileges for all databases except mysql). Finally, the mysqlcheck command optimizes my MyISAM tables and renews the index information of …

First I'd like to say - I absolutely like the way that MySQL QueryBrowser is supposed to work! All the windows can very easily be arranged so that everything's in sight (one one screen) that's necessary to write complex queries - I can e.g. show the results of a query in one screen, open the field lists of the tables that I need, so this way, everything's available that I need to write big queries (including complex joins) without the need to switch between different screens. I haven't found another programm (neither for MySQL, nor for PostgreSQL) that makes the work of query writing more comfortable!

However, since version 1.1.15, evil bugs have found their way into QueryBrowser. For some time, it wasn't possible to drag and drop a table name into the result area to immeditely show the contents of a table. In one version, it wasn't possible to open the window to write a Stored Procedure or User Defined Function. And in another version …

MySQL has announced two very useful new features for versions 5.1.5 and 5.1.6.

5.1.5 will get new XML capabilities and 5.1.6 will be able to schedule event tasks. That will be very helpful to clean up outdated data, for example - a task that had to be done on the client side so far, but now it can be delegated to the database server.

I still wonder if MySQL 5.1 will introduce check constraints, as this is still another thing that still has to be done on the client side, although it would be useful to transfer this to the database server.

Another thing that should abolutely be in 5.1 are separate privileges for trigger creation and deletion.

If these both features, together with the …