We share common IT technologies (Java, Web, SQL, etc.) and practical applications of emerging software development techniques. New articles are posted daily. Follow IT Xianyu to stay ahead in tech. The IT Xianyu series is being regularly updated.
The article explains how to determine the optimal size of a database connection pool by analyzing performance tests, presenting a simple formula based on CPU cores and disk count, and demonstrating that a much smaller pool can dramatically improve response times for high‑concurrency workloads.
The article outlines ten frequent errors that Java programmers encounter when writing SQL—ranging from misunderstanding NULL handling to misusing UNION, pagination, and batch inserts—and provides practical solutions to improve correctness, performance, and maintainability of database interactions.
This article provides a detailed tutorial on using MyBatis-Plus in Java, covering setup, entity and mapper definitions, CRUD operations, annotations, condition builders, pagination, AR mode, logical deletion, automatic field filling, optimistic locking, performance analysis, multi‑tenant support, dynamic table names, configuration options, and code generation.
This article explains two methods for keeping MySQL data in sync with a Redis cache—using MySQL triggers combined with a UDF function and parsing MySQL binlog via Alibaba's Canal—detailing their principles, implementation steps, advantages, limitations, and practical deployment considerations.
The article explains why multithreaded inserts can be faster than single‑threaded ones in MySQL, breaks down the time spent on each step of an insert operation, and presents practical techniques such as using PreparedStatement, multi‑value INSERT statements, and transaction batching to dramatically reduce insertion time.
This article explains how to use Maven profiles to manage multiple Spring Boot environments, configure the maven‑assembly‑plugin to create a zip release containing the jar, configuration files and a custom shell script, and then deploy and control the application on Linux using the provided shenniu_publish.sh tool.
The article investigates the Alibaba Java development guideline that forbids joining more than three tables by designing MySQL and Oracle experiments, generating massive test data, measuring query performance, analyzing index usage, and concluding why the rule exists and when it can be relaxed.
This article provides a step‑by‑step guide on integrating the open‑source Dataway tool with a Spring Boot application, covering dependency inclusion, configuration of Dataway and data sources, module setup, enabling Hasor, and creating and testing API endpoints without writing custom code.
This article provides a comprehensive tutorial on building cross‑platform desktop applications with Electron, covering environment preparation, installation of Node, Vue‑CLI and Electron, project creation, directory layout, main and renderer processes, and detailed examples such as a NetEase Cloud Music client and a QQ Music player.
This article presents a complete Java implementation of a parking system, detailing user and admin login, random parking slot allocation, time‑based fee calculation, and management functions, accompanied by full source code for entities, services, and client interaction.
