Kobayashi x Illustrated computer basics
Click : Illustrated Computer Fundamentals Online Reading
All articles on this site are original articles written by my public account: Xiaolin coding. The content includes diagrams of computer networks, operating systems, computer components, and databases. There are a total of 1,000 pictures + 500,000 words. It breaks down the obscure basic computer knowledge and makes it easier for the world to understand. The difficult eight-part essay (just say it, don’t take it seriously, haha)!
I used to be troubled by those obscure and difficult basic computer knowledge, but after reading one book after another and watching one video after another, I finally got to know these "guys". I thought that there must be some friends in the world who have the same troubles as me, so I made up my mind to use illustrations + easy-to-understand explanations to help everyone understand. I used my spare time to output illustrated articles for two years. After a long time, this is the website we have today!
"Illustrated Network"
- introduce ?:
- Graphical Network Introduction
- Network basics ?
- What are the layers of the TCP/IP network model?
- What happens when you type a URL into a web page and display it?
- How does a Linux system send and receive network packets?
- HTTP article ?
- HTTP common interview questions
- How to optimize HTTP/1.1?
- HTTPS RSA handshake analysis
- HTTPS ECDHE handshake analysis
- How to optimize HTTPS?
- Where is the awesomeness of HTTP/2?
- HTTP/3 is coming
- Since there is HTTP protocol, why do we need RPC?
- Since there is HTTP protocol, why do we need WebSocket?
- TCP article ?
- TCP three-way handshake and four-way wave interview questions
- TCP retransmission, sliding window, flow control, congestion control
- TCP actual packet capture analysis
- TCP semi-connection queue and full-connection queue
- How to optimize TCP?
- How to understand that TCP is a byte stream-oriented protocol?
- Why does the initialization sequence number have to be different every time TCP establishes a connection?
- When and under what circumstances will SYN packets be discarded?
- What will happen if an out-of-order FIN packet is received in four waves?
- What happens after receiving SYN for a TCP connection in TIME_WAIT state?
- What is the difference between a TCP connection, a power outage at one end and a process crash?
- After unplugging the network cable, does the original TCP connection still exist?
- Why is tcp_tw_reuse turned off by default?
- Can TLS and TCP handshake at the same time in HTTPS?
- Are TCP Keepalive and HTTP Keep-Alive the same thing?
- What are the flaws of the TCP protocol?
- How to achieve reliable transmission based on UDP protocol?
- Can TCP and UDP use the same port?
- If the server does not listen and the client initiates connection establishment, what will happen?
- Can a TCP connection be established without accept?
- If the TCP protocol is used, will the data not be lost?
- Can TCP wave four times into three?
- How do TCP sequence numbers and acknowledgment numbers change?
- IP article ?
- IP basic knowledge Family Bucket
- How ping works
- If the Internet is disconnected, can I still ping 127.0.0.1?
- Learning experience ?
- How to learn computer network?
- Drawing experience sharing
"Graphic System"
- introduce ?:
- Graphical system introduction
- Hardware structure ?
- How does the CPU execute programs?
- Is disk tens of thousands times slower than memory?
- How to write code that makes the CPU run faster?
- CPU cache coherence
- How does the CPU perform tasks?
- What is a softirq?
- Why is 0.1 + 0.2 not equal to 0.3?
- Operating system structure ?
- Linux kernel vs Windows kernel
- Memory management ?
- Why do we need virtual memory?
- How does malloc allocate memory?
- What happens when the memory is full?
- What will happen if I apply for 8G memory on a machine with 4GB physical memory?
- How to avoid read-ahead invalidation and cache pollution problems?
- In-depth understanding of Linux virtual memory management
- In-depth understanding of Linux physical memory management
- Process management ?
- Basic knowledge of processes and threads
- What are the communication methods between processes?
- What should I do if there is a multi-thread conflict?
- How to avoid deadlock?
- What are pessimistic locks and optimistic locks?
- How many threads can a process create at most?
- If the thread crashes, will the process also crash?
- Scheduling algorithm ?
- Process scheduling/page replacement/disk scheduling algorithm
- File system ?
- File system family bucket
- When the process is writing a file, the process crashes. Will the written data be lost?
- Device management ?
- When the keyboard typed the letter A, what happened during the operating system?
- Network system ?
- What is zero copy?
- I/O multiplexing: select/poll/epoll
- High-performance network modes: Reactor and Proactor
- What is consistent hashing?
- Learning experience ?
- How to view network performance indicators?
- Drawing experience sharing
- Learning experience ?
- How to learn computer network?
- Drawing experience sharing
"MySQL Illustrated"
- introduce ?:
- Illustrated introduction to MySQL
- Basics ?:
- What happens during the execution of a select statement?
- How is a row of records stored in MySQL?
- Index ?
- Index common interview questions
- Looking at B+ trees from the perspective of data pages
- Why does MySQL use B+ trees as indexes?
- A single MySQL table should not exceed 2000W rows. Is it reliable?
- What are the index failures?
- If MySQL uses like "%x", will the index definitely become invalid?
- What is the difference between count(*) and count(1)? Which performs best?
- Business chapter ?
- How is transaction isolation level implemented?
- MySQL repeatable read isolation level, does it completely solve phantom reads?
- Lock chapter ?
- What locks does MySQL have?
- How does MySQL lock?
- If update does not add an index, the entire table will be locked.
- MySQL is deadlocked, what should I do?
- Byte interview: What lock was added to cause the deadlock?
- Diary ?
- MySQL logs: What are the uses of undo log, redo log, and binlog?
- Memory article ?
- Uncovering the Buffer Pool
"Illustrated Redis"
- Interview ?
- Redis common interview questions
- Data types ?
- Redis data types and application scenarios
- Illustration of Redis data structure
- Persistence ?
- How is AOF persistence implemented?
- How is RDB snapshot implemented?
- Functional article ?
- What is the difference between Redis expiration deletion policy and memory elimination policy?
- High availability ?
- How is master-slave replication implemented?
- Why are there sentinels?
- Cache article ?
- What is cache avalanche, breakdown, penetration?
- How do databases and caches ensure consistency?
? Learning experience
- Computer Basics Learning Route: Computer Basics Learning Books + Video Recommendations, Comprehensive and Clear.
- Internet school recruitment experience: Xiaolin Shenxian readers’ school recruitment and study experience are worth learning.
Illustration series PDF download
- Graphical Network + Graphical System PDF Download
Errata and questions
If you have any questions or find errors, you can ask questions or make corrections in the corresponding Issues, or you can leave a message at the bottom of the corresponding article on the Illustrated Computer Basics website.
If you like or are inspired by it, you are welcome to star, which is also an encouragement to the author.
Official account
The latest illustrated articles are first published on the official account, and it is highly recommended to pay attention! If you want to join the 100-person technical exchange group, scan the QR code below and reply "Join Group".
