MySQL Forums
Forum List  »  MyISAM

Re: MYSQL and 4 Billion Rows
Posted by: Rick James
Date: February 06, 2010 01:07AM

The 4G limit in MyISAM is an old default. To assure you don't hit it, use MAX_ROWS on your CREATE TABLE statement.

Please do SHOW CREATE TABLE tbl \G

1 row inserted per second? Total data: 4.6GB -- small compared to current disk drives. Adding one index on the timestamp would add less than 1GB more. That assumes 151 columns in the table. Yawn.

1 tag per row? 150 INSERTs/sec -- still not bad (unless you have some strange indexes). Now it might be 25GB of disk; still not too big.

What will the SELECTs look like? For that much data, you need to plan them now. Otherwise, they may be the performance killers.

Perhaps you should collect data for a week, then
* look at the data size (SHOW TABLE STATUS) and extrapolate to the ultimate size
* experiment with the SELECTs.
* decide whether to have 1 wide row per second or 150 narrow rows. After a week, converting the table won't take long. (After a year, it will be painfully slow.)

Options: ReplyQuote


Subject
Views
Written By
Posted
5147
February 04, 2010 05:53AM
Re: MYSQL and 4 Billion Rows
2922
February 06, 2010 01:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.