Just a few hundred GBs of MySQL, which doesn't sound too big, but having tens of millions of rows can be tricky with some more complex query, to keep query time

Just a few hundred GBs of MySQL, which doesn't sound too big, but having tens of millions of rows can be tricky with some more complex query, to keep query time reasonable (within 1-2 seconds max).