Am 13.06.2013 12:07, schrieb Hartmut Holzgraefe:
> this combined with file-per-table engines like MyISAM or ARCHIVE (maybe with
> InnoDB with innodb-file-per-table
> being active, too?) may well lead
> to a lot of file handles being used, and this again combined with the
> table_cache keeping o
On 06/13/2013 09:41 AM, walter harms wrote:
Hello Manuel,
thx for your tip. We caught the problem when we moved to partitions. Strange is
that
while testing the problem did not show up and even now we no clue why we
experience
the sudden burst of use for file descriptors.
problem with partit
Am 13.06.2013 12:07, schrieb Hartmut Holzgraefe:
> On 06/13/2013 09:41 AM, walter harms wrote:
>
>> Hello Manuel,
>> thx for your tip. We caught the problem when we moved to partitions.
>> Strange is that
>> while testing the problem did not show up and even now we no clue why
>> we experience
>
Am 12.06.2013 12:33, schrieb Manuel Arostegui:
> 2013/6/12 walter harms
>
>>
>> Hi list,
>> i am trying to understand the incredible use of filepointers in our mysql
>> server (5.1.53).
>> under normal condition the server reports 10k-15k open files pointer.
>> I run a 'flush tables' every 2h t
2013/6/12 walter harms
>
> Hi list,
> i am trying to understand the incredible use of filepointers in our mysql
> server (5.1.53).
> under normal condition the server reports 10k-15k open files pointer.
> I run a 'flush tables' every 2h to avoid problems, the number of
> users/connections is cons
Am 12.06.2013 12:03, schrieb walter harms:
> i am trying to understand the incredible use of filepointers in our mysql
> server (5.1.53).
> under normal condition the server reports 10k-15k open files pointer
harmless :-)
[root@localhost:~]$ lsof | grep mysqld | wc -l
471206
nobody but oracle