Hidden MySQL Tricks You Probably Missed

This article compiles a series of lesser‑known MySQL details—from case‑insensitive column names and fuzzy LIKE patterns to REPLACE INTO, INSERT … ON DUPLICATE KEY UPDATE, EXPLAIN usage, index length limits, replication methods, partitioning, slow‑query monitoring, binlog importance, advanced objects like views and stored procedures, and recommended client tools—helping developers avoid common pitfalls and write more efficient queries.

Database TipsReplicationSQL

0 likes · 7 min read

ITPUB

Apr 21, 2016 · Databases

13 MySQL Tips You Probably Missed: From Case Sensitivity to Binlog

This article highlights thirteen often‑overlooked MySQL details—including case‑insensitive column names, LIKE pattern rules, REPLACE and INSERT ON DUPLICATE KEY syntax, EXPLAIN usage, index limits, replication methods, partitioning, slow‑query logging, binlog, advanced objects, and useful client tools.

Database TipsReplicationSQL

0 likes · 7 min read

13 MySQL Tips You Probably Missed: From Case Sensitivity to Binlog

Art of Distributed System Architecture Design

Jul 17, 2015 · Databases

12 Essential MySQL Tips Every Database Developer Should Know

Discover twelve practical MySQL techniques—from avoiding dump file edits and tuning MyISAM block size to using EXPLAIN, query caching, and secure root password changes—that can boost performance, prevent data loss, and streamline database management for developers.

Database AdministrationDatabase TipsPerformance Optimization

0 likes · 8 min read

12 Essential MySQL Tips Every Database Developer Should Know