DylanThe 3 Keys to Working RemotelyAfter working remotely with multiple teams over the past four years, I’ve learned a lot about remaining effective and contributing…May 28May 28
DylanMy 3 Step Process for Writing Clean CodeAfter writing code for over ten years, I’ve found a process that lends itself well to writing code and writing it well. These three simple…May 27May 27
Dylan23 Truths I Wish I Knew at 23One of the benefits of getting older is getting wiser. This is especially true for writers; we diligently record all our hard-earned…May 27May 27
DylaninLevel Up Codingcount(*) is so slow, what should I do?When developing a system, you may often need to count the number of rows in a table, such as the total number of all change records in a…Mar 14Mar 14
DylaninLevel Up CodingWhy is the table file size unchanged when half of the table data is deleted?Students often come to me and ask me, my database takes up too much space. I deleted half of the data in the largest table. Why is the size…Mar 14Mar 14
DylaninLevel Up CodingWhy does MySQL sometimes choose the wrong index?We introduced indexes before, and you already know that a table in MySQL can actually support multiple indexes. However, when you write an…Feb 251Feb 251
DylaninLevel Up CodingHow to index a string fieldNow, almost all systems support email login. How to establish a reasonable index on fields such as email is the issue we are going to…Feb 25Feb 25
DylaninLevel Up CodingHow to choose between an ordinary index and a unique index?In the previous basic article, I introduced you to the basic concepts of indexes. I believe you already understand the difference between…Feb 22Feb 22
DylaninLevel Up CodingAdvantages and disadvantages of row locks: How to reduce the impact of row locks on performance?In the previous article, I introduced you to MySQL’s global locks and table-level locks. Today we will talk about MySQL’s row locks.Feb 22Feb 22