[MySQL] standardized installation tutorial
Guidance:This article mainly introduces the installation steps of MySQL 5.7.23 binary installation of CentOS system, and the installation process of other versions is similar.
1. Preparation
Uninstall old MySQL
View the rpm package
rpm -qa|grep mysql if available
Find mysql residue package, delete if any, and ignore if no
find / -name ...
Posted by patsfans on Sun, 08 Dec 2019 13:12:06 -0800
udp protocol, process (synchronous, asynchronous)
udp protocol and process
I. udp protocol
QQ chat room
#- sever
import socket
#Socket.sock? Dgram - > UPD protocol
sever = socket.socket(type=socket.SOCK_DGRAM)
#The server needs to bind an address to let others know where you are
sever.bind(
('127.0.0.1', 9002)
)
while True:
#Send data to the server's user address
data, ad ...
Posted by damnedbee on Fri, 06 Dec 2019 17:46:35 -0800
CentOS MySQL create database - encoding settings
Create database
mysqladmin -h '192.168.2.233' -u root -p create namc;
View newly created database encoding
mysql> SHOW VARIABLES LIKE 'character%'
-> ;
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_s ...
Posted by disconne on Fri, 06 Dec 2019 10:59:26 -0800
tcp socket communication optimization and troubleshooting under Linux
tcp socket communication optimization and troubleshooting under Linux
@Date 2018.12.09
I. optimization
1. TPC receiving window
Problem: when the receiving window queue of TCP is blocked - > the sender continues to send - > the receiver loses - > the sender retransmits - > the network becomes bad
Solution: the receiver tells the sen ...
Posted by googlehunter on Fri, 06 Dec 2019 08:29:03 -0800
python foundation - TCP protocol and UDP protocol
TCP is a streaming protocol, UDP is a packet protocol.
TCP and UDP are transport layer protocols in OSI model. TCP provides reliable communication transmission, while UDP is often used to let the broadcast and details control the application's communication transmission.
Summary of differences between TCP and UDP:
TCP
UDP
Is it connected? ...
Posted by lovelyvik293 on Fri, 06 Dec 2019 06:36:08 -0800
Thinking about readLine() method in Socket request
Background:
Today, I found a problem when simulating socket request
//Test code
public static void http(String path) throws Exception {
URL url = new URL(path);
final String host = url.getHost();
//If the port is specified, get the port, otherwise - 1
int port = url.getPort();
int defaultPort = url.getDefaultPo ...
Posted by shoppingspree on Thu, 05 Dec 2019 23:02:07 -0800
Source code implementation of Netty master slave Reactor multithreading mode
Netty -- source code implementation of master-slave Reactor multithreading mode
Overview
What is EventLoopGroup?
EventLoopGroup is a container for storing EventLoop, and it should have the function of thread pool.
graph BT;
EventLoopGroup --> EventExecutorGroup;
EventExecutorGroup --> ScheduledExecutorService;
Because EventLoopGr ...
Posted by wmhop on Thu, 05 Dec 2019 20:44:52 -0800
Java web learning journey - java socket programming (request and response principle)
Request step (client)
Create socket connection through host and port
Get the output stream in socket and write the request data to the output stream
Get the input stream in the socket and read the response data in the input stream
Response steps (server)
Establish listening port and wait for TCP connection request
Get the ...
Posted by briansol on Thu, 05 Dec 2019 20:42:39 -0800
python foundation network programming part02
TCP protocol
TCP is a transmission control protocol, which establishes a two-way channel.
Three handshakes to establish a connection
The client sends a connection request to the server
The server receives the request and returns the confirmation information to the client, and sends the connection request to the client
The client receives the r ...
Posted by WolfRage on Thu, 05 Dec 2019 16:15:43 -0800
Reread the Handler source with your hands and chat about those you don't know.
As you should all know, Android's messaging mechanism is based on Handler.Remember that I read several blogs a year ago and thought I knew Handler, Looper and MessageQueue.However, in fact, slowly during the process of looking at the source code, you will find that the contents of Handler are more than this, such as synchronization barrier, b ...
Posted by miancu on Tue, 03 Dec 2019 16:11:42 -0800