Without more info, it's going to be hard for anyone to give you good advice. Assuming you are using isam tables, MySQL keeps each database in a separate directory and each table as a separate file in the database's directory. If you have thousands of tables, you may run into issues depending on the filesystem.

Scott