Hello; Is there (or should there be) a limit to the number of tables created within a mysql database? Or is creating new databases for new tables more advisable in terms of data security? How do you usually choose to do it?
Well i think the limits are really high, dependant on the number of files you can have on the operating system (for myisam). InnoDB is in the millions but dependant on table size. You'd be hard pushed to break any physical limits but as you say for purposes of administration and maintenance it usually makes sense IMO to split your databases logically, usually per application (but not always...). I have in some cases in the past used seperate databases for the same application mainly for performance reasons.
Following link shall resolve most of your doubts.. http://www.dbforums.com/mysql/378480-max-number-tables-mysql-database.html
Thank you very much for your replies. I wanted to make sure that I wasn't making a mistake by placing multiple tables in one database.
You really shouldn't have that many tables, and fewer databases. 100 tables would probably be about max for a complex website. 10-30 should be your maximum, or you're doing something wrong.