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 constant It is an automatic system but a few human users, a happy mix of myisam and innodb tables running with no problems on mysqld 5.0 . But now sometimes i am hit with an insane increase hitting the ceiling at 60k. I do not like the idea to increase the limit further because i do not understand why this is happening (I seems to happen at random times).
I am running out of idea what my cause the unexpected increase, any idea what to watch ?
re, wh
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Jun 12
Reindl Harald Re: open files in mysqld 5.1.53
Jun 12, 2013; 12:27
Reindl Harald
Re: open files in mysqld 5.1.53
Jun 12
Manuel Arostegui Re: open files in mysqld 5.1.53
Jun 12, 2013; 12:33
Manuel Arostegui
Re: open files in mysqld 5.1.53
Jun 13
walter harms Re: open files in mysqld 5.1.53
Jun 13, 2013; 09:41
walter harms
Re: open files in mysqld 5.1.53
Jun 13
Hartmut Holzgraefe Re: open files in mysqld 5.1.53
Jun 13, 2013; 12:07
Hartmut Holzgraefe
Re: open files in mysqld 5.1.53
Jun 13
walter harms Re: open files in mysqld 5.1.53
Jun 13, 2013; 12:24
walter harms
Re: open files in mysqld 5.1.53
Jun 13
Reindl Harald Re: open files in mysqld 5.1.53
Jun 13, 2013; 13:19
Reindl Harald
Re: open files in mysqld 5.1.53
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!