BestHub
Sign in
Tag

select

0 views collected around this technical thread.

php中文网 Courses
php中文网 Courses
Jun 3, 2025 · Backend Development

Understanding Go's Concurrency Model: Goroutine, Channel, Select, WaitGroup, and Context

This article explains Go's lightweight concurrency model, covering Goroutine creation, Channel communication, Select multiplexing, synchronization with WaitGroup and Context, common concurrency patterns such as worker pools and pub/sub, and provides best‑practice recommendations for building high‑performance concurrent programs.

ContextGoWaitGroup
0 likes · 7 min read
Understanding Go's Concurrency Model: Goroutine, Channel, Select, WaitGroup, and Context
Tencent Technical Engineering
Tencent Technical Engineering
Apr 18, 2025 · Fundamentals

I/O Multiplexing in Linux: Detailed Explanation of select, poll, and epoll

Linux treats all I/O devices as files, enabling a single thread to monitor many descriptors via I/O multiplexing; while select and poll use linear scans and suffer size limits, epoll employs an event‑driven red‑black tree with edge‑triggered mode, offering scalable, high‑performance handling for thousands of concurrent connections.

I/O multiplexingLinuxepoll
0 likes · 30 min read
I/O Multiplexing in Linux: Detailed Explanation of select, poll, and epoll
FunTester
FunTester
Mar 6, 2025 · Backend Development

Common Mistakes with Go's select Statement and How to Fix Them

This article examines frequent errors when using Go's select statement—such as omitting a default case, misunderstanding case order, handling nil channels, missing timeout logic, and duplicate cases—explaining their impact, offering best‑practice guidance, and providing corrected code examples for each scenario.

Gobest practicesconcurrency
0 likes · 14 min read
Common Mistakes with Go's select Statement and How to Fix Them
Sanyou's Java Diary
Sanyou's Java Diary
Oct 9, 2023 · Backend Development

Unlocking Java NIO: How Select, Poll, and Epoll Revolutionize I/O Multiplexing

This article explains the evolution of I/O multiplexing in Java, covering the birth of multiplexing, the introduction of NIO with Selector, and detailed comparisons of select, poll, and epoll mechanisms, including their APIs, internal workings, and performance considerations for high‑concurrency network programming.

I/O multiplexingJavaNIO
0 likes · 44 min read
Unlocking Java NIO: How Select, Poll, and Epoll Revolutionize I/O Multiplexing
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 19, 2023 · Databases

How MySQL Expands the '*' in SELECT Statements: Source Code Analysis

This article explains how MySQL 8.0.32 expands the '*' in a SELECT statement into all table columns, detailing the lexical parsing, query preparation, and the functions Item_asterisk::itemize, Query_block::prepare, Query_block::setup_wild, and insert_fields through source‑code excerpts.

Database InternalsMySQLSQL
0 likes · 10 min read
How MySQL Expands the '*' in SELECT Statements: Source Code Analysis
Top Architect
Top Architect
Aug 30, 2022 · Backend Development

Understanding IO Multiplexing: select, poll, and epoll in Linux with Code Examples

This article provides an in‑depth explanation of Linux I/O multiplexing models—including select, poll, and epoll—detailing their mechanisms, advantages, limitations, and practical C code examples, while also covering edge‑triggered vs level‑triggered behavior and offering a complete epoll server implementation.

IO MultiplexingLinuxedge trigger
0 likes · 26 min read
Understanding IO Multiplexing: select, poll, and epoll in Linux with Code Examples
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 1, 2022 · Databases

MySQL SELECT Query Crash Analysis and Resolution

This article investigates a MySQL crash triggered by a specific SELECT statement, analyzes the stack trace and optimizer behavior that leads to an invalid memory access, and presents three practical solutions including disabling DuplicateWeedout, upgrading MySQL, and normalizing table character sets.

DuplicateWeedoutMySQLTroubleshooting
0 likes · 7 min read
MySQL SELECT Query Crash Analysis and Resolution
Architects' Tech Alliance
Architects' Tech Alliance
Jul 14, 2022 · Fundamentals

Understanding Synchronous vs Asynchronous, Blocking vs Non-Blocking, and Linux I/O Models

This article explains the concepts of synchronous and asynchronous execution, blocking and non‑blocking operations, user and kernel space, process switching, file descriptors, cache I/O, and compares various Linux I/O models such as blocking, non‑blocking, multiplexing, signal‑driven and asynchronous I/O, including the differences among select, poll and epoll.

IOLinuxasynchronous
0 likes · 14 min read
Understanding Synchronous vs Asynchronous, Blocking vs Non-Blocking, and Linux I/O Models
Python Programming Learning Circle
Python Programming Learning Circle
Dec 28, 2021 · Fundamentals

Understanding I/O Multiplexing in Python: select, poll, epoll, and selectors

This article explains how to use Python's socket module together with I/O multiplexing techniques such as select, poll, epoll, and the high‑level selectors module to build non‑blocking, scalable network servers that can handle multiple client connections concurrently.

I/O multiplexingSocketepoll
0 likes · 19 min read
Understanding I/O Multiplexing in Python: select, poll, epoll, and selectors
IT Architects Alliance
IT Architects Alliance
Nov 28, 2021 · Fundamentals

