MySQL open_file_limit configuration mist
Guidance:
Author: Wei Xinping, a student in the 5th MySQL battle class of Zhishutang and a student in the 10th MySQL optimization class, is currently a teaching assistant.
1. Official Interpretation
The maximum number of file descriptors the mysqld process can use, and the actual value of mysql will be the largest of the following four values ...
Posted by MarineX69 on Wed, 25 Dec 2019 18:02:04 -0800
Making "wheels" by yourself -- several methods commonly used in python
Because of the content of the work, we often need some python scripts. Over time, we found that some methods are often used, so we edited some common, popular and general methods by ourselves. I'm not talented, but I also hope to contribute to open source.
Finally, code HA is attached;
1, At present, only five methods are summarized in this do ...
Posted by Nommy on Wed, 25 Dec 2019 01:32:27 -0800
IO stream - BIO, NIO, AIO
IO, often collaborative I/O, is the abbreviation of Input/Output, that is, Input/Output. At present, there are three types of IO coexisting. They are BIO, NIO and AIO. Before we get to know IO, let's look at the concepts.
Related concepts
Flow oriented and buffer oriented
The first big difference between Java IO and NIO is that IO is strea ...
Posted by derwert on Mon, 23 Dec 2019 05:05:12 -0800
File (directory) attribute, file permission, special permission (mandatory bit, adventure bit)
1. View file properties:
ls -l filename
- rw-rw-r-- 1 kiosk kiosk 0 Oct 2 17:05 file
[1] [2] [3] [4] [5] [6] [7] [8]
//notes:
[1]file type
- # Common documents
d # catalog
s # Socket socket, the open interface of a progra ...
Posted by XeroXer on Sun, 22 Dec 2019 08:48:20 -0800
The usage of I/Of multiplexing select in network programming
The usage of select in network programming
select use flow chart
Lines of code to be added in network programming and their significance
routine
References and blogs
Note: This paper does not explain the select function, related parameters and structure
select use flow chart
Create with Rapha ë l 2.2.0 define select ...
Posted by hdpt00 on Fri, 20 Dec 2019 07:11:20 -0800
mysql -- implementation of multiple instances based on yum source
Implement multiple instances based on yum source
This experiment implements three examples, using port 330633073308 respectively
1. Install MariaDB server, yum
#yum install mariadb-server
2. Create a directory for each instance
#mkdir /data/mysql/{3306,3307,3308}/{etc,data,socket,log,bin,pid} -pv
3. Permission to modify ...
Posted by NottaGuru on Thu, 19 Dec 2019 11:01:25 -0800
Multi instance implementation of mysql database under Linux
Preparation environment:
centos7 install Yum install MariaDB server
Plan and implement the directory structure of multiple instances
Port: 33063307, 3308
The folder where each instance stores the database / data / MySQL {330633073308}
/data/mysql/3306/{etc,soket,log,data,pid,bin}
Create the data folder required by mysql u ...
Posted by coco777 on Wed, 18 Dec 2019 08:55:32 -0800
The difference between Socket and datagram Socket
In short:
The tcp connection used by Socket needs to be connected before sending data.
For the UDP connection used by datagram socket, the client does not need to connect the data first and can send it directly to the specified server.
DatagramSocket:
Client send (send data directly, no connection process):
protected void ...
Posted by Beauford on Wed, 18 Dec 2019 07:54:16 -0800
Introduction to python tool library dubbo: accessing dubbo service through telnet interface
brief introduction
After dubbo service is released, we can use telnet command to debug and manage. For more information, see Telnet Command Reference Manual
telnet call example:
$ telnet 172.17.103.110 9097
Trying 172.17.103.110...
Connected to 172.17.103.110.
Escape character is '^]'.
dubbo>ls com.oppo.sso.service.onekey.IOne ...
Posted by Elephant on Tue, 17 Dec 2019 08:39:32 -0800
2. Sticking and unpacking of netty (I)
Netty sticking and unpacking
1. What is unpacking and sticking
(1) introduction to unpacking and sticking
TCP is a "flow" protocol. The so-called flow is a string of data without boundary. You can think of the running water in the river, which is connected in one piece, and there is no boundary between them. The bottom layer of TCP d ...
Posted by pagegen on Mon, 16 Dec 2019 11:46:30 -0800