Technical Articles

Articles tagged with #Backend

Sort by:

Showing 3 articles

Optimizing MySQL Queries for Billion-Scale Datasets: A 3-Level Architecture Approach

Master the art of querying 5 billion records with millisecond response times. Learn three powerful optimization levels: precision indexing with composite keys, hot-cold data separation, and horizontal database sharding. A complete guide to thinking like a database architect.

#MySQL #Database #Performance #Optimization #Scalability #Architecture #Backend #Sharding #Indexing

CodeGram Team Jan 15, 2025

1885 Read More

Backend Development

MySQL Performance Tuning: 6 Configuration Parameters That Matter More Than Redis

Before rushing to add caching layers, optimize your MySQL configuration first. This practical guide shows how tuning 6 critical parameters can help a 4-core 16GB MySQL server handle 3,000-5,000 QPS, along with essential SQL optimization techniques.

#MySQL #Database #Performance #Optimization #Backend

CodeGram Team Jan 14, 2025

881 Read More

Backend Development

Finding Keys in Redis with 100 Million Keys: An Elegant Approach

When your Redis instance holds 100 million keys and you need to extract 100,000 with a specific prefix, using the wrong command can bring your entire system to a halt. Learn the elegant, production-safe approach to key scanning in Redis.

#Redis #Database #Performance #Backend

CodeGram Team Jan 14, 2025

1117 Read More

Popular Tags

#Performance #Backend #Database #Optimization #MySQL #Architecture #AI #Efficiency #HTTP/3 #kubernetes

Technical Articles

Optimizing MySQL Queries for Billion-Scale Datasets: A 3-Level Architecture Approach

MySQL Performance Tuning: 6 Configuration Parameters That Matter More Than Redis

Finding Keys in Redis with 100 Million Keys: An Elegant Approach

Categories

Popular Tags

Search Articles