<< 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 5 1.2.1  History of MySQL We once started out with the intention of using  mSQL  to connect to our tables using our own fast low-level (ISAM) routines.  However, after some testing we came to the conclusion that mSQL was not fast enough nor exible enough for our needs.  This resulted in a new SQL interface to our database but with almost the same API interface as mSQL.  This API was chosen to ease porting of third-party code. The derivation of the name  MySQL  is not perfectly clear.  Our base directory and a large number of our libraries and tools have had the pre x \my" for well over 10 years.  However, Monty's daughter (some years younger) is also named My.  Which of the two gave its name to MySQL is still a mystery, even for us. 1.2.2  The Main Features of MySQL The following list describes some of the important characteristics of the  MySQL Database Software.  See Section 1.5 [MySQL 4.0 In A Nutshell], page 20. Internals and Portability    Written in C and C++.  Tested with a broad range of di erent compilers.    Works on many di erent platforms.  See Section 2.2.2 [Which OS], page 69.    Uses GNU Automake (1.4), Autoconf (Version 2.52 or newer), and Libtool for portability.    APIs for C, C++, Ei el, Java, Perl, PHP, Python, and Tcl.  See Chapter 8 [Clients], page 539.    Fully  multi-threaded  using  kernel  threads.   This  means  it  can  easily  use multiple CPUs if available.    Very fast B-tree disk tables with index compression.    A very fast thread-based memory allocation system.    Very fast joins using an optimised one-sweep multi-join.    In-memory hash tables which are used as temporary tables.    SQL functions are implemented through a highly optimised class library and should be as fast as possible! Usually there isn't any memory allocation at all after query initialisation.    The MySQL code gets tested with Purify (a commercial memory leakage de- tector) as well as with Valgrind, a GPL tool (http://developer.kde. Column Types    Many  column  types:   signed/unsigned  integers  1,  2,  3,  4,  and  8  bytes long,  FLOAT,  DOUBLE,  CHAR,  VARCHAR,  TEXT,  BLOB,  DATE,  TIME,  DATETIME, TIMESTAMP,  YEAR,  SET, and  ENUM  types.  See  Section 6.2 [Column types], page 387.    Fixed-length and variable-length records.
     

    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