Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

mysql records

mysql records

  • Please log in to reply
4 replies to this topic

#1 tontonskie

tontonskie

    CC Newcomer

  • Just Joined
  • PipPip
  • 15 posts

Posted 12 December 2010 - 11:31 PM

how many records can mysql handle?
  • 0

#2 wim DC

wim DC

    Roar

  • Expert Member
  • PipPipPipPipPipPipPipPip
  • 2681 posts
  • Programming Language:Java, JavaScript, PL/SQL
  • Learning:Python

Posted 13 December 2010 - 12:14 AM

MySQL :: MySQL 5.1 Reference Manual :: 1.3.3 The Main Features of MySQL

Scalability and Limits:

Support for large databases. We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 200,000 tables and about 5,000,000,000 rows.


  • 0

#3 Alexander

Alexander

    YOL9

  • Moderator
  • 3963 posts
  • Location:Vancouver, Eh! Cleverness: 200
  • Programming Language:C, C++, PHP, Assembly

Posted 13 December 2010 - 12:48 AM

I would have moved onto Cassandra or something long ago.
  • 0

All new problems require investigation, and so if errors are problems, try to learn as much as you can and report back.


#4 wim DC

wim DC

    Roar

  • Expert Member
  • PipPipPipPipPipPipPipPip
  • 2681 posts
  • Programming Language:Java, JavaScript, PL/SQL
  • Learning:Python

Posted 13 December 2010 - 01:55 AM

I can't even think of a database with 200.000 tables :c-blink:
I really hope that's an exception in the world and other "normal" companies don't have such ones :c-smile:
  • 0

#5 Alexander

Alexander

    YOL9

  • Moderator
  • 3963 posts
  • Location:Vancouver, Eh! Cleverness: 200
  • Programming Language:C, C++, PHP, Assembly

Posted 13 December 2010 - 04:18 PM

200,000 tables is easy for language/especially scientific related applications, Unicode consortium's setup is over >1TB of descriptions and mappings alone.
  • 0

All new problems require investigation, and so if errors are problems, try to learn as much as you can and report back.






Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download