SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    if($awake){code();} PHP John's Avatar
    Join Date
    Jul 2002
    Location
    Along the Wasatch Fault line.
    Posts
    1,771
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation MySQL limitations?

    I posting this to find out the limitations of MySQL.

    Maximum number of records/tables/connection/etc..

    Is there an article about this? I could not find answers to this question on the mysql site, but I may have missed the obvious.

    Does anyone have experience in breaking mySql, or know the limitations?

    Thanks!
    John

  2. #2
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    More than you can throw at it probably

  3. #3
    if($awake){code();} PHP John's Avatar
    Join Date
    Jul 2002
    Location
    Along the Wasatch Fault line.
    Posts
    1,771
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Let me rephrase this question then.

    Does anyone know of any sites that use MySQL in an industrial strength environment?
    John

  4. #4
    SitePoint Addict Drinky's Avatar
    Join Date
    Jan 2001
    Location
    England
    Posts
    338
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by MattR
    More than you can throw at it probably
    A good assumption, i'll never get anywhere near it's limits with what i use it for ... but not a helpful answer...

    This page contains some information on the max table sizes for MySQL which should give you an indication of the ammount of stuff you can put in it

    http://www.mysql.com/doc/en/Table_size.html

    2 to 512 Gb and possibly 8Tb then depending on your OS
    Last edited by Drinky; Oct 2, 2002 at 07:04.
    Drinky

  5. #5
    SitePoint Enthusiast BDKR's Avatar
    Join Date
    Sep 2002
    Location
    Clearwater, Florida
    Posts
    69
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey G,

    Just check the mysql site. Also check the site for inno base (the innodb tables). Yahoo finance is using it in the backend as guided by a capable chap by the name Jeremy Zawodny.

    Slashdot, who see's tons of traffic, is using it.

    Our company uses it as a backend for transaction processing of lottery sales.

    Now there are some serious concerns that people have had. Many of these are lack of stored procedures, lack of transactions, lack of foreign keys, and referential integrity issues with the myisam table types. However, the bulk of the above issues are settled with the use of the innodb tables.

    But if you don't need those things, why worry about 'em?

    Some of those mysql detractors are BIG Postgres fans. However, Postgres is only just now getting it's act together on the replication front. MySQL has been there for some time and is much more mature.

    Anyways, you asked....
    Cheers,
    BDKR
    If you're not on the gas, you're off the gas!

  6. #6
    if($awake){code();} PHP John's Avatar
    Join Date
    Jul 2002
    Location
    Along the Wasatch Fault line.
    Posts
    1,771
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ah!

    Now THAT is helpful! Thanks!
    John


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •