I'm running a remote script that collects data from the web nightly. Each morning I import the latest data to my database on my Mac using a command line import to phpMyAdmin, adding to the number of rows from the night before. I then access the data locally using a Python script. Is there a limit to the size of a table that I can have either in terms of being able to store the data or access it via a query in Python? And, if so, is there a way to check and see how close I am to the limit?
Please note that I'm not concerned with the import size since I'm just importing daily snapshots and inserting those newest rows.