How to manage 1000 millions of record in Mysql database
-
I want to manage 10 major tables with 100 millions record each, each row have about 20 fields/colums, so how to manage these 10 interlinked tables. Can MySql handle such large data?
-
I want to manage 10 major tables with 100 millions record each, each row have about 20 fields/colums, so how to manage these 10 interlinked tables. Can MySql handle such large data?
-
I want to manage 10 major tables with 100 millions record each, each row have about 20 fields/colums, so how to manage these 10 interlinked tables. Can MySql handle such large data?
Member 12069869 wrote:
Can MySql handle such large data?
Yes. Of course that doesn't mean your application can. Nor that you can't mess it up by failing to design correctly.
Member 12069869 wrote:
each row have about 20 fields/colums
Things that matter - What is the maximum, average and variance for the row size (your data not db overhead.) - What is the realistic growth rate? Realistic means that, not pie in the sky sales/marketing claims. - What will the system be querying on most? Unless your growth rate is very big this is more relevant. - Can data be aged? Thus will the above queries be mostly for the last month, or last three months versus spanning the entire data store