Today my DBA reported that the server she was working on was spitting out “too many open files” errors and no new processes could be started.
This is a common problem with DB servers with heavy transactions. In my environment there are 6 DB instances running on the server. No quite the optimized setup I would say.
The fix was to increase the total file descriptors kernel parameter count in the /etc/sysctl.conf file. I doubled my limit from 8192 to 16384.
The walk through,
1. Find out what the current open file descriptor limit is.
~# more /proc/sys/fs/file-max
~# 8192
or
~# sysctl -a | grep fs.file-max
~# fs.file-max = 8192
2. View how many open file descriptors are currently being used.
~# more /proc/sys/fs/file-nr
~# 8191
3. View how many files are open. The number returned might defer as 1 file descriptor can have multiple open files attached to it.
~# lsof | wc -l
~# 10325
4. Edit the kernel paramneter file /etc/sysctl.conf and add line “fs.file-max=[new value]” to it.
~# vi /etc/sysctl.conf
fs.file-max = 331287
5. Apply the changes.
~# sysctl -p
~# fs.file-max = 331287
Problem fixed.
相关推荐
There aren't many good resources out there for writing Python descriptors, and extremely few books. This is a sad state of affairs, as it makes it difficult for Python developers to get a really good ...
NULL 博文链接:https://frank1998819.iteye.com/blog/1954628
Jenkins安装过程,每个运维都需要的系统。应为几乎所有的团队都需要它。
embed: force close of file descriptors (#6208) webapp: add info log when WebApp does not start within active-wait-time starts (#6197) hessian: added default blacklist classes deploy: added alarm for ...
Python Descriptors
epoll - I/O event notification facility ... The epoll API can be used either as an edge-triggered or a level-triggered interface and scales well to large numbers of watched file descriptors.
are described in this paper have undergone extensive evaluation and development during the past two years. Evaluation criteria include effectiveness of the descriptors in similarity retrieval, as well...
Playing with file descriptors and redirection 19 Arrays and associative arrays 25 Visiting aliases 27 Grabbing information about terminal 29 Getting, setting dates, and delays 30 Debugging the script ...
Python’s simplicity lets you become productive quickly, but this often means you aren’t using everything it has to offer. With this hands-on guide, you’ll learn how to write effective, idiomatic ...
There are so many different areas of improvement / addition that I've decided to do a review for developers - in bite-size pieces. Today marks the launch of my daily blog series - iOS7 Day-by-Day. ...
In this paper, we explore methods for learning local image descriptors from training data. We describe a set of building blocks for constructing descriptors which can be combined together and jointly ...
Module Name: rsmem24 - Memory resource descriptors.
color and texture descriptors 图像研究经典论文
Find out how to execute effective penetration tests, use fuzzers and sniffers, perform reverse engineering, and find security holes in Windows and Linux applications. You’ll also learn how to trap ...
File Descriptors Low Level I/O - Read and Write Open, Creat, Close, Unlink Random Access - Lseek Example - An implementation of Fopen and Getc Example - Listing Directories Example - A Storage ...
Boosting Binary Keypoint Descriptors 论文阅读笔记
A performance evaluation of local descriptors一篇经典的论文,对于学习局部算子很有帮助。
Linux下的进程间通信详解.pdf
31 * file descriptors. 32 * 33 * There are some fragile aspects around bootclasspath entries, owing 34 * largely to the VM's history of working on whenever it thought it needed 35 * instead of ...
some order 1 and 2 texture descriptors