Tuesday, July 31, 2007

MySQL features I would kill for.

It seems that nowadays there is a trend in writing "top 10 features I want software X to have". I have seen at least two such posts about
MySQL, here and here. So, since I have been working with MySQL for a while, here is my list:

  1. File per table backup mode for mysqldump that would work with --single-transaction flag

  2. Clustering without the NDB in memory storage

  3. Ability to turn logs (query, binary, slow queries) on and off without restarting

  4. Ability to setup log filters (such as log queries using particular table into a separate file or log queries scanning more then 10K rows)

  5. Ability to use bound variables in prepared statements properly (such as use variables in LIMIT or pass table names in the variables)

  6. Proper implementation of views (proper, as in not involving running a select every time a view is queried)

Success of Ubuntu

I think that the existence of this blog post is a clear indication that Linux is succeeding on the Desktop :)