Can anyone comment on MySQL performance on large tables with 10 million+ rows, from one's own-experience? How about 50 mn or 1 billion rows?

I have a phpBB forum with MySQL. Is anyone aware of large forums (with multi-million posts) running on MySQL? Or, will I have to switch to Oracle (later on)?