MySQL is favored by developers for its ease of learning and high availability. Almost all of its high availability architectures rely directly on Binlog. Binlog...
This article is the second advanced content of MYSQL, learning the basis of this article is the knowledge seeker published before, especially "MYSQL architecture introduction"...
Objective: In order to solve the problem that establishing database connection consumes a lot of resources and time, improve the performance. The Connection object creates...
This article introduces the implementation of MVCC in mysql in detail, introduces implicit columns, read VEiw, undo log. The introduction of MVCC makes it possible...
Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". This article also participates in the "Digitalstar Project"...
Python-mysql has the oldest qualification, the core is built by C language, the interface is refined, the performance is the best, the disadvantage is that...
MySQL strong people "lock" difficult "die keke MySQL series 3" recently database often appear below deadlock situation, by these two kinds of circumstances set out...
Today I'm going to share with you MySQL performance optimization, which is the last part of MySQL's big Data development guide. Performance optimization for Liu,...
Recently, I found an interesting problem in optimizing the company's CRM reporting system. Once the query scope exceeds a certain period of time, the execution...
Canal is an open source project developed in Java by Alibaba. The main purpose is to provide incremental data subscription and consumption based on MySQL...
How to Obtain the SQL with performance problems Obtain the SQL with performance problems through user feedback Obtain the SQL with performance problems By slowly...
As a front-end developer, gradually contact the development of back-end (node), business needs gradually accumulated, node layer from the data aggregation layer also gradually have...
Small knowledge, big challenge! This article is participating in the creation activity of "Essential Tips for Programmers". This article has participated in the "Digitalstar Project"...
Database, as the core basic component, is the object that needs to be protected. Any careless online operation may cause a serious database failure, resulting...
Limit on the SELECT column after GROUPBY Standard SQL specifies that only the following three items can be written in the SELECT clause when querying...
Interviewer: Why don't you talk about how you tune MySQL? Candidate: Wow, that's a big proposition... In my opinion, for developers, the focus of MySQL...
This article has participated in the "Digitalstar Project" and won a creative gift package to challenge the creative incentive money. In this article, I go...
Use Explain Extended Select... To show the columns that are filtered. This article is based on the 5.5.54 version. 1. Describe how MySQL performs the...
This article introduces the binary log, binlog. The binary log of the MySQL database contains all DDL and DML statements (except select, show, etc.). The...
What are transactions like in MYSQL? Four features, SQL commands for tuning transactions, and problems in concurrent transactions. How to set the isolation level in...