MySQL single large table vs many small tables
one big table with all these rows was a better way to go?


Yes, absolutely

With proper table structures and indexing, MySQL will comfortably handle millions of rows in any table.  The "Table-per-?" model is never a Good Idea and invariably comes back to haunt you (usually when you need to summarise across all those tables).