Web lists-archives.com

Re: mysql instance disk quota

Am 06.09.2015 um 11:37 schrieb Ken Peng:
If disk quota is reached, an error can be threw out. we can accept this
policy. Thanks.

and damage will happen - jesus christ the worst thing for a database is "disk full", if you don't care just start the mysql instances as different users and set OS disk quota for them, but be prepared for data loss sooner or later

On 2015/9/6 17:28, Reindl Harald wrote:

Am 06.09.2015 um 11:08 schrieb Ken Peng:
We have some instances running in a hardware server, each instance has
different port.

For quota limits, we can adjust my.cnf to control each instance's memory
usage, also can use cgroups to set CPU quota.

But what's the general solution to setup the disk quota? For example, I
want each instance should use the storage no more than 50GB.

you can't

what do you expect how a database server should do if the disk quota is
reached? what about the global table space?

Attachment: signature.asc
Description: OpenPGP digital signature