IT Xianyu
Jan 19, 2022 · Databases
Understanding Linux Memory Usage, Buff/Cache Cleanup, and SQL Join Optimization
This article explains how to inspect and clear Linux memory buffers, details the information shown by the free command, and provides a comprehensive overview of SQL join types, their performance impact, and optimization techniques such as indexing, join buffer tuning, and algorithm choices.
BuffCacheDatabase PerformanceJoin Optimization
0 likes · 7 min read