Harvey Doan articles - 6 total
![Lessons from the Trenches: Indexing a 200M Row Table in MySQL [MySQL part 2]](https://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F9xbnc23yis1cj3oh7kpa.png)
Lessons from the Trenches: Indexing a 200M Row Table in MySQL [MySQL part 2]
TL;DR Slow queries? Check your indexes first. Use EXPLAIN and the slow query log to guide indexing...
![The Power of MySQL Indexes: A Comprehensive Guide [MySQL part 1]](https://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F4rm5xq4hfn8wtzt7kot6.png)
The Power of MySQL Indexes: A Comprehensive Guide [MySQL part 1]
Indexes are essential tools in MySQL that significantly enhance query performance. By allowing the...
Chuẩn Bị Phỏng Vấn Dành Cho Các Bạn Sinh Viên Sắp Tốt Nghiệp Hoặc Fresher Đang Đi Xin Việc!
Phỏng vấn xin việc không chỉ là thử thách, mà còn là cơ hội để bạn thể hiện năng lực và chinh phục...
🚀 Building an MCP Server Go Package in 2 Hours - A Journey of Innovation & Passion
GitHub Repo: github.com/FreePeak/db-mcp-server 🔥 The Challenge: Dream Big,...
Mastering the AI Prompt: A Software Engineer’s Guide to Thinking With AI
As a software engineer in 2025, AI has become an indispensable tool in your toolkit. Yet many of us...
AI vs. Developers: How to Future-Proof Your Software Engineering Career in 2025
Modern software development increasingly involves collaboration with AI tools In recent years, the...