#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    2
    Rep Power
    0
    I am building a large, complex, database driven site using mySQL.

    I want to know if anyone has experience in how well does mySQL perform if let's say, the site getting 100 000 hits a day.

    The site is generated dynamically and there are registered users that need to be tracked, data warehousing functions, etc.

    Is mySQL robust enough to handle this traffic (it will be run off a Solaris machine)?

    We plan on migrating to an Oracle or Informix database in about 8 months, but for now, we need to work with mySQL because it's very cost effective.

    Any comments/responses would be much appreciated.




    [This message has been edited by invisible_avatar (edited July 29, 2000).]
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    61
    I can't give you any statistical results, but my experience with MySQL has been:

    1. I have never seen it hit a serious bottleneck on ANY of my production or development servers. (one of my development servers was a Pentium 90 with 16 MB RAM running FreeBSD, and I was able to develop a complete e-commerce application on it without any noticeable drag in searching through thousands of records.)

    2. It may not have transactions (commit/rollback), but I have never seen MySQL corrupt a table, even from random reboots.

    3. The benchmarks I have seen generally show one thing: MySQL is the fastest way to serve out data to a dynamic website. It may not have the best performance in INSERTS, UPDATES, or some of the more complex operations, but for simply serving out data, (especially with many hits using simple queries), nothing is faster.

    4. By the time you are ready to move to Oracle or Informix, you may not want to. MySQL 3.23.xx is almost out of beta, and will support many more complex operations than previous versions, including transactions, subqueries, etc... AND it will support table sizes in the multi-terabyte range. You might even want to start your development with version 3.23.21, which is a fairly stable beta version.

    5. On the other hand, you just might want to check out PostgreSQL, which is already much more sophisticated (if not quite as fast) than MySQL.

Similar Threads

  1. feedback regarding robustness of class
    By c0ldshadow in forum C Programming
    Replies: 1
    Last Post: January 12th, 2004, 11:45 PM
  2. unique id from mysql's built-in functions?
    By neobuddah in forum MySQL Help
    Replies: 0
    Last Post: May 2nd, 2003, 04:25 AM
  3. Unlike Access...mySQL's server needs?
    By JVRudnick in forum MySQL Help
    Replies: 3
    Last Post: April 16th, 2003, 06:56 AM
  4. php time() || mysql's time stamp?
    By caguru in forum MySQL Help
    Replies: 4
    Last Post: March 27th, 2003, 11:57 AM
  5. MySQL's password() function
    By IrinaIonela in forum PHP Development
    Replies: 2
    Last Post: February 14th, 2002, 07:10 PM

IMN logo majestic logo threadwatch logo seochat tools logo