Understanding Synchronization, Blocking, and I/O Models in Linux

This article explains the concepts of synchronous vs. asynchronous execution, blocking vs. non‑blocking operations, user and kernel space, process switching, file descriptors, cache I/O, and compares various Linux I/O models such as select, poll, epoll, signal‑driven and asynchronous I/O.

IO modelsLinuxSynchronization
0 likes · 15 min read
Understanding Synchronization, Blocking, and I/O Models in Linux
Architects' Tech Alliance
Architects' Tech Alliance
Nov 26, 2021 · Fundamentals

Understanding Synchrony, Blocking, Process Switching, File Descriptors, and I/O Models (select, poll, epoll)

This article explains the differences between synchronous and asynchronous execution, blocking and non‑blocking operations, user and kernel space, process switching, file descriptors, cache I/O, and compares various I/O models—including blocking, non‑blocking, multiplexing, signal‑driven, and asynchronous—while highlighting the characteristics of select, poll, and epoll.

IO modelsblockingepoll
0 likes · 15 min read
Understanding Synchrony, Blocking, Process Switching, File Descriptors, and I/O Models (select, poll, epoll)
TAL Education Technology
TAL Education Technology
Nov 18, 2021 · Backend Development

Server‑Side Network Concurrency Models and Linux I/O Multiplexing (select, epoll)

This article explains fundamental concepts of streams, I/O operations, blocking and non‑blocking behavior, compares blocking wait with busy polling, and then details five practical solutions—including multithreading, select, and epoll—while presenting Linux epoll API usage, code examples, and a comprehensive overview of seven common server concurrency models.

IO MultiplexingLinuxServer Architecture
0 likes · 32 min read
Server‑Side Network Concurrency Models and Linux I/O Multiplexing (select, epoll)
Xueersi Online School Tech Team
Xueersi Online School Tech Team
Oct 29, 2021 · Backend Development

Server‑Side Network Concurrency Models and Linux I/O Multiplexing Techniques

This article explains server‑side network concurrency models, the fundamentals of streams and I/O operations, compares blocking and non‑blocking approaches, and details practical solutions such as multithreading, busy‑polling, select and epoll with code examples and performance analysis.

IO MultiplexingLinuxbackend development
0 likes · 30 min read
Server‑Side Network Concurrency Models and Linux I/O Multiplexing Techniques
Laravel Tech Community
Laravel Tech Community
Sep 7, 2021 · Databases

Handling Backslashes in MySQL INSERT and SELECT Statements

This article explains how MySQL treats backslashes as escape characters in INSERT and SELECT queries, demonstrates the effect of different numbers of backslashes through practical tests, and clarifies the double‑escaping required when using LIKE patterns.

DatabaseEscapeINSERT
0 likes · 6 min read
Handling Backslashes in MySQL INSERT and SELECT Statements
Selected Java Interview Questions
Selected Java Interview Questions
May 13, 2021 · Databases

Why Using SELECT * Is Inefficient in MySQL and How Indexes Can Improve Query Performance

This article explains the hidden costs of using SELECT * in MySQL—such as extra data transfer, increased I/O, and loss of covering‑index optimization—while detailing how proper column selection and composite indexes can dramatically boost query efficiency.

Database OptimizationIndexesMySQL
0 likes · 9 min read
Why Using SELECT * Is Inefficient in MySQL and How Indexes Can Improve Query Performance
Architect's Tech Stack
Architect's Tech Stack
Apr 14, 2021 · Databases

Why Using SELECT * Is Inefficient in MySQL and How to Optimize Queries

This article explains the multiple reasons why SELECT * slows down MySQL queries—including extra parsing, unnecessary data transfer, increased I/O, and loss of covering index optimization—while also covering index fundamentals, composite indexes, and practical tips for writing efficient SELECT statements.

IndexesMySQLQuery Optimization
0 likes · 9 min read
Why Using SELECT * Is Inefficient in MySQL and How to Optimize Queries
Java Captain
Java Captain
Jan 19, 2021 · Databases

Why Using SELECT * Is Inefficient in MySQL and How Proper Indexing Improves Performance

The article explains why SELECT * slows down MySQL queries by increasing parsing cost, network traffic, and preventing index covering, and demonstrates how explicit column selection and well‑designed composite indexes can dramatically reduce I/O and improve query speed.

Index OptimizationMySQLSQL
0 likes · 10 min read
Why Using SELECT * Is Inefficient in MySQL and How Proper Indexing Improves Performance
Laravel Tech Community
Laravel Tech Community
Dec 1, 2020 · Databases

Why Using SELECT * Is Inefficient in MySQL and How Indexes Can Improve Query Performance

This article explains the hidden costs of using SELECT * in MySQL queries, explores how unnecessary columns, large data types, and loss of covering‑index opportunities degrade performance, and shows how composite indexes and proper indexing strategies can dramatically speed up data retrieval.

Database OptimizationIndexingMySQL
0 likes · 10 min read
Why Using SELECT * Is Inefficient in MySQL and How Indexes Can Improve Query Performance