Are there limitations on size or record count in MySQL?
Here are a couple resources from the docs on MySQL limitations. 


  Individual storage engines may impose engine-specific constraints. InnoDB permits up to 4 billion tables. [src]





  There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table.  [src]





  Every table (regardless of storage engine) has a maximum row size of 65,535 bytes. [src]




Bottom line is, MySQL can easily handle your scenario.