Raymond Ops
Raymond Ops
Oct 6, 2025 · Databases

Beyond CRUD: Unlock Hidden MySQL Features and Optimization Tricks

This article dives deep into MySQL beyond basic CRUD, covering remote user creation, permission grants, communication protocols like TCP/IP, named pipes, shared memory, Unix sockets, and advanced query optimization techniques including index usage, ORDER BY, and LIMIT offset strategies.

Database OptimizationMySQLQuery Performance
0 likes · 16 min read
Beyond CRUD: Unlock Hidden MySQL Features and Optimization Tricks
MaGe Linux Operations
MaGe Linux Operations
Apr 12, 2025 · Databases

Master MySQL Remote Connections and Query Optimization: Tips & Tricks

This article explains how to create and grant MySQL users for remote access, describes client‑server communication methods such as TCP/IP, named pipes, shared memory, and Unix sockets, and provides detailed guidance on index usage, common pitfalls, and performance‑friendly techniques for query optimization and large OFFSET LIMIT handling.

IndexingMySQLQuery Optimization
0 likes · 17 min read
Master MySQL Remote Connections and Query Optimization: Tips & Tricks