MySQL, here and here. So, since I have been working with MySQL for a while, here is my list:
- File per table backup mode for mysqldump that would work with --single-transaction flag
- Clustering without the NDB in memory storage
- Ability to turn logs (query, binary, slow queries) on and off without restarting
- Ability to setup log filters (such as log queries using particular table into a separate file or log queries scanning more then 10K rows)
- Ability to use bound variables in prepared statements properly (such as use variables in LIMIT or pass table names in the variables)
- Proper implementation of views (proper, as in not involving running a select every time a view is queried)
#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.
ReplyDeletehttp://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data.html