Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can mysql handle a dataset of 50gb?

Tags:

database

mysql

Can mysql handle a dataset of 50gb (only text) efficiently ? If not, what database technologies should I use ?

thanks

like image 919
aneuryzm Avatar asked Mar 06 '10 08:03

aneuryzm


People also ask

How large data can MySQL handle?

The MySQL maximum row size limit of 65,535 bytes is demonstrated in the following InnoDB and MyISAM examples. The limit is enforced regardless of storage engine, even though the storage engine may be capable of supporting larger rows.

Can MySQL store large data?

MySql have Unlocked New Big Data Insights with MySQL & Hadoop. Soluation 1: You can use MySQL as a Document Store. There are possible to store many many object as JSON. It highly recommended and Extendable.

How does MySQL handle millions of data?

Show activity on this post. As already mentioned, fetching 2.5 mio entries requires loads of memory / cpu power. Try fetching the records in batches. If that's not solving your problem, you should consider finding a better way to not loop through such an amount of records each time.


1 Answers

Technically, I would say yes. MySQL can handle 50GB of data, efficiently.

If you are looking for a few examples, Facebook moved to Cassandra only after it was storing over 7 Terabytes of inbox data.

  • Source: Lakshman, Malik: Cassandra - A Decentralized Structured Storage System.

Wikipedia also handles hundreds of Gigabytes of text data in MySQL.

like image 118
Daniel Vassallo Avatar answered Oct 16 '22 12:10

Daniel Vassallo