Tag: mysql

The back-end

Distributed transactions related to Mysql database and table

February 4, 2024

by Katie Lambert

No Comments

In this article, we will introduce how to solve the problem of "distributed transaction problem". In this article, we will introduce the problem of "distributed...

Read More

The back-end

MySQL8 Architecture Chapter 5- Storage Engine (Key InnoDB feature)

February 4, 2024

by Andrew Wheeler

No Comments

A storage engine is a table type whose function is to receive instructions from the top and then extract or write data from the table....

Read More

The back-end

SQL > alter database log redo log

February 4, 2024

by Gary Ingram

No Comments

The redo log format, composition, and flush policy, and the redo log writing process; Redo log file Log file format and checkpoint mechanism

Read More

The back-end

MySQL lock analysis into depth

February 4, 2024

by John Morrison-Kennedy

No Comments

A MySQL lock means that only one thread can access a resource at a time. In addition to the use of traditional computing resources (such...

Read More

reading

How to automatically generate Dtos from dynamic SQL code

February 4, 2024

by Lisa Young

No Comments

This article explained how to automatically generate Dtos from dynamic SQL code.

Read More

The back-end

A careless index creates a duplicate

February 4, 2024

by Christopher Foster

No Comments

I believe that no one will deliberately create duplicate redundant index, many duplicate and redundant index is inadvertently created, today songo and everyone to clarify...

Read More

The back-end

Normal index and unique index, can’t tell the difference

February 4, 2024

by Hayley Price

No Comments

Learn when to use a normal index and when to use a unique index. Distinguish the applicable scenarios of the two indexes, and learn the...

Read More

The back-end

Index design for MySQL performance optimization

February 4, 2024

by Lakshay Bala

No Comments

The last article to partners about SQL query performance optimization related skills, a good query SQL is inseparable from a reasonable index design. This small...

Read More

The back-end

Mysql locks and transactions

February 4, 2024

by 徐馨儀

No Comments

I. Lock 1. Shared and exclusive lock A. Shared lock B. Exclusive lock C. gapLock and Next key lock 2. Multiple-version-concurrency control (MVCC) is a...

Read More

The back-end

Isolation level of MySQL transactions

February 4, 2024

by Stephanie Hansen

No Comments

When it comes to transactions, you're no stranger to dealing with databases. The most common application of transaction is money transfer. For example, the company...

Read More

reading

MySQL optimization for performance optimization

February 4, 2024

by Kathleen Malone

No Comments

1. The purpose of database optimization page 5xx error due to database connection timeout due to slow query caused the page cannot be loaded due...

Read More

The back-end

MySQL8 Transaction Chapter 1- Transaction basics

February 4, 2024

by Norman Roberts

No Comments

Transaction ACID state flow, show and hide transactions, transaction isolation level and corresponding MySQL transaction isolation level for example verification.

Read More

The back-end

MySQL fuzzy query no longer needs like+%!

February 4, 2024

by Judith Smith-Potter

No Comments

We all know that InnoDB's use of "%xx" in fuzzy queries results in index invalidation, but this is sometimes the case. There are many other...

Read More

The back-end

MYSQL (Engine, isolation level, implementation principles)

February 4, 2024

by 王欣怡

No Comments

Storage engine is the biggest characteristic of MySQL apart from other database management system, we know that relational database data, there is a list of...

Read More

The back-end

MySQL base _10 stored procedures and functions

February 4, 2024

by Wendy Thomas-Wade

No Comments

1.1 Understanding the Meaning: The English name of a Stored Procedure is Stored Procedure. The idea is simple: a package of pre-compiled SQL statements.

Read More

The back-end

MySQL base _02 operator

February 4, 2024

by Stephen Godfrey-Curtis

No Comments

1. Arithmetic operator: + - * / div % mod in SQL, + has no join function, represents the addition operation. At this point, the...

Read More

The back-end

Distributed global unique IDS for Mysql database and table related problems

February 4, 2024

by James Brown

No Comments

Mysql 解决 Mysql 解决 Mysql 解决 Mysql 解决 Mysql 解决 Mysql 解决 Mysql 解决 Mysql 解决

Read More

The back-end

MySQL index drop down

February 4, 2024

by Sahil Sarma

No Comments

Today I will share with you the MySQL index push down. Index Condition Pushdown Index Condition Pushdown Index Condition Pushdown The index pushed down is...

Read More

The back-end

How does MySQL implement trillion-level data storage?

February 4, 2024

by Shannon Contreras

No Comments

The industry has basic requirements for high availability of systems, which can be summarized as follows. There are no single points of problem in the...

Read More

The back-end

MySQL master/slave replication | manual rip MySQL | line interview

February 4, 2024

by David Myers

No Comments

Introduction This is the third article in the MySQL series about using bin log to implement master/slave replication. Master/slave replication is also the cornerstone of...

Read More

The back-end

Advanced (Day11)- Overview of the MySql lock mechanism

February 4, 2024

by Yasmin Tiwari

No Comments

A lock is a mechanism by which a computer coordinates concurrent access to a resource by multiple processes or threads. In the program development, there...

Read More

The back-end

What is COLLATE used for in MySQL?

February 4, 2024

by Ojas Shan

No Comments

COLLATE Affects the ORDER of the ORDER BY statement, the results filtered BY the greater than or less sign in the WHERE condition, and the...

Read More

The back-end

Mybatis uses useGeneratedKeys to obtain autoincrement primary keys

February 4, 2024

by Anvi Sahota

No Comments

We often use useGenerateKeys to return auto-increment primary keys to avoid additional queries. On duplicate key update is often used for insertOrUpdate to avoid query...

Read More

The back-end

Mysql: Chapter 14 _MySQL stored procedures and functions

February 4, 2024

by Donald Coleman

No Comments

Stored Procedures and stored Functions MySQL supports stored procedures and functions from version 5.0. Stored procedures and functions can encapsulate complex SQL logic together. Applications...

Read More

The back-end

MySQL8 Indexing and Tuning chapter 7- Index optimization and query optimization

February 4, 2024

by Rebecca Hunt

No Comments

Index failure cases, JOIN optimization, subquery optimization, sorting optimization, GROUP BY optimization, paging query optimization, overriding index priority, string add index, index push down, other...

Read More

The back-end

The impact of the “only_full_group_by” SQL mode on GROUP BY and handling

February 4, 2024

by 王宜庭

No Comments

Sql_mode =only_full_group_by (sql_mode= only_full_group_BY) (sql_mode= only_full_group_BY

Read More

The back-end

Mysql batch update data operation

February 4, 2024

by Anna Pedersen

No Comments

UPDATE data in mysql batch using ON DUPLICATE KEY UPDATE. Replace into. UPDATE data in mysql batch using temporary tables

Read More

The back-end

MySQL > restore data by bin log

February 4, 2024

by Jason Dillon

No Comments

As the second article in the series of "Rip MySQL", today we introduce the MySQL binary log (bin log) for data recovery function, and with...

Read More

The back-end

Mysql InnoDB locks

February 4, 2024

by Donna Sixtus

No Comments

There are many types of locks, which are rarely encountered by developers, but we must be aware of them so that problems can be solved...

Read More

The back-end

Daily data volume tens of millions of levels, MySQL, TiDB two storage solutions landing comparison

February 4, 2024

by William Turner

No Comments

GaeaAD advertising Matching System (GaeaAD) is used to support the real-time advertising system of Gaia Interactive Entertainment on the whole platform. Advertising data needs to...

Read More