<< 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
    8 MySQL Technical Reference for Version 4.0.3 The  MySQL Server  design is multi-layered with independent modules.  Some of the newer modules are listed here with an indication of how well-tested each of them is: Replication { Gamma Large server clusters using replication are in production use, with good results. Work on enhanced replication features is continuing in MySQL 4.0. InnoDB  tables { Stable (in 3.23 from 3.23.49) The  InnoDB  transactional  table  handler  has  now  been  declared  stable  in  the MySQL  3.23 tree, starting from version 3.23.49.   InnoDB  is being used in large, heavy-load production systems. BDB  tables { Gamma The Berkeley DB code is very stable, but we are still improving the BDB transac- tional table handler interface in MySQL Server, so it will take some time before this is as well tested as the other table types. FULLTEXT  { Beta Full-text search works but is not yet widely used.  Important enhancements are being implemented for MySQL 4.0. MyODBC 2.50  (uses ODBC SDK 2.5) { Gamma Increasingly  in  wide  use.   Some  issues  brought  up  appear  to  be  application- related and independent of the ODBC driver or underlying database server. Automatic recovery of MyISAM tables { Gamma This status only regards the new code in the MyISAM table handler that checks if the table was closed properly on open and executes an automatic check/repair of the table if it wasn't. Bulk-insert { Alpha New feature in MyISAM tables in MySQL 4.0 for faster insert of many rows. Locking { Gamma This is very system-dependent.  On some systems there are big problems using standard OS locking (fcntl()). In these cases, you should run mysqld with the --skip-external-locking   ag.  Problems are known to occur on some Linux systems, and on SunOS when using NFS-mounted lesystems. MySQL AB  provides high-quality support for paying customers,  but the  MySQL  mailing list usually provides answers to common questions.  Bugs are usually xed right away with a patch; for serious bugs, there is almost always a new release. 1.2.4  How Big Can MySQL Tables Be? MySQL  Version 3.22 has a 4G limit on table size.  With the new  MyISAM  table type in  MySQL Version 3.23, the maximum table size is pushed up to 8 million terabytes (2 ^ 63 bytes). Note, however, that operating systems have their own le-size limits.  Here are some exam- ples: Operating System File-Size Limit
     

    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