Tag: Slow Query
2 articles
MySQL Slow Query Analysis and Optimization Guide
Slow query log, mysqldumpslow, EXPLAIN analysis, common optimization solutions. This article provides in-depth analysis of principles and practical applications.
MongoDB Slow Query Analysis & Index Tuning
MongoDB slow query analysis through built-in Profiler, set db.setProfilingLevel(1, m) to record slow queries. EXPLAIN analysis helps identify performance bottlenecks and optimize queries.