I am designing a database driven app (on Linux of course), and I was wondering if MySQL is a capable database engine when accessing tables with 500,000 records (or 1,000,000)? If no, what is the largest table size that MySQL can handle? Thanks.