This is part two of the article “Database management with phpMyAdmin” a review of the book “Mastering phpMyAdmin” and the open source software phpMyAdmin.
The PMA relational system
In MySQL there is no native function to create relations between several database tables. Using the InnoDB database type makes it possible to link with foreign keys and in […]

Thanks to some work started by Ville Skyttä, MySQLTuner is now included in Fedora 9 repositories:
# cat /etc/fedora-release
Fedora release 9 (Sulphur)
# yum info mysqltuner
Loaded plugins: fastestmirror, priorities, refresh-packagekit
Loading mirror speeds from cached hostfile
* updates: mirrors.usc.edu
* fedora: mirror.unl.edu
* livna: mirrors.tummy.com
Available Packages
Name : mysqltuner
Arch […]

Matt Asay writes today about the prospects for open source vendors going public or, more likely, being acquired, and wonders whether open source vendors should “hold out for an IPO” or “capitulate” and be acquired.
The latter seems far more likely, especially in the current economic climate. We have written before about the open source vendors […]

After two years with the same host, I realised that I wasn’t satisfied with their service. I’d often get spike lags, down times for no reason which was frustrating. But you can’t expect an overselling web hosting to provide a service of high quality. Everything come down to a price.
I believe that by buying my […]

I’m still looking for new entries. I get quite a few suggestions, but not all of them make it into quiz questions. Do send in your suggestions!
This wonderful quiz from Vladimir Kolesnikov is one of those that should make you stop and think for a moment…
Given this table and data:
mysql> SELECT * FROM t;
+——+——+
| i1 […]