Editor's note: You have anti-virus software, network firewalls, and various preventive measures. However, in the face of various unstable factors, can you ensure that you will never win? Do not be confused when exceptions occur. self-check helps you identify security risks and develop defensive strategies. To handle security problems with ease, you must start self-check. Starting from this issue, we will bring you a self-check trilogy to guide you to self-check. Today, we will introduce the self
First,number of files limit modification(1)VI/etc/security/limits.conf* Soft nofile 10240 * Hard Nofile 10240(2) VI/etc/pam.d/loginsession required/lib/security/pam_limits.soSecond,Network port Limit Modification(1) Vi/etc/rc.d/rc.local/sbin/modprobe ip_conntrack # load Ip_contrack module #/sbin/sysctl–p # make/etc/sysctl.co NF configuration is in effect, depending on the actual situation to decide whether to add this command [[email protected] ~]# Sysctl-a | grep "Net.ipv4.ip" Net.ipv4.ip_connt
The number of IIS connections is the number of accesses that the server can accept at the same time, and can be easily understood as the number of threads that are allowed to send a read to the server at the same time.
We are divided into 5 kinds of circumstances to introduce to you: (100M space to limit 50IIS as an example)
1, users single-threaded or multi-threaded download your site files, after the normal disconnect, these
For SSH development, once it appears:
Org.apache.commons.dbcp.SQLNestedException:Cannot get a connection, pool error Timeout waiting for idle object
Such a mistake, is very tangled. It means that you have a full pool of connections. It is best to monitor the current number of connections at this time, so it is much easier to debug. One approach is to view the system table V$session of the Oracle database, w
Netstat command and awk to view the number of concurrent connections to the Web server and the TCP connection status.
The code is as follows
Copy Code
Netstat-n | awk '/^tcp/{++s[$NF]} end {for (a in S) print A, s[a]} 'Or:Netstat-n | awk '/^tcp/{++state[$NF]} end {for (key) print key, "T", State[key]} '
Fin_wait2 38CLOSING 3SYN_RECV 1Close_wait 1Time_wait 261Established 71Last_ack 2Fin_wait1 9
Each state meaning
The default maximum number of connections for MySQL 5.0 is 100, which may not be enough for a large load of concurrent requirements, at which point you can modify the maximum connection for MySQL.To view the current maximum number of connections for MySQL:
Mysqladmin-uroot-ppassword Variables | grep max_connections
Or
Mysql> show GLOBAL VARIABLES WHERE variable_name= ' max_connections ';
Method One:
En
Set in httpd.conf:
MaxClients N
1, apache1.x
n is an integer that represents the maximum number of connections between 1 and 256, if you want to allow Apache to support more connections, then you need to modify the Httpd.h file in the source code, edit the/httpd-2.0.59/include/httpd.h in the Hard_server_ The limit value is changed to large and then compiled.
Ways to increase the maximum number of
Set in httpd.conf:
MaxClients N
1, apache1.x
n is an integer that represents the maximum number of connections between 1 and 256, if you want to allow Apache to support more connections, then you need to modify the Httpd.h file in the source code, edit the/httpd-2.0.59/include/httpd.h in the Hard_server_ The limit value is changed to large and then compiled.
Ways to increase the maximum number of Apache
Integration with IBM Connections Files and IBM Docs is a shiny new feature offered in iNotes9.0. IBM Connections Files is a platform for enterprise-level information sharing and team collaboration. IBM Docs is also an enterprise-class online file editing system. iNotes9.0 and their integration effectively improve the internal efficiency of the enterprise, but also solve the sending, receiving large attachme
From:http://dba.stackexchange.com/questions/1558/how-long-is-too-long-for-mysql-connections-to-sleep
20down Votefavorite11
I logged onto my server to check the status of the database and noticed on the that SHOW PROCESSLIST; there is a large number of Conne Ctions sleeping that is very old.What duration should the connection time limit is before the connection should be killed?How does I set the time limit in MySQL 5.0.51a-3ubuntu5.4?
Label:Table of Contents
MySQL Show Status-open database connections
MySQL Show Processlist
MySQL Show Status-summary
MySQL "Show status" Faq:can you demonstrate the MySQL show statuscommand to show MySQL variables and Status information, such as the number of open MySQL connections? I don ' t has a whole lot of time today to give this a detailed discussion, but it's a quick look at s
mysql-uroot-pgameol32! OrMysql-uroot-p Enter the password into the MySQL console againMySQL Console mode:Show status; View all MySQL statusShow Processlist; Average user's own current number of connections, root user can view the current number of connections for all usersShow status like '%connections% '; Keyword searchShell command-line mode:Mysqladmin-uroot-p
Label:Workaround for MySQL 1040 error too many connections 1. May be the problem with MySQL max connections setup 2. It is possible that multiple insert,update operations have not closed the session and need to configure transaction support in spring. Solve: 1. Change the time-out time of the session in Tomcat to 20, (not required) 2. Transaction support for operations with large processing volumes for da
How to solve the problem that MySQL exceeds the maximum number of connections. Recently, the User database name hasalreadymorethanmax_user_connectionsactiveconnections error is reported on the website. It is necessary to study this problem. Max_user_connec: the User database name has already more than 'max _ user_connections 'active connections error is reported on the website recently. It is necessary to s
We have always believed that HTTP connections are divided into long connections and short connections, and we are often using HTTP1.1, so we use long connections. This is only half of the sentence, we are now the HTTP protocol, most of them are 1.1, so we usually use is basically a long connection. But the first half o
How to solve the problem that the number of MySQL connections exceeds the limit: the User database name has already more than 'max _ user_connections 'active connections error is reported on the website recently. It is necessary to study this problem.
Max_user_connections is the maximum number of MySQL User connections. The full-range statement indicates that th
are: Established is communicating, time_wait indicates active shutdown, close_wait indicates passive shutdown.The TCP protocol stipulates that for a connection that has already been established, the network will have to perform four handshakes to successfully disconnect, and if one of these steps is missing, the connection is suspended and the resource occupied by the connection itself is not freed. Network server program to manage a large number of connect
In the process of using Windows 8, it is sometimes repeated to add a network connection, although it does not affect normal use, but a long string of useless connections looks very uncomfortable. In addition, some default network names (such as "Network 2") are neither intuitive nor pleasant to hear. However, these connections are not directly deleted and renamed, we can only use the registry to complete.
(1) The parameter that controls the maximum number of connections allowed by the Nginx single process is worker_connections, which is adjusted based on server performance and memory usage(2) The maximum number of connections for a process is limited by the maximum number of open files for the Linux system process, and only after "ULIMIT-HSN 65535" is executed, worker_connections can take effect(3) Number of
Label:1. Ways to modify the maximum number of connections for Oracle http://my.oschina.net/shootercn/blog/11193 A, landing in SYSDBA status of PL/SQL or Worksheet Sqlplus SYS as SYSDBA B, query the current number of connections Show parameter processes; C, change the number of system connections Alter system set processes=1000 Scope=spfile; D. Create Pfile Cre
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.