Can you have too many tables in a database?

Question

There's nothing unusual about having hundreds of tables in a database. Far more likely is that your queries aren't properly optimised. I would advise turning on the log-slow-queries and log-queries-not-using-indexes . 10 нояб. 2009 г.

How many tables is too many in a database?

The number of tables is limited only by the number of database objects, currently 2, 147, 483, 647. A couple of hundred tables isn't going to make a difference to anything except the clarity of your data model.

How many tables can you have in a database?

You can create up to 2,147,483,647 tables in a database, with up to 1024 columns in each table. When you design a database table, the properties that are assigned to the table and the columns within the table will control the allowed data types and data ranges that the table accepts.

Can a DB have multiple tables?

Often, it is good database design practice to split a many-to-many relationship between two tables into two one-to-many relationships involving three tables. You do this by creating a third table, called a junction table or a relationship table, that has a primary key and a foreign key for each of the other tables.

How many tables can be created?

MySQL has no limit on the number of databases. The underlying file system may have a limit on the number of tables. Individual storage engines may impose engine-specific constraints. InnoDB permits up to 4 billion tables.

Expert · Answer