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)

1 comment:

  1. #2 is actually partially implemented in MySQL 5.1.6 and higher. Indexes are still in memory but non-indexed data can be stored on disk.

    http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data.html

    ReplyDelete