Hi,
On Fri, Feb 27, 2009 at 2:51 PM, wrote:
> Thanks for the quick followup Baron..
>
> vmstat
> procs ---memory-- ---swap-- -io --system--
> -cpu--
> r b swpd free buff cache si so bi bo in cs us sy id
> wa st
> 3 0 100 499380 139256
In the last episode (Feb 27), dbrb2002-...@yahoo.com said:
> Thanks Dan.. thats a valuable point.. and this actually happening with
> MyISAM tables only..
>
> But the question is; when I set the table_cache to higher than total
> tables.. then it should stop closing the table in first place..so t
> From: Dan Nelson
> To: dbrb2002-...@yahoo.com
> Cc: mysql@lists.mysql.com
> Sent: Friday, February 27, 2009 1:15:25 PM
> Subject: Re: MySQL Closing/Opening tables
>
> In the last episode (Feb 27), dbrb2002-...@yahoo.com said:
>> Recently I not
, February 27, 2009 1:15:25 PM
Subject: Re: MySQL Closing/Opening tables
In the last episode (Feb 27), dbrb2002-...@yahoo.com said:
> Recently I noticed the server takes lot of time on and off when opening
> and closing tables. And I tried to increase the table_cache more the the
> tot
ium load..
>
>
>
> ____________
> From: Baron Schwartz
> To: dbrb2002-...@yahoo.com
> Cc: mysql@lists.mysql.com
> Sent: Friday, February 27, 2009 5:50:11 AM
> Subject: Re: MySQL Closing/Opening tables
>
> On Fri, Feb 27, 2009 at 4:19 AM, wr
In the last episode (Feb 27), dbrb2002-...@yahoo.com said:
> Recently I noticed the server takes lot of time on and off when opening
> and closing tables. And I tried to increase the table_cache more the the
> total tables (file_limit is properly set); and the problem still continues
> and lowerin
2.40 200.0027.2023.18 0.22
22.73 10.73 10.52
The above is when low to medium load..
From: Baron Schwartz
To: dbrb2002-...@yahoo.com
Cc: mysql@lists.mysql.com
Sent: Friday, February 27, 2009 5:50:11 AM
Subject: Re: MySQL Closing/Opening tables
On Fri, February 27, 2009 05:50, Baron Schwartz wrote:
> On Fri, Feb 27, 2009 at 4:19 AM, wrote:
>> Hi
>>
>> Recently I noticed the server takes lot of time on and off when opening
>> and closing tables. And I tried to increase the table_cache more the the
>> total tables (file_limit is properly
On Fri, Feb 27, 2009 at 4:19 AM, wrote:
> Hi
>
> Recently I noticed the server takes lot of time on and off when opening and
> closing tables. And I tried to increase the table_cache more the the total
> tables (file_limit is properly set); and the problem still continues and
> lowering it als
Hi
Recently I noticed the server takes lot of time on and off when opening and
closing tables. And I tried to increase the table_cache more the the total
tables (file_limit is properly set); and the problem still continues and
lowering it also continues.. and tried to set in middle.. same
Any
10 matches
Mail list logo
