I have seen and used MySQL databases with +2 Million rows, +5 Million Tables, over 750Gb total, with tables over 100Gb, and rows over 1Gb.
I will run on your iMac, but depending on how fast your processor is, and how fast you need to do the accesses, that will be the limiting factors.