CODEWITHSUNDEEP
mysql
Hogsmill
Hogsmill

Reputation: 1574

Is there any performance hit with lots of empty tables in MySQL?

Are there any performance issues with having lots of empty tables in MySQL? My CMS system has loads of optional features, and the build script adds all the necessary tables to the database in case they're needed in the future. Can anyone think of if and why this might be detrimental to performance? Disk space not really an issue...

Upvotes: 3

Views: 339

Answers (2)

regilero
regilero

Reputation: 30526

if you really hit big numbers of tables you'll maybe have to tune your config parameters on file descriptors and table caches. See for example this discussion:

http://forums.mysql.com/read.php?93,120120,120703#msg-120703

Upvotes: 3

Pekka
Pekka

Reputation: 449595

I can't think of any: In mySQL, a table consists of a number of files in the local file system.

Files laying dormant shouldn't be a problem. (Well, except if you have thousands or tens of thousands of tables: That might cause trouble not so much for the database, but for the file system. But I doubt that is the case here.)

Upvotes: 4

Related Questions