A customer recently asked what the pros and cons are of using the innodb_file_per_table. It's a good question - since the right answer will depend a lot on your data. I'm a fan of the file per table option, it's particularly helpful when you delete a lot of data and want to reclaim the space. So here is the list I came up with:

The pros:
* Normally the InnoDB tablespace never shrinks, but when using file per table you can run run an OPTIMIZE to compact/recreate it (this is a big win).
* You can symlink out individual tables[1] to be on different disk subsystems (can give some improvement, but the global tablespace is still shared).

The cons:
* You can't spread an individual table across several disks (without file per table, it's quite easy to create many segments of a few GB each and move them …

March 2008 will be a month of publicity for CouchDB. I will be giving a total of three presentations around the globe, the northern hemisphere, less then half of that, actually. Anyway.

March 1st, 2008 — Chemnitzer Linux Tage

As early as 9:00 a.m. on a Saturday morning, I’ll be giving the 45 minute version of my Next Generation Data Storage with CouchDB talk to a crowd of hopefully awake Linux enthusiasts. The conference is only 5€ (3€ for students), so be sure to show up! The presentation will be in German and so is the information page.

March 7th, 2008 — O’Reilly ETech — San Diego

This is a big one, and actually, they help sponsoring my flight to the US, so a big thanks upfront! In fact, this is a double session …

March 2008 will be a month of publicity for CouchDB. I will be giving a total of three presentations around the globe, the northern hemisphere, less then half of that, actually. Anyway.

March 1st, 2008 — Chemnitzer Linux Tage

As early as 9:00 a.m. on a Saturday morning, I’ll be giving the 45 minute version of my Next Generation Data Storage with CouchDB talk to a crowd of hopefully awake Linux enthusiasts. The conference is only 5€ (3€ for students), so be sure to show up! The presentation will be in German and so is the information page.

March 7th, 2008 — O’Reilly ETech — San Diego

This is a big one, and actually, they help sponsoring my flight to the US, so a big thanks upfront! In fact, this is a double session …

In a linkage of biblical proportions, Log Buffer #83 pointed me to Tom Kyte’s reiteration which pointed me to Coding Horror’s rant about source controlling the database schema. Now, for starters, I agree with Tom’s sarcasm and Coding Horror’s rant — the database schema really should be source controlled in the same place as the application [...]

March 2008 will be a month of publicity for CouchDB. I will be giving a total of three presentations around the globe, the northern hemisphere, less then half of that, actually. Anyway.

March 1st, 2008 — Chemnitzer Linux Tage

As early as 9:00 a.m. on a Saturday morning, I’ll be giving the 45 minute version of my Next Generation Data Storage with CouchDB talk to a crowd of hopefully awake Linux enthusiasts. The conference is only 5€ (3€ for students), so be sure to show up! The presentation will be in German and so is the information page.

March 7th, 2008 — O’Reilly ETech — San Diego

This is a big one, and actually, they help sponsoring my flight to the US, so a big thanks upfront! In fact, this is a double session …

Probably most of MySQL users sometime had a situation when they would do changes in MySQL config file without restarting server (may be matching SET GLOBAL command to do it in run time) but either because option is misspelled or because given version does not support such option the server when would refuse to start when it restarted, either on operating system restart or recovering from MySQL Server crash. In any case it is quite nasty.

Unlike Apache MySQL service control script does not have "configtest" option so there is no straight way to check MySQL config file for errors. However you can do it by running mysqld --help option:

PLAIN TEXT CODE:

1. [root@sl1 tmp]# /usr/libexec/mysqld --help
2. 080212 12:39:30 [ERROR] /usr/libexec/mysqld: unknown variable 'myis_test=1'

This does not do complete check, ie it is possible to allocate 80GB to buffer pool …

In all versions we updated Apache to 2.2.8, PHP4 to 4.4.8 and phpMyAdmin to 2.11.4. The Linux and Mac OS X versions contain also updated Perl (5.10.0) and MySQL (5.0.51a) releases.

Get the downloads and more details on the specific platforms XAMPP project page.

A

I did some more benchmarking on XFS over the weekend. I ran at least 3 independent tests, which were all within 5-10% of the below results.

MySQL AB today announced that UK-based WYSdom Dental Technologies has embedded the MYSQL database into its flagship practice management product, ICONic. The ICONic system provides a one-stop-shop solution to address the complex requirements that dental practitioners face with regards to client and back-end administration systems, as well as external communication with the Dental Practice Board.