In the last post, we walked through the basic concept, data structures, and supported query types of database indexes. Today, I will continue to share strategies for good indexes and high query performance. Please bear in mind that you must practice ...
I will tell you a fact that Most of the hard issues come from databases when your system grows. The bigger your system, the harder your database issues. Index, schema design, partition, and replication,... are important techniques to work with databa...
Whenever I need to implement a new feature, I typically start by researching available solutions on Google. Then I will experiment with one or more solutions to select the best one. However, after several months, I might forget how to implement that ...
Today I will continue to share my note about 3 topics: Replication, Table partitioning, and Scaling with MySQL. You could read Part 1 here: High Performance in MySQL - Part 1 Notes: if you have read High Performance in MySQL book, you could realize t...
MySQL is an open-source relational database management system and is one of the most common databases. Everyone uses MySQL and me too. But whether we are using it correctly and optimally. Today I will share my experience and what I learned in 3 main ...
