Mysql capacity to handle billions of rows

Question

I have this machine: Core 2 CPU 6600, 4GB, 64 bit system, Windows VISTA.

I am designing a system with 10 billion rows, this table has a foreign key to another table, which should contains 10x10 billion rows. Normally, I just do insert into two tables. I don't usually do joins.

I don't need user-facing real time performance. I wonder if mysql can handle this size with stability and reasonable performance.

Thanks a lot

How big are the rows? You're going to see a big performance hit once it can't keep everything in memory. — Nick ODell, Jun 02 '12 at 00:43
also off topic but is it a good idea to run anything on VISTA? — Namphibian, Jun 02 '12 at 06:00

score 2 · Answer 1 · edited May 23 '17 at 12:04

It depends on which engine you are using. In this post you can find additional informations:

Maximum number of records in a MySQL database table

In general, I would suggest you to use another OS different from VISTA if you can, mysq is best tuned for linux boxes,

Also, what I would suggest you is to try to make some benchmarks before inserting all the rows.

Look here for more references:

http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function%5Fbenchmark

score 0 · Answer 2 · answered Aug 13 '12 at 21:28

The deciding factor here will be what data types you are using in your fields. 10 billion x 10 columns of text fields and image blobs would be orders of magnitude larger than 10 columns of int(2).

I also agree that Vista is asking for trouble with billions of rows. It might work in theory but if you have a large number of clients it will probably crash and burn under load.

Mysql capacity to handle billions of rows

2 Answers2