Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
3
how many records can mysql handle?
4 replies to this topic
Back to top|
|
|
#2
Posted 13 December 2010 - 12:14 AM
wim DC
-
- Members
-
- 2,084 posts
Writes binary right handed and hex left handed
- Programming Language:Java, JavaScript, PL/SQL
- Learning:Java
MySQL :: MySQL 5.1 Reference Manual :: 1.3.3 The Main Features of MySQL
Quote
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.
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.
#3
Posted 13 December 2010 - 12:48 AM
Alexander
-
- Moderators
-
- 4,118 posts
It's Science!
- Location:Vancouver, Eh! Cleverness: 200
I would have moved onto Cassandra or something long ago.
Be sure to read the updated FAQ! || Health is achieved through the same 10,000 steps.
If a suggested code/method fails, informing us is less important than telling us why or what errors occurred.
If a suggested code/method fails, informing us is less important than telling us why or what errors occurred.
#4
Posted 13 December 2010 - 01:55 AM
wim DC
-
- Members
-
- 2,084 posts
Writes binary right handed and hex left handed
- Programming Language:Java, JavaScript, PL/SQL
- Learning:Java
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:
I really hope that's an exception in the world and other "normal" companies don't have such ones :c-smile:
#5
Posted 13 December 2010 - 04:18 PM
Alexander
-
- Moderators
-
- 4,118 posts
It's Science!
- Location:Vancouver, Eh! Cleverness: 200
200,000 tables is easy for language/especially scientific related applications, Unicode consortium's setup is over >1TB of descriptions and mappings alone.
Be sure to read the updated FAQ! || Health is achieved through the same 10,000 steps.
If a suggested code/method fails, informing us is less important than telling us why or what errors occurred.
If a suggested code/method fails, informing us is less important than telling us why or what errors occurred.
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
