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.
谢谢
玛纳西
推荐答案
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屋!