"Separate inventory and separate table"? Selection and process should be careful, otherwise it will be out of control
Congratulations, your company has finally grown to a size where you need to consider high availability and even separate repositories and tables. But do you know what elements are needed to separate inventory and table? The spin-off process is complicated, plan ahead, don't wait for the actual start of all kinds of unexpected work, out of control. Below, scoping is done in JAVA and MySQL. Let's take a look at the level of sub - database sub - table. Create more... in the same project
MySQL performance optimization (3) : Understand indexing in depth
Indexes are critical for good database performance. Whenever database performance tuning is mentioned, the first thing that comes to mind is "index" to see if an index is added to the table. Especially when the amount of data in a table is increasing, the impact of indexes on performance is particularly significant. There is no index or when the data volume is small and the load is low
Take you into the new high availability solution of MySQL -MGR
This article introduces the basic principles, technical evolution and installation experience of MySQL Group Replication.
Why choose B + tree as storage engine index structure
In most of the introduction, explain the storage engine books or articles, we all default to read more write less disk storage engine is the USE of B + tree, and few people to analyze the choice of B + tree as the index structure behind, what kind of thinking and trade-offs?
Explain database transactions and isolation levels in detail
A transaction is a sequence of operations that are performed as a single logical unit of work and either all execute successfully or fail. Database things have four characteristics: atomicity, consistency, isolation, and durability, also known as ACID properties. Transaction processing ensures that data-oriented resources are not permanently updated unless all operations within the transaction unit complete successfully. Transactions are part of a database operation.
Understand the Kafka consumer group from the actual combat
Kafka as a beginner, need to grow up quickly, assume the responsibility of maintaining the company Kafka, Kafka learning, I follow the three step strategy: read Kafka related books from the perspective of operation and maintenance combat Kafka reading source code, systematic, refined master its implementation
MySql(3) MySql lock mechanism
Optimistic locking: Every time the data is read, it is not locked because it is not modified by others. Instead, it is updated to determine whether other people have updated the data during this period, using the version number mechanism. This can be done in the database by adding a version number field to the data table. The version number is read together when the data is read, and the version number is incremented by one each time the data is updated. When we update, determine the database table corresponding to the record...
SQL optimization - in
#### SQL (80s+) SELECT count(id) as id FROM task WHERE cid=100015 AND sid IN(112310,112316)
Here is SQL for all the basic queries you can think of and use! Based query all | SQL tutorial 2: comprehensive introduction
The process of using a SELECT statement to query and extract the necessary data is called a matching query or query. SELECT queries need to specify what to SELECT and from which (table) to SELECT.
Sp_who: KILL spID WITH STATUSONLY; KILL spID WITH STATUSONLY
How do I find blocking transactions in SQL Server? This can be done simply by using sp_WHO. Use KILL @@spid to abort the session and cancel the blocked transaction....