Innodb 150 million records

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!


I have a table with approx. 150,000,000 ++ rows. It should be approx
80byte for each row. Now I'm planning to use it with mysql/innodb.

Can you guys suggest anything about this.

I have many questions... Can Innodb work well with such tables?
Will queries (select/update) be slow?

What hardware do you suggest, cpu/ram?

If you could share your experience it would be great.

Site Timeline