This article introduces how to view and use Binary logs. Viewing can be done with the mysql and mysqlbinlog commands as described below. Restore using...
Management Node (MGM) : This type of node is used to manage other nodes in MySQLCluster, such as providing configuration data, stopping nodes, running backups,...
Mysql database is a widely used relational database. Its small size, multi-processor support, open source and free features make it especially popular in small and...
The usage of a CallableStatement is very similar to that of a PreparedStatement, except that a CallableStatement can be used to call a stored procedure....
Atomicity: All operations in a transaction, either complete or not complete, do not end at some intermediate stage. If a transaction fails during execution, it...
2: Row_drop_tables_for_mysql_in_BACKGROUND does not wait for dirty pages to be flushed. If innodb_buffer_pool_dump_at_shutdown is set, buffer dump is not required.
A transaction is a series of rigorous operations in an application, all of which must complete successfully or all changes made in each operation will...
From the beginning of JDBC, you can learn how to use PrepareStatement to precompile SQL without having to re-parse and compile SQL for each Statement....
This article on lock, transaction, concurrency control to do a summary, read a lot of articles on the Internet, description is very inaccurate. If there...
Abstract: Many DBA students often encounter the problem of real-time synchronization from one database to another. Homogeneous data is relatively easy, but heterogeneous data, multiple...
MySQL logical architecture analysis reference links: https://www.bilibili.com/video/BV1iq4y1u7vj 1.1 1, logical architecture analysis, server client request processing Mysql is a typical C/S frame in the first...
Why does a query SQL statement execute slowly? What index was used during execution? What is the general execution flow of SQL when multi-table query?...
The basic idea of multi-version concurrency control is that each transaction generates a new version of data, and different versions are selected to read the...