Tag: mysql
| Mysql based on GTID master-slave synchronization principle
December 26, 2023
by 席佳蓉
No Comments
A previous article has successfully implemented 'GTID' based 'Mysql' master master synchronization. But the fundamental things are not very well understood, such as what is'...
Read More
【MySQL】 redoredo -binlog Archive log
December 26, 2023
by Saksham Bumb
No Comments
This is my second day in the Redo log Challenge. I do a log called redo log. I do a log called binlog
Read More
DataGrip Slow data query
December 26, 2023
by Nicole Bradshaw
No Comments
Each query has a long wait for "Processing" and then "Querying", which is slow. Find the Properties. Find Introspection in Options and cancel Auto sync....
Read More
Can you talk about MVCC for mysql? | mysql series (8)
December 26, 2023
by Martyn Stevenson
No Comments
This question is often asked in interviews. Did you know it? As you read this article, you will learn: What isolation level is used for...
Read More
Possible causes of the MySQL index failure
December 26, 2023
by 李懿
No Comments
Index failure this question should be the premise of the index is not used, or not fully used, the following is a list of common...
Read More
MySQL > select * from B+Tree; How is InnoDB’s data store file different from MyISAM’s?
December 26, 2023
by Amani Chander
No Comments
The title of this article is a real question I met in the interview process. An Internet crowd-funding company asked the interviewer the first question...
Read More
Select an appropriate data type for the MySQL database
December 26, 2023
by 鄧美琪
No Comments
MySQL supports a large number of data types, and choosing the right type is critical to performance. This article introduces the data type selection principles...
Read More
What is an index? Why does it go faster if you index it?
December 26, 2023
by Sandra Priest
No Comments
Have you ever encountered too slow query, execute a SQL need a few seconds, or even more than ten, tens of seconds of time, at...
Read More
How mysql InnoDB works
December 26, 2023
by Debra Sampson
No Comments
If you have ever used mysql database, innoDB, its storage engine, must be familiar. As we all know, before mysql8, the default storage engine was...
Read More
MySQL Advanced features (6) : Analysis of the advantages and disadvantages of stored procedures
December 26, 2023
by 寧靜怡
No Comments
For some stable services, if the network requests between the database server and the database server are too large or occupy a large amount of...
Read More
“MySQL series” analysis of Sql execution time and query execution plan (with database and 10 million data)
December 26, 2023
by William Gray
No Comments
Query the SQL execution time and view the SQL execution plan. I found that the amount of data was too small and the time gap...
Read More
MySQL > Double Check Lock (DCL) cause deadlock
December 26, 2023
by Russell Bibi-Burke
No Comments
A selectOrInsert scenario for MySQL was recently designed in a project. In order to improve performance, I adopted the idea of DCL (Double Check Lock)....
Read More
MySQL > select * from ‘MySQL’;
December 26, 2023
by Dr. Gillian Clark
No Comments
Mathematical functions ABS(x) : returns the absolute value of x BIN(x) : returns the binary value of x PI() : returns PI π, with 6...
Read More
MySQL Replication (part 1)
December 26, 2023
by Billy Turner
No Comments
This article will focus specifically on how to leverage MySQL's Replication capabilities to improve system scalability.
Read More
21 Good habits for writing SQL in Mysql
December 26, 2023
by Nichole Pope MD
No Comments
1 write SQL first explain view execution plan (SQL performance optimization) daily development write SQL, try to develop this good habit ah: after writing SQL,...
Read More
The MySQL kill command is used
December 26, 2023
by Amber Spencer
No Comments
In Mysql, each connection is run on a separate thread. You can use the KILL ProcessList_id statement. To terminate statement execution. KILL CONNECTION, KILL is...
Read More
Mysql high availability and library and table
December 26, 2023
by Melissa Jenkins
No Comments
The amount of user requests is too large because the TPS, memory and IO of a single server are limited. Solution: Spread requests across multiple...
Read More
Mysql database migration (small data volume)
December 26, 2023
by Bradley Stanley
No Comments
--add-drop-database Add a drop database statement before each database is created. --master-data =1: add the change master information (only LSN information but not IP address...
Read More
MySQL Redo Log Redo Log
December 26, 2023
by Tia Moore
No Comments
It's redone as the name suggests. For the purpose of recovery operations to be repeated in the event of a database accident. A Redo Log...
Read More
MySQL Next-key lock bug not fixed
December 26, 2023
by Mr. Sean Lane
No Comments
MySQL fixed the next key bug in MySQL 8.0.18. Now look at the next key bug in MySQL 8.0.18 and see how to reproduce this...
Read More
MySQL index cover index, union index, and index push down
December 26, 2023
by 馬雅惠
No Comments
If I execute a statement, I will search the tree several times. If I execute a statement, I will search the tree several times. I...
Read More
Mysql int int
December 26, 2023
by 彭家豪
No Comments
Int (1); int(10); I did not answer well at that time, and I did not pay attention to it, so I made a note of...
Read More
Mysql optimistic and pessimistic locks
December 26, 2023
by Molly Sellers
No Comments
1. Optimistic locking is implemented by adding version or updated_at to the table field and changing version+1 or up after each update
Read More
Centos8 reshipment MySQL8
December 26, 2023
by Karen Wallace
No Comments
This is the 7th day that I participate in more text challenge, more text challenge see reloading these two words, know how much helpless ~...
Read More
MySQL master-slave replication (master/slave
December 26, 2023
by Melissa Miranda
No Comments
In our usual work, the most used database is MySQL. With the increase of business, if only a server is overloaded, it is easy to...
Read More
MySQL > alter table migration database
December 26, 2023
by Wendy Daniels
No Comments
One of our customers was having a MySQL problem with a large table with over 2 billion records and counting. If you don't replace the...
Read More
Important: InnoDB insert buffer
December 26, 2023
by Leanne Russell
No Comments
Today our topic is Insert Buffer, because InnoDB engine's underlying data storage structure is B+ tree, and for indexes we have clustered indexes and non-clustered...
Read More
MySQL Tech Insider –InnoDB Storage Engine
December 26, 2023
by Paul Martin
No Comments
A deadlock problem was reported in an online business module. Detailed analysis click here to locate related issues. Read the book "MySQL technology insider --InnoDB...
Read More
MySQL index analysis and optimization
December 26, 2023
by Alex Hall
No Comments
MySQL provides an EXPLAIN command that analyzes SELECT statements and outputs details of SELECT execution for developers to optimize. Indicates the type of the query....
Read More