MySQL uses indexes to improve query performance
MySQL index is a data structure (InnoDB is B+ tree), which exists to efficiently find the desired data and improve query performance. Just like the...
Read More
Tag: mysql
MYSQL > select * from ‘MYSQL’
December 7, 2023
by Derek Armstrong
No Comments
MySQL database provides built-in functions, including mathematical functions, string functions, date and time functions, aggregation functions, conditional judgment functions, etc. These built-in functions can help...
Read More
“MySQL series” storage engine InnoDB structure and principle in-depth analysis
December 7, 2023
by Henry Anderson
No Comments
Connection layer 2. Service layer 3. Engine layer 4. Storage layer Compared to other databases, MySQL storage engine is a plug-in storage engine architecture. Separate...
Read More
MySQL data migration stuff
December 7, 2023
by Nitara Biswas
No Comments
In our daily work, we often encounter data migration requirements, such as migrating a table, a library, or an instance. Different migration schemes may be...
Read More
What is COLLATE in MYSQL?
December 7, 2023
by Nicola Frost
No Comments
We can read most of the fields, but today's topic is the COLLATE keyword. What does utf8_unicoDE_CI mean after this value? Use this topic to...
Read More
Paging queries for performance optimization
December 7, 2023
by Dale Bishop
No Comments
Most of my fellow developers and DBAs are very, very familiar with paging queries, paging through posts and searching for items. Then the problem comes,...
Read More
Suggest collection for future reference! MySQL common error code description
December 7, 2023
by Shannon Bradley
No Comments
Let me show you some examples of error analysis and solutions. 1.ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/data
Read More
How can you use InnoDB well without understanding InnoDB architecture?
December 7, 2023
by Anthony Peterson
No Comments
Introduction The previous article explained MySQL architecture, today explains MySQL's most mainstream storage engine InnoDB architecture. InnoDB logical storage units are divided into table Spaces,...
Read More
Check whether the Mysql database suddenly becomes slow
December 7, 2023
by Jennifer Mitchell
No Comments
At first, I got feedback from the system that was slow. I didn't locate the problem point to the database and checked whether the service...
Read More
Locks set by different SQL statements in InnoDB
December 7, 2023
by 丁怡安
No Comments
A lock read, an UPDATE or DELETE generally sets the record to be locked on each index record scanned during SQL statement processing. It does...
Read More
Learn more about Mysql indexes
December 7, 2023
by James Tucker
No Comments
The indexes in the database are intended to improve query efficiency and will be like the contents of a dictionary. Once we understand how indexing...
Read More
How to copy a table
December 7, 2023
by Kenneth Bruce
No Comments
MySQL > replicate a table in MySQL > replicate a table in MySQL > replicate a table in MySQL > replicate a table in MySQL...
Read More
Mysql > select count()
December 7, 2023
by Ms. Jennifer Byrne
No Comments
The only difference between t1_NULL and T2_not_NULL when creating a Mysql table is Column1 or Column2. what's better for disk space and
Read More
The MySQL_ transaction
December 6, 2023
by Bhavin Thaman
No Comments
MySQL transactions are mainly used to: process data with large operations and high complexity. For example, to delete a user, the information associated with the...
Read More
I thought I knew a lot about Mysql indexes until I met ali’s interviewer
December 6, 2023
by Joel Monroe
No Comments
Many of you are familiar with the MySQL Index, which is a data structure that helps MySQL obtain data efficiently. Because index is the focus...
Read More
Error occurred during connection after Linux mysql installation
December 6, 2023
by Stephen Shepard
No Comments
"Reference" https://blog.csdn.net/llliuhuiii/article/details/108808567https://www.jianshu.com/p/276d59cbc529
Read More
High performance index optimization strategy (7) : index and table maintenance
December 6, 2023
by Rati Bajaj
No Comments
After table creation and index creation with appropriate data types, the work is not done - you need to maintain tables and indexes to ensure...
Read More
MySQL > update MySQL
December 6, 2023
by Caleb Christiansen
No Comments
Recently, I executed a DML statement in an online operation. I thought it was safe, but the application replied that there was no update and...
Read More
Meituan interviewer: What happens when Java goes from compilation to execution?
December 6, 2023
by Cheryl Flores
No Comments
Interviewer: Starting with the basics, how do you understand that Java is a "cross-platform" language, meaning "compiled once, run everywhere"? Candidate: It makes sense because...
Read More
Take a look at what MySQL data looks like on disk…
December 6, 2023
by 彭家豪
No Comments
MySQL > select * from B+tree; select * from B+tree; In this article, I talked about the data structure B+tree and the working principle of...
Read More
SQL optimization for MySQL
December 6, 2023
by Margaret Bryant
No Comments
Performance Metrics QPSTPSRT Problem source Slow log, configure parameters (MySQL5.7) tcpDump&Wireshark Monitoring alarms such as SLA alarms on interfaces TP99 Analysis slow Where performance profiling...
Read More
Docker Compose Compose is used to construct primary/secondary replication instances of MySQL database
December 6, 2023
by 梁信宏
No Comments
It is only used in the development environment or to learn the master/slave replication configuration because the master/slave instances are running on a single machine....
Read More
Advanced edition (DAY09)-MySQL index optimization and query optimization, index invalidation
December 6, 2023
by Ivana Saha
No Comments
MySQL index index optimization and query optimization, failure Reference links: https://www.bilibili.com/video/BV1iq4y1u7vj 1, MySQL optimization can outline what are the dimensions of database tuning? Jane said
Read More
Ali: I know what I’m talking about
December 6, 2023
by Badal Saran
No Comments
As one of the most popular relational database management systems, the importance of MySQL does not need me to say more, and it is almost...
Read More
The MySQL database to realize distributed lock | | optimistic lock compare and swap (CAS)
December 6, 2023
by Yashvi Jaggi
No Comments
In the case of a single machine, we can encounter similar situations, such as locking when multiple threads need to access a shared resource. In...
Read More
Database engineers often meet with test questions
December 6, 2023
by Richard Copeland
No Comments
Do database engineers often meet test questions (articles reprinted in zorbyte) field) for all records of the day? The SendTime field is datetime and contains...
Read More
MySQL > alter table associative query;
December 6, 2023
by 李飛
No Comments
MySQL > alter table associative query; Many high-performance applications decompose associative queries. Simply, you can perform a single table query on each table and then...
Read More
Mysql-join details
December 6, 2023
by Leslie Harmon
No Comments
A complete SQL statement is broken into clauses that generate a virtual table (VT), but only the last virtual table is returned as a result....
Read More
What happens when InnoDB runs out of autoincrement keys and row_id?
December 6, 2023
by Kaia Cole-Brown
No Comments
Table T contains an index column C1 with the AUTO_INCREMENT attribute added. Let's start by inserting a record into the table: obviously, the increment column...
Read More
Why does a unique index in MySQL cause a deadlock?
December 6, 2023
by 程詩涵
No Comments
A unique index name is created, which means that the student table can only have one student with the same name. (1) Null values are...
Read More