Step by step, slowly. Each database has a microservice on the upper layer. The service layer records the mapping relationship between "business library" and "database...
Java DataBase Connectivity is a set of interfaces defined by Sun that can operate all relational databases. Various DataBase vendors implement this interface, and then...
Data preparation 50W data tables are inserted into the database through the program: time_LONG, time_TIMESTAMP, and time_date are generated when the usersDAO layer interface test...
Record the problems encountered in using mysql and some configurations. Slow query logs, binlog logs, query methods with ineffective indexes, and so on.
Transaction propagation is introduced in order to solve the problem of transaction support for methods in nested execution. This paper lists three common transaction propagation...
Everybody is good! Just stepped into the learning journey of MySQL, in order to conveniently operate MySQL database, we need to learn the composition of...
A recent business scenario involves recursive queries to a database. Our company uses Oracle, as we all know, Oracle has its own recursive query function,...
With the continuous development of Internet technology, MySQL related ecology is becoming more and more perfect, and more and more tools emerge. Some companies and...
Through the alarm, we can basically locate the database and database table of the birth and death lock. Let's start with the database information involved...
For advanced development, where we often write complex SQL, it is important to know the basics of indexing to avoid writing inefficient SQL. With these...
At present, almost many large websites and applications are distributed deployment, data consistency in distributed scenarios has always been an important topic. Distributed CAP theory...
Under what circumstances will the index fail? Small white: "interview officer, light point ask, skull ache!" Interviewer: "Talk about index failure scenarios!"