<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • 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
    Chapter 1:  General Information 45    Add record_in_range() method to MERGE tables to be able to choose the right index when there are many to choose from.  We should also extend the info interface to get the key distribution for each index, if analyze is run on all subtables.    Resolving the issue of RENAME TABLE on a table used in an active MERGE table possibly corrupting the table.    A faster, smaller embedded MySQL library (compatible with the old one).    Stable OpenSSL support (MySQL 4.0 supports rudimentary, not 100% tested, support for OpenSSL).    Add support for sorting on UNICODE.    Character set casts and syntax for handling multiple character sets.    Help for all commands from the client.    New faster client/server protocol which will support prepared statements, bound pa- rameters, and bound result columns, binary transfer of data, warnings...    Add database and real table name (in case of alias) to the MYSQL FIELD structure.    Add options to the client/server protocol to get progress notes for long running com- mands.    Implement  RENAME DATABASE.  To make this safe for all table handlers, it should work as follows:    Create the new database.    For every table do a rename of the table to another database, as we do with the RENAME  command.    Drop the old database.    Add true VARCHAR support (there is already support for this in MyISAM).    Optimise BIT type to take 1 bit (now BIT takes 1 char).    New internal le interface change.  This will make all le handling much more general and make it easier to add extensions like RAID. (the current implementation is a hack.)    Better in-memory (HEAP) tables:    Support for B-tree indexes    Dynamic size rows    Faster row handling (less copying) 1.8.3  Things That Must be Done in the Near Future    Atomic multi-table updates: UPDATE items,month SET items.price=month.price WHERE items.id=month.id;    Don't  allow  more  than  a  de ned  number  of  threads  to  run  MyISAM  recover  at  the same time.    Change INSERT ... SELECT to optionally use concurrent inserts.    Return the original eld types() when doing SELECT MIN(column) ... GROUP BY.
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    Home
    Hosting Plans | Domain Registration | About Us | Contact Us | Site Map
    Terms of Use | Privacy Policy | Guarantees
    Merchant Accounts

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

    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

  • 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