Tag:affair

  • Detailed introduction of MySQL advanced theoretical knowledge

    Time:2020-11-30

    List of articles 1、 Database partition, table, database and partition Hello, everyone. I’m Xiao Liu. I haven’t seen you for a long time. I miss you very much. Xiao Liu is here to take you to learn the basic knowledge of sub database and sub table 1.1 bottleneck of single database The larger the amount […]

  • 【SQLite3】 4_ Basic SQL operations

    Time:2020-11-30

    Example: char insert_sql[128] = {0}; for (int i=0; i<10000; ++i) { sprintf(insert_sql, “insert into bindtest values(%d, %d)”, i, i*100); ret = sqlite3_exec(ppdb, insert_sql, NULL, NULL, &errmsg); if (ret != SQLITE_OK) { printf(“insert fail\n”); break; } sqlite3_free(errmsg); } SQLite executes every statement in a transaction and supports read and write transactions. Applications can only read data […]

  • What you should know about MySQL lock classification

    Time:2020-11-29

    Locks in MySQL Lock is a means to solve the resource competition in the concurrent environment. Optimistic concurrency control, pessimistic concurrency control and multi version concurrency control are the main technical means of database concurrency control (see my previous article for details), and MySQL lock is one of them. There are many kinds of locks […]

  • Implementation of AOP control transaction by JDK and cglib dynamic proxy

    Time:2020-11-29

    Implementation of AOP control transaction by JDK and cglib dynamic proxy preface Or follow upCustom implementation of IOC container in XML In this instance, there is no transaction operation, and the transaction consistency in a thread operation cannot be maintained; @Override public void transfer(String fromCardNo, String toCardNo, int money) throws Exception { Account from = […]

  • Realm — the best solution to simplify the real write transaction in IOS

    Time:2020-11-28

    Realm — the best solution to simplify the real write transaction in IOS(other platforms can also learn from this idea) Direct use Goto –> Github Start reading Solve the pain point Pain point 1, duplicate code, originally add, delete, modify check general two or three lines, submit accounted for 2 lines, basically a half more […]

  • How to delete the database without running away

    Time:2020-11-27

    We all know the basic characteristics of transactions, acid. Transactions are persistent. Once a transaction is committed, the changes to the data in the database are permanent. Even in the case of database system failure, the transaction commit operation will not be lost. I often hear which programmer has run away from deleting the database. […]

  • Summary after reading MySQL

    Time:2020-11-26

    Series articles: Summary after reading MySQL Summary after reading MySQL (2) Summary after reading MySQL (3) How is a SQL query executed? Schematic diagram of MySQL basic architecture MySQL is divided into server layer and storage engine layer The server layer includes connector, query cache, analyzer, optimizer, executor, etc., covering most of the core service […]

  • Interview summary: 10 common interview questions and answers about “MySQL affairs”

    Time:2020-11-25

    The article is constantly updated every week. It’s not easy to create original articles. It’s my greatest affirmation that “Sanlian” let more people see it. WeChat can search the public for the first time to read the official account of “backend Technology School” (usually one to two updates earlier than blogs). Learning the relational database […]

  • Summary of computer foundation for 2021 autumn recruitment interview database, redis

    Time:2020-11-24

    Series of articles: Summary of computer foundation in autumn 2021 interview algorithm, data structure, design pattern, Linux Summary of computer foundation in autumn 2021 interview – Java foundation, JVM, spring framework Summary of computer foundation for 2021 autumn recruitment interview database, redis Summary of computer foundation for 2021 autumn recruitment interview – operating system Summary […]

  • Multi version concurrency control of MySQL (mvcc)

    Time:2020-11-24

    Multi version concurrency control of MySQL (mvcc) 1、 What is concurrent version control Multi version concurrency controlThe full English name of technology isMultiversion Concurrency Control, abbreviated asMVCC。 Multi version concurrency control (mvcc)Concurrency control is achieved by saving a snapshot of data at a certain point in time. That is to say, no matter how long […]

  • Deeply understand the implementation principle of transaction isolation level in MySQL

    Time:2020-11-23

    preface When it comes to database transactions, it’s easy to get a lot of transaction related knowledge in your mind, such as the acid characteristics of transactions, isolation levels, and problems to be solved (dirty read, non repeatable read, phantom read), etc., but few people really know how these features of transactions are implemented and […]