Re: OT - Re: IS it possible to connect to a MySQL database in asp?

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 05/10/04

  • Next message: sean: "add values without using SUM in query?" 
    Date: Mon, 10 May 2004 03:10:40 -0400

    > what rdbms features doesn't it have? I'm not a dba in any way so maybe
    > you'll need to dumb down response :)

    For the free/unrestricted versions of MySQL (e.g. not including MaxDB etc),
    these features are either unsupported, minimally/unacceptably supported, or
    only supported in certain versions/configurations (e.g. I believe
    transactions are supported with MySQL/InnoDB).

    - views
    - stored procedures
    - triggers
    - subqueries (sub-selects, derived tables)
    - outer joins
    - referential integrity
    - transactions/rollbacks
    - failover/clustering support
    - scheduling / messaging / alerts
    - snapshots

    MySQL documentation and advocates would have you believe that these things
    are not important. You might argue that some of these features aren't
    strictly necessary for an RDBMS, only a DBMS. And that is possibly true
    (e.g. there are always workarounds for subqueries) but they are still
    features that I feel are very important in building a scalable and
    maintainable database solution.

    MySQL scalability comes into question quite often. One of MySQL's
    "features" is that it locks the entire table for an insert, so if you have
    an insert-heavy system, there goes performance. Not only do you block other
    inserts, but you also block updates and selects. For small web sites it is
    probably fine, but if you visit sites like SlashDot, and you have seen it
    down, then you're already aware of how MySQL performs under heavy load.

    I also read an article once (phpbuilder, maybe?) where the author stated
    that MySQL often runs fine for 30-60 days and then just dies for no reason.
    He stated that people compile the MySQL engine statically to avoid this, or
    schedule a task to restart MySQL once a month. 

    -- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
  • Next message: sean: "add values without using SUM in query?"

    Relevant Pages

    • RE: Postgres, MySQL, and Firebird.
      ... Well since I neglected to mention what those features are I guess I ... MySQL doesn't support subselects which will come in very handy for many ... Firebird has them. ... It's threading model seems better than Postgres. ...
      (RedHat)
    • Re: PostgreSQL or MySQL ?
      ... I'm not going to argue that PostgreSQL isn't superior technology, ... This is the case for MySQL now too. ... MySQL 5.0 supports these features in its ... so old that MySQL has discontinued support for them. ...
      (comp.databases)
    • Re: PostgreSQL or MySQL ?
      ... This is the case for MySQL now too. ... it's true that the syntax diagrams cover only ... MySQL 5.0 supports these features in its ... so old that MySQL has discontinued support for them. ...
      (comp.databases)
    • Re: MySQL5 & PHP5
      ... See my other message in reply to Tony Reed - unless you recompile PHP, ... but just recompiled against a later MySQL version. ... client actually makes any difference - you won't get any new features ...
      (comp.lang.php)
    • Re: Delphi 2006 SP2 feature request
      ... > What I'd really like to see is MySQL 4.1 and MySQL 5.0 support. ... MySQL 5.0 have a lof of features like store procedures, ... parameter binding using new API and replace all old API with new api ... Then many work is necessary to support MySQL 5 to update 2 is very ...
      (borland.public.delphi.non-technical)