1.9.5 New Features Planned For The Mid-Term Future

• Implement function: get_changed_tables(timeout,table1,table2,...).
• Change reading through tables to use memmap when possible. Now only compressed tables use memmap.
• Make the automatic timestamp code nicer. Add timestamps to the update log with SET TIMESTAMP=#;.
• Use read/write mutex in some places to get more speed.
• Simple views (stepwise implementation up to full functionality). See section 1.8.4.6 Views.
• Automatically close some tables if a table, temporary table, or temporary files gets error 23 (not enough open files).
• When one finds a field=#, change all occurrences of field to #. Now this is only done for some simple cases.
• Change all const expressions with calculated expressions if possible.
• Optimise key = expression. At the moment only key = field or key = constant are optimised.
• Join some of the copy functions for nicer code.
• Change `sql_yacc.yy' to an inline parser to reduce its size and get better error messages (5 days).
• Change the parser to use only one rule per different number of arguments in function.
• Use of full calculation names in the order part (for ACCESS97).
• MINUS, INTERSECT, and FULL OUTER JOIN. (Currently UNION [in 4.0] and LEFT|RIGHT OUTER JOIN are supported.)
• SQL_OPTION MAX_SELECT_TIME=# to put a time limit on a query.
• Make the update log write to a database.
• Enhance LIMIT to allow retrieval of data from the end of a result set.
• Alarm around client connect/read/write functions.
• Please note the changes to mysqld_safe: according to FSSTND (which Debian tries to follow) PID files should go into `/var/run/<progname>.pid' and log files into `/var/log'. It would be nice if you could put the "DATADIR" in the first declaration of "pidfile" and "log", so the placement of these files can be changed with a single statement.
• Allow a client to request logging.
• Add use of zlib() for gzip-ed files to LOAD DATA INFILE.
• Fix sorting and grouping of BLOB columns (partly solved now).
• Change to use semaphores when counting threads. One should first implement a semaphore library to MIT-pthreads.
• Don't assign a new AUTO_INCREMENT value when one sets a column to 0. Use NULL instead.
• Add full support for JOIN with parentheses.
• As an alternative for one thread/connection manage a pool of threads to handle the queries.
• Allow one to get more than one lock with GET_LOCK. When doing this, one must also handle the possible deadlocks this change will introduce.

Time is given according to amount of work, not real time.

User Comments

Add your own comment.