All geek questions in one place

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

Are there performance problems with lots of empty tables in MySQL? My CMS system has many additional features, and the build script adds all the necessary tables to the database, if needed in the future. Can anyone think if and why it could be detrimental to performance? Disk space is really not a problem ...

+3
source share
2 answers

I can’t think of anything: in mySQL, a table consists of several files in the local file system.

Files that are in sleep mode should not be a problem. (Well, if you have thousands or tens of thousands of tables: this can cause problems not so much for the database as for the file system. But I doubt that this is the case here.)

+4
source

If you really hit a large number of tables, you may need to configure your configuration settings for file descriptors and cache tables. See for example this discussion:

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

+3
source

Source: https://habr.com/ru/post/1782912/

More articles:


All Articles