问题描述
我正在"/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手册指出此处的数据库数量没有限制: 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对数据库数量是否有任何限制的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!