MySQL Performance Pitfall: Querying a String Column with a Number
When working with MySQL, it’s common to have columns stored as strings (VARCHAR, CHAR, TEXT).But…
All topics
Database
MySQL
Tips
All topics
Architecture & Design
Database
MySQL
NodeJS
Others
Tips
Avoid This Mistake with Bulk Insert in Node.js and MySQL
Last week, I ran into a serious performance issue while working on a bulk insert…
All topics
Database
MySQL
Others
Tips
Optimizing GROUP BY in MySQL: Insights from Real-Life Query Analysis
My current query: SELECT eod.date, SUM(eod.stable_price) AS sumStablePrice FROM item_eod eod WHERE eod.date >= CURRENT_DATE…
All topics
Database
MySQL
Enhancing Text Search in MySQL: A Comparison of SOUNDEX and Full-Text Search
In many applications, efficient text search capabilities are critical for delivering fast and relevant results…
All topics
Architecture & Design
Database
MySQL
Buffer Cache Hit in MySQL: What It Is and Why It Matters
The InnoDB Buffer Pool in MySQL is essentially a cache that stores frequently accessed data…
All topics
Database
MySQL
MySQL Indexes: Boosting Query Performance with Column Order
In MySQL, the order of columns in a composite index (an index that spans multiple…