mysql instance disk quota
Hello, 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. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql instance disk quota
How to set OS disk quota? On 2015/9/6 17:52, Reindl Harald wrote: set OS disk quota for them -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql instance disk quota
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? signature.asc Description: OpenPGP digital signature
Re: mysql instance disk quota
Hi, If disk quota is reached, an error can be threw out. we can accept this policy. Thanks. 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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? signature.asc Description: OpenPGP digital signature
Re: mysql instance disk quota
Am 06.09.2015 um 12:01 schrieb Ken Peng: How to set OS disk quota? that's hardly a mysql question http://lmgtfy.com/?q=linux+disk+quota On 2015/9/6 17:52, Reindl Harald wrote: set OS disk quota for them signature.asc Description: OpenPGP digital signature