Dyntex.net Support Centre: MySQL Reference Manual p.46

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

46 MySQL Technical Reference for Version 4.0.3 Multiple result sets. Make it possible to specify long_query_time with a granularity in microseconds. Link the myisampack code into the server. Port of the MySQL code to QNX. Port of the MySQL code to BeOS. Port of the MySQL clients to LynxOS. Add a temporary key buer cache during INSERT/DELETE/UPDATE so that we can grace- fully recover if the index le gets full. If you perform an ALTER TABLE on a table that is symlinked to another disk, create temporary tables on this disk. Implement a DATE/DATETIME type that handles time zone information properly so that dealing with dates in dierent time zones is easier. FreeBSD and MIT-pthreads; do sleeping threads take CPU time? Check if locked threads take any CPU time. Fix congure so that one can compile all libraries (like MyISAM) without threads. Add an option to periodically ush key pages for tables with delayed keys if they haven't been used in a while. Allow join on key parts (optimisation issue). INSERT SQL_CONCURRENT and mysqld --concurrent-insert to do a concurrent insert at the end of the le if the le is read-locked. Server-side cursors. Check if lockd works with modern Linux kernels; if not, we have to x lockd! To test this, start mysqld with --enable-locking and run the dierent fork* test suits. They shouldn't give any errors if lockd works. Allow SQL variables in LIMIT, like in LIMIT @a,@b. Allow update of variables in UPDATE statements. For example: UPDATE TABLE foo SET @a=a+b,a=@a, b=@a+c. Change when user variables are updated so that one can use them with GROUP BY, as in the following example: SELECT id, @a:=COUNT(*), SUM(sum_col)/@a FROM table_ name GROUP BY id. Don't add automatic DEFAULT values to columns. Give an error when using an INSERT that doesn't contain a column that doesn't have a DEFAULT. Fix `libmysql.c' to allow two mysql_query() commands in a row without reading results or give a nice error message when one does this. Check why MIT-pthreads ctime() doesn't work on some FreeBSD systems. Add an IMAGE option to LOAD DATA INFILE to not update TIMESTAMP and AUTO_ INCREMENT elds. Added LOAD DATE INFILE ... UPDATE syntax. For tables with primary keys, if the data contains the primary key, entries match- ing that primary key are updated from the remainder of the columns. However, columns missing from the incoming data feed are not touched.

MySQL Reference Manual

Our Partners

SpiritHost - web hosting for spiritual and education sites
SpiritHit.com - Religious and Spiritual Portal

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide