The InnoDB plugin for MySQL 5.1 was announced recently and listed fast index creation and data compression among its features. It should be interesting to compare the latest InnoDB storage engine against the latest PBXT storage engine. Hopefully both will be packaged with the Debian MySQL 5.1 package.

There are a number of things to look forward to in MySQL 5.1 such as the support for data partitioning, new replication methods, and logging to the database. One feature that shows promise is a plugin API to extend the database. This is only as good as the plugins developed and their ease of integration. That’s why I was pleased to see that the Debian MySQL 5.1 package will contain the plugins for PBXT and SphinxSE which are both excellent storage engine projects.

I was working on a server running MySQL and found that the debian-sys-maint account not longer existed which caused errors when upgrading the mysql packages. It was relatively simple to fix by getting the password from the /etc/mysql/debian.cnf file and running the following command:

• GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'password';

In this case the word password is replaced by the value in the /etc/mysql/debian.cnf file.

Wanted to fix the site search today and found the problem was database permissions. To fix I just granted the necessary permissions. Of course, I could only do that because I have access to the root MySQL account. Other Drupal sites on shared web hosting accounts might have to come up with other solutions. I’ve listed a few of these below.