开发者

Setting MySQL DB size through PHP

My host's techni开发者_JAVA技巧cal support sent me the following in reply to a suggestion to the sales team about the number and size of default MySQL databases. Specifically, I was suggesting to the sales team that the host could do better by offering fewer databases at larger sizes than many databases at small sizes, in context to how quickly a blog or board could fill a 100MB DB:

You can edit the PHP.ini file in your SSH access to actually administer your database size limitations. If you wish to have 50, 100MB each or 5, 1000MB each there is no problem doing so. You will be required to set up these configurations on your own, however you are able to do so.

However, the details of this are not outlined in the email (I've followed up, but thought I would ask SO experts while I wait). I'm not much of a PHP expert or MySQL admin, but dangerous at the command line (most familiar with PostgreSQL). I wasn't even aware you could direct MySQL though the php.ini

Anyone want to take this on?


I'm not aware of any PHP setting to limit the number or size of MySQL databases. Hosts sometimes put user limits on disk space where database data is stored. In any case, the sales rep may have been mistaking the php.ini settings for upload and POST limits that often impeded uploading SQL files to phpMyAdmin in shared hosting environments.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