can mysql database handle all these requests ?

0 david kevork · September 20, 2014
can mysql handle 1 billion data or more in one table 
and saving information to database around half billion data per 30 second 
and getting back the data around half billion data per second 

Post a Reply


Oldest  Newest  Rating
+1 Eugene Botma · September 20, 2014
1 billion data doesn't explain much.

for example: 10^9 data.

there is 1 billion data. so yeah sure mysql will be able to easily handle that. If you're talking about 1 billion records, again, it doesn't mean much. A record can be a single bit, in which case your DB will be just a bit more than 1 GB. or, your record can be a whole lot of other stuff, in which case the DB can be more than a few exabytes.

Since you mentioned the (i'm assuming) number of records you're going to use, i suggest looking at something like a clustered instance of cassandra. It was built by facebook to handle their data, so it is more suited for such amounts of data than MYSQL. 

What george said is correct, MYSQL should be able to handle it, but you're going to have to pay a lot of money for server to handle that amount of data, no matter what DBMS you use. Odds are that you're not going to get something powerful enough to process half a billion records in under a second for less than 1 000 000 USD.
0 George Williams · September 20, 2014
A MySQL database can hold as much as you want as long as you have the money to pay for it. As foe speed, that also is determined by your money so to answer your question..Yes, If you've got a couple 100k
  • 1

SQL & Databases


Everything SQL and Databases related in here!

Bucky Roberts Administrator