Data type analysis of Redis source code - DICT

Data type analysis of Redis source code - DICT The current Redis analysis version is 6.2, which should be noted. DICT, dictionary data structure, is essentially a hash table. Related documents mainly include dict.h and dict.c. Infrastructure dictEntry is a hash node and a key value pair, in which the value adopts the union v. it can be seen ...

Added by rUmX on Wed, 27 Oct 2021 06:25:39 +0300

Transfer case of JDBC control transaction

Transfer case of JDBC control transaction Preface This exercise is from a black horse programmer class case 1. Title requirements Zhangngsan and lisi each have 1,000 yuan. Please transfer 500 yuan from zhangsan to lisiAnd try if you add an error code, will the transfer change? (The answer appears in the code as a comment) 🥑 Quick ...

Added by veenasv on Tue, 26 Oct 2021 20:04:06 +0300

MongoDB native statement exercise: official website example

preface As mentioned earlier, after practicing for a long time, I found that the official brought its own demo, followed by the official website again, and learned more operators. Then I'll see if I have time to practice some more Learning method: before running those topics with specific values, you can imagine the approximate values in ...

Added by gioahmad on Tue, 26 Oct 2021 18:41:00 +0300

Distributed database is based on sharding JDBC sub database and sub table

1, Introduction shardingsphere is a product of Apache, mainly including Sharding JDBC and Sharding Proxy. The former can be regarded as an enhanced version of JDBC, and the latter is an independent proxy system without coupling in the code. In this regard, it is very similar to Mycat 2, What did ShardingJDBC do for me? When using Shardi ...

Added by richardandrewle on Tue, 26 Oct 2021 15:26:47 +0300

Database mysql project practice

catalogue Actions to be implemented:   mysql database image storage read_image or write_image mysql database image storage mysql_write mysql database image storage mysql_read   Completed code demonstration and results reflection Actions to be implemented:   Prepare a picture and read it.xxx,xxx, mysql_write_imagemysql ...

Added by parboy on Tue, 26 Oct 2021 13:32:28 +0300

Damon database job usage

1. Function introduction Using Dameng database job management tool, you can complete fixed daily work such as regularly backing up the database and regularly generating data statistical reports. These repetitive tasks can be completed automatically, which is convenient for database administrators to improve work efficiency. DM's operating syst ...

Added by jreed2132 on Tue, 26 Oct 2021 08:20:35 +0300

Linux installs Mycat1.6.7.6 and realizes simple configuration of Mysql database read-write separation

1. Introduction to Mycat A completely open source large database cluster for enterprise application developmentSupport transaction, ACID and enhanced database that can replace MySQLAn enterprise database that can be regarded as a MySQL Cluster is used to replace the expensive Oracle clusterA new SQL Server integrating memory cache technology, ...

Added by Matty999555 on Tue, 26 Oct 2021 03:25:01 +0300

MyBatis study notes_ day02 L2 cache principle

L2 cache principle 1. L2 cache 1.1 definitions L2 cache is also called application level cache. Different from L1 cache, its scope is the whole application and can be used across threads. Therefore, L2 cache has a higher hit rate and is suitable for caching some data with less modification. When it comes to L2 cache, let's briefly talk ...

Added by eideticmnemonic on Sun, 24 Oct 2021 14:22:20 +0300

Mysql trigger field bidirectional update

Business scenario: balance shared by different business systems, hjmallind_user and ims_cjdc_user two tables have different balance fields, but share the balance value. Trigger definition: DROP TRIGGER IF EXISTS `test-up_ds_wallet`; CREATE  TRIGGER `test-up_ds_wallet` AFTER UPDATE ON `ims_cjdc_user`      FOR EACH ROW      BEGIN         DECLAR ...

Added by jokkis on Sat, 23 Oct 2021 09:04:00 +0300

Advanced MySQL database

1. Services 1.1 concept of transaction Transaction: a transaction consists of one or more SQL statements in a single unit, in which each MySQL statement is interdependent. The whole single cell is an inseparable whole. If an SQL statement in the cell fails or generates an error, the whole cell will be rolled back. All affected data will be re ...

Added by s0me0ne on Sat, 23 Oct 2021 06:36:09 +0300