Re: MYSQL 3 questions

[Rick James]

Virtually any version of MySQL can handle such. Recommend the latest released version of 5.1.

Do you have enough disk space for 9B rows? That could be terabytes. Please provide these for critique:
SHOW CREATE TABLE
SELECT -- the various queries you will be doing.

Adding an index to a table that already has 9B rows will require locking the table for hours. Add the indexes before populating the table.

You should probably have some Summary table(s); a table scan of 9B rows will take a loooong time (because of all the disk I/O).

These are confusing and/or inconsistent:
> Is possible to use MYSQL, if daily data amount downloaded to database is at minimum 1 milion rows (records).
> Data are inserting every 20 seconds.
> Data will be downloaded every day (24/7) - per 1 year is about 3 bilion records.

Are you getting a batch of 300 new rows every 20 seconds? (1M/86400*20)

INSERTing a million rows a day -- no problem.

9B rows is "huge", but not impossible.