<< 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
    336 MySQL Technical Reference for Version 4.0.3 We haven't had any problems handling this with quite modest Sun Ultra SPARCstation (2x200 Mhz).  We recently upgraded one of our servers to a 2 CPU 400 Mhz UltraSPARC, and we are now planning to start handling transactions on the product level, which would mean a ten-fold increase of data.  We think we can keep up with this by just adding more disk to our systems. We are also experimenting with Intel-Linux to be able to get more CPU power cheaper. Now that we have the binary portable database format (new in Version 3.23), we will start to use this for some parts of the application. Our initial feelings are that Linux will perform much better on low-to-medium load and Solaris will perform better when you start to get a high load because of extreme disk IO, but we don't yet have anything conclusive about this.  After some discussion with a Linux Kernel developer, this might be a side e ect of Linux giving so much resources to the batch job that the interactive performance gets very low.  This makes the machine feel very slow and  unresponsive  while  big  batches  are  going.   Hopefully  this  will  be  better  handled  in future Linux Kernels. 5.1.4  The MySQL Benchmark Suite This should contain a technical description of the MySQL benchmark suite (and  crash- me),  but  that  description  is  not  written  yet.   Currently,  you  can  get  a  good  idea  of  the benchmark by looking at the code and results in the `sql-bench' directory in any MySQL source distributions. This benchmark suite is meant to be a benchmark that will tell any user what things a given SQL implementation performs well or poorly at. Note  that  this  benchmark  is  single  threaded,  so  it  measures  the  minimum  time  for  the operations.   We plan to in the future add a lot of multi-threaded tests to the benchmark suite. For example, (run on the same NT 4.0 machine): Reading 2000000 rows by index     Seconds  Seconds mysql 367 249 mysql  odbc 464 db2  odbc 1206 informix  odbc 121126 ms-sql  odbc 1634 oracle  odbc 20800 solid  odbc 877 sybase  odbc 17614 Inserting (350768) rows Seconds  Seconds mysql 381 206 mysql  odbc 619 db2  odbc 3460 informix  odbc 2692 ms-sql  odbc 4012 oracle  odbc 11291
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    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