max number of tables in db

Is there a limit regarding the number of tables within a db for MyIsam and InnoDB?


No, it is limited by the operating system. Some filesystems don’t deal well with a large number of tables. InnoDB uses a lot of memory if you have tens of thousands of tables. This is fixed in the Percona version of the server.