mysql对数据库数量是否有任何限制 [英] Does mysql have any limitation on number of databases

问题描述

我正在"/Var/lib/mysql/data"中的mysql默认数据目录中创建mysql数据库. 但这不允许我在其中创建31999个以上的数据库.

I am creating mysql databases in mysql default data directory in "/Var/lib/mysql/data" But it is not allowing me to create more than 31999 databases in it.

我之前问过类似的问题: Mysql创建具有新数据库位置的数据库

The similar sort of question I have asked before : Mysql create database with new database location

我在上面说过mysql可以创建32000个以上的数据库，但是当我在生产服务器上尝试此操作时.这没有发生.

Where I said that mysql can create more than 32000 databases but, when I tried this thing on production server. It is not happening.

有没有可能将数据库存储在不同的位置.

Is there any possibility, where I can store databases on different locations.

任何输入都会有所帮助.

any input will be an help.

谢谢

玛纳西

推荐答案

MySQL手册指出此处的数据库数量没有限制:

The MySQL manual states that there is no limit on the number of databases here: maximum number of databases in MySQL

但是，由于每个数据库都需要在文件系统上创建一个目录，并且文件系统可能会对一个文件夹中的目录数有所限制，因此存在有效限制.

However, since each databases requires the creation of one directory on the file system, and the file system may have a limit on the number of directories in one folder, there is an effective limit.

检查文件系统文档以获取其允许的最大目录数量(NTFS〜40亿，ext3〜32000，ext4〜unlimited等)

Check your file system documentation for the maximum number of directories it allows (NTFS ~ 4 billion, ext3 ~32000, ext4 ~unlimited, etc.)

这篇关于mysql对数据库数量是否有任何限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！