mysql instance disk quota

[Ken Peng]

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

[Ken Peng]

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

[Ken Peng]

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: converting some rows from utf-8 to iso-8859-1

[Ken Peng]

On Thu, 30 Aug 2007 11:41:14 +0200, Olav Mørkrid
[EMAIL PROTECTED] said:
 if a table column is supposed to contain text in iso-8859-1, but utf-8
 encoding have snuck in on a few rows by mistake, how are these rows
 converted into iso-8859-1?
 
 what i am looking for is something like this:
 
 update mytable set mycolumn = utf8toiso88591(mycolumn) where id
 between 500 and 600;
 

I don't know if mysql has this charset converting routine.
But you can do it by application scripts,ie,in perl you can convert them
by,

use Encode;
my $iso_str = encode('iso-8859-1',decode('utf8',$utf8_str));

first you select utf8 string from db one by one and store it to
$utf8_str,then use the function above to be converted to iso-8859-1,then
insert it again to mysql.
-- 
  Ken Peng
  [EMAIL PROTECTED]

-- 
http://www.fastmail.fm - Accessible with your email software
  or over the web


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: servers full potential / FT searches locking tables

[Ken Peng]

On Wed, 29 Aug 2007 18:02:31 -0400, Michael Dykman [EMAIL PROTECTED]
said:
 I mean that the theoretical limit of a 32-bit application is 4G... in
 practice, you won't quite get that (for a pile of practical reasons)..
   best to keep your configured memory requirements to around 3.5G or
 you will run into weird errors.
 

Sorry,I mean is the entire mysql application limited to 4G?
Or single configuration argument is limited to 4G?

for example,

config_directive_a 2G
config_directive_b 2G
config_directive_c 2G

Though here I configured 6G totally,but each directive is 2G.
Is this right for a 32bit system?Thanks.
-- 
  Ken Peng
  [EMAIL PROTECTED]

-- 
http://www.fastmail.fm - I mean, what is it about a decent email service?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: servers full potential / FT searches locking tables

[Ken Peng]

On Tue, 28 Aug 2007 13:31:43 -0400, Michael Dykman [EMAIL PROTECTED]
said:
 No, I'm afraid not.  32 bit architectures have a theoretical limit of
 4G of memory space for the entire application: in actual practice, for
 a variety of reasons too complex to go into here (and are well
 documented elsewhere) your key buffer should be limited to around 2.5G
 max, and this is assuming a pure MyISAM implementation.  There simply
 is no way a 32 bit build can make use of all that RAM, regardless of
 OS.
 

Hello Michael,

Do you mean the entire mysqld server including its child,modules should
only use 4G memory?
If so,the config below for 32 bit OS is may wrong,is it?Thanks.

key_buffer_size=2G
innodb_buffer_pool_size=2G
-- 
  Ken Peng
  [EMAIL PROTECTED]

-- 
http://www.fastmail.fm - The way an email service should be


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]