Recently, I encountered an online alarm: a large number of time_wait servers make it unable to establish a new HTTP connection with downstream modules. During the solution, I checked the classic textbooks and technologies.ArticleTo enhance the understanding of TCP network problems. This is recorded as a note.Note: This article mainly introduces the many basic knowledge involved in TCP programming. The solution to the new connection failure caused by time_wait in the actual project will be given
can receive the data correctly each time, this experiment can prove).So since the socket itself supports long connections, why do we have to mention the concept of short connections? Imagine a China Mobile SMS gateway (that is, by releasing the socket Communication interface) every time every minute there are more than n connections to send SMS requests, join th
Currently the audio Live service, online number of people reached a certain number of values, there will be a drop in the situation, such as online 100. This program is connected by TCP! Excuse me, Win Server 2003 has a limited number of concurrent connections on TCP connections, and I want to make sure that Windows Server 2003 has a limited number of connections
Discussion socket must discuss long and short connectionsConcept of one, long connection and short connection1, the concept of long connection and short connection: The former is the entire communication process, the client and server only with a socket object, long-term to maintain the connection of the socket; the latter is a new socket for each request, which closes the socket directly after processing a request. So, in fact, the difference between the length of the connection is: the entire
Connections in SQL can be divided into inner joins, outer joins, and cross connections.1. Cross JoinWithout a WHERE clause, it will return the Cartesian product of the two tables connected, and the number of rows returning the result is equal to the product of two table rows;For example, the following results are the same for a, B, and C, but are not as efficient:A:select * FROM table1 cross JOIN table2B:se
HTTP is a stateless connection-oriented protocol, an application-layer protocol that uses TCP at the transport layer, using IP at the network layerin HTTP 1.0, a short connection is used by default, and the browser and server make a connection every time HTTP operation is made, but the end of the task interrupts the connectionThe http1.1 uses a long connection by default to maintain the connection characteristics. This line of code is added to the response header: Connection:keep-alive When a lo
HTTP implementation Long Connection
HTTP is statelessThat is, the browser and the server make a connection once for each HTTP operation, but the connection is interrupted at the end of the task. If the client browser accesses an HTML or other type of Web page that contains other Web resources, such as JavaScript files, image files, CSS files, and so on, when the browser encounters such a Web resource, an HTTP session is establishedThe biggest difference between HTTP1.1 and HTTP1.0 is
SQL Server connections across serversConnect remote SQL or insert data with OPENROWSET--if it's just temporary access, you can use OPENROWSET directly--query ExampleSELECT * FROM OPENROWSET (' SQLOLEDB ', ' SQL Server name '; ' User name '; ' Password ', database name. dbo. Table name)--import ExampleSELECT * Into table from OPENROWSET (' SQLOLEDB ', ' SQL Server name '; ' User name '; ' Password ', database name. dbo. Table name)--Create a linked ser
1.Linux Link ConceptThere are two kinds of Linux links, one is called hard link (Hard link), the other is called Symbolic link (symbolic link). By default, the LN command produces a hard link.
"Hard Connection"A hard connection refers to a connection through an index node. In a Linux file system, a file stored in a disk partition is assigned a number, called an index node number (Inode index), regardless of its type. In Linux, multiple file names point to the same index node. Generally this con
View the maximum number of connections in MySQL and the number of connections in MySQLMysql version: mysql5.5.40 or Mariadb 10.0.14
Max_connections = 151 by default
Method 1: Applicable to linux
[Root @ mydata184 ~] # Mysqladmin-uroot-p variables | grep max_connections
Method 2: Applicable to mysql client commands
[Root @ mydata184 ~] # Mysql-u root-p
Mysql> show variables like 'max _
It is possible that the current number of connections on the database has exceeded the maximum value that it can handle.Select COUNT (*) from v$process--current number of connectionsSelect value from v$parameter where name = ' processes '--maximum number of connections allowed by the databaseTo modify the maximum number of connections:alter system SET processes = Scope = SPFile;To restart the database:Shutd
This document is referenced from:Trying to increase the number of Database Connections (Doc ID 167674.1)Fact:oracle Server-enterprise Edition 8Fact:solaris Operating System (SPARC)Symptom:trying to increase the number of Database Connectionssymptom:ora-07252 Spcre:semget error, could not allocate semaphoresSymptom:ora-00600:internal error code, arguments: [Skgmbusy]SYMPTOM:SVR4 error no space left on deviceCause:unix kernel Not configured correctly fo
To modify the maximum number of Redis connections
You can modify the maxclients parameters in the redis.conf configuration file;
Or when you start the Redis.service service, add a parameter--maxclients 100000来 set the maximum number of connections limit
Redis-server--maxclients 100000-f/etc/redis.conf
Command line view maximum number of Redis connections
Difference
Knowledge Points:
1, the definition and use of various connections
Internal connections:
Equal connection, non-equal connection (often not spoken)
Natural connection, you find the same field, do not have to give two tables between the columns to compare. So-called nature (not commonly used)
Cross connection, after selection, the product of the Cartesian card. This is useful if you want to list al
Viewed the number of connections and the current number of connections
Copy Code code as follows:
Netstat-ant | grep $IP: 80 | Wc-l
Netstat-ant | grep $IP: 80 | grep EST | Wc-l
View IP access times
Copy Code code as follows:
Netstat-nat|grep ":" |awk ' {print $} ' |awk-f: ' {print $} ' | Sort| Uniq-c|sort-n
Linux command:
Copy Code code as follows:
**********************************/
As
CURSOR C_kill_sqls
Is SELECT ' alter system kill session ' | | s.sid| | ', ' | | s.serial#| | ' immediate ' SQLSTR from v$session s WHERE s.status= ' sniped ';
BEGIN
For V_sql in C_kill_sqls
LOOP
EXECUTE IMMEDIATE V_sql.sqlstr;
END LOOP;
END;
--add job to periodically clean out expired sessions
DECLARE jobnum Number: = 661;
), and full outer join (full outer join ).
All three return data rows that meet the connection condition and query condition, that is, internal connections. The differences are as follows:
The left Outer Join also returns the rows in the left table that do not meet the query conditions.
The right Outer Join also returns the data rows in the right table that do not meet the query conditions.
The Outer Join Operation also returns the rows in the left ta
Differences between three network connections in VMware and three network connections in vmware
1. Overview
After the virtual machine is installed, two virtual NICs, VMnet1 and VMnet8, are installed by default. VMnet1 is the host Nic and is used to connect to the network using the host method. VMnet8 is the NAT Nic, they are used to connect networks in NAT mode and their IP addresses are randomly generated.
ifname eno2 Master team0 (5) Red can not be added #teamdctl Team0 State (View status) Setup Runner:activebackup Ports Eno1 Link watches: Link Summary:up INSTANCE[LINK_WATCH_0]: Name:ethtool Link:up Eno2 Link watches: Link Summary:up INSTANCE[LINK_WATCH_0]: Name:ethtool Link:up Runner Active Port:eno1 #ping-I team0 192.168.0.254 (test) PING 192.168.0.254 (192.168.0.254) from 192.168.0.100 team0:56 (+) bytes of data. Bytes from 192.168.0.254:icmp_seq=10 ttl=64 time=1.08 ms Bytes from 192.168.0.25
Source: http://www.cnblogs.com/stli/archive/2010/11/10/1873212.htmlHard Links:1: The filename has a unique i-node representation, as the file name is a pointer variable, I-node is the object of the pointer refers to the content, which mainly includes the properties of the file and so on, as well as permissions.2: So hard link means to create a pointer-like thing, it still points to the original i-node. Obviously similar to smart pointers, as long as there is a file name (pointer), the I-node (ob
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.