Dylan – Medium

Dylan

Dylan

BAT file introduction and creation

Introduction

1 min readJun 12, 2024

--

BAT file introduction and creation

--

Dylan

The 3 Keys to Working Remotely

After working remotely with multiple teams over the past four years, I’ve learned a lot about remaining effective and contributing…

5 min readMay 28, 2024

--

The 3 Keys to Working Remotely

--

Dylan

My 3 Step Process for Writing Clean Code

After 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…

3 min readMay 27, 2024

--

My 3 Step Process for Writing Clean Code

--

Dylan

23 Truths I Wish I Knew at 23

One of the benefits of getting older is getting wiser. This is especially true for writers; we diligently record all our hard-earned…

3 min readMay 27, 2024

--

23 Truths I Wish I Knew at 23

--

Dylan
in
Level Up Coding

count(*) 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…

11 min readMar 14, 2024

--

count(*) is so slow, what should I do?

--

Dylan
in
Level Up Coding

Why 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…

10 min readMar 14, 2024

--

Why is the table file size unchanged when half of the table data is deleted?

--

Dylan
in
Level Up Coding

Why 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…

13 min readFeb 25, 2024

--

1

Why does MySQL sometimes choose the wrong index?

--

1

Dylan
in
Level Up Coding

How to index a string field

Now, almost all systems support email login. How to establish a reasonable index on fields such as email is the issue we are going to…

9 min readFeb 25, 2024

--

How to index a string field

--

Dylan
in
Level Up Coding

How 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…

10 min readFeb 22, 2024

--

How to choose between an ordinary index and a unique index?

--

Dylan
in
Level Up Coding

Advantages 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.

8 min readFeb 22, 2024

--

Advantages and disadvantages of row locks: How to reduce the impact of row locks on performance?

--

Dylan

Dylan

A passionate creator in coding, tech, and AI. In this fast-paced digital era, I'm an explorer, chasing the latest trends and innovations.

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams