Technology sharing | MySQL uses MariaDB audit plug-in

Author: Yao yuanFocus on Oracle and MySQL databases for many years, Oracle 10G and 12C OCM, MySQL 5.6, 5.7, 8.0 OCP. Now Dingjia technology serves as a consultant to improve database training and technical support services for colleagues and customers.Source: original contribution*It is produced by aikesheng open source community. The original ...

Posted by BrianWald on Wed, 18 May 2022 22:57:05 +0300

Applet development learning record - get user openid

Main function: the applet obtains the user's openid as the user's unique identification code. Function Description: the reason to obtain the openid of the user is that it has unique identification and is used as the unique identification to identify the user. With a unique ID, we can know who used our applet. The rules formulated by wechat mak ...

Posted by jlp09550 on Wed, 18 May 2022 15:48:25 +0300

[Java+JDBC+MySQL] use Java to operate JDBC and connect to MySQL database

1. Import jar package Copy the jar to the lib directory, right-click the jar package - [Add as Library] and import it into the project 2 operation steps (addition, connection, language, execution and interpretation) 2.1 loading registration driver Register the Driver through the following statement. The principle is that this statement will Cl ...

Posted by Pr0digy on Wed, 18 May 2022 08:08:51 +0300

Software testing environment -- install MySQL on Linux (detailed), fine sorting

1, Foreword Several common ways to install software on Linux: Source code compilationDecompress the compressed package (generally tar.gz)Compiled installation package (RPM, DPKG, etc.)Online installation (YUM, APT, etc.) The convenience of the above methods increases in turn, but the versatility decreases in turn Delete the development ...

Posted by parkej60 on Wed, 18 May 2022 02:16:56 +0300

Debezium specifies binlog location to initialize exception troubleshooting and repair

Abnormal phenomenon Recently, the project needs to use Debezium to specify the binlog location to read data. When FileDatabaseHistory is configured to save offset, an unrecognized schema exception will appear. 14:52:18.237 [blc-9.135.12.10:3307] ERROR io.debezium.connector.mysql.MySqlStreamingChangeEventSource - Encountered change event ' ...

Posted by jasonscherer on Wed, 18 May 2022 01:40:00 +0300

Cache mechanism under Mybatis concurrency

Cache mechanism under Mybatis concurrency Mybatis level 1 and level 2 cache Level 1 cache: It is enabled by default. For multiple identical operations in a session, only the first time will go to the database to query, and then directly go to the cache to get the data! 1. Query the record for the first time, and write the queried data into th ...

Posted by miramichiphoto on Mon, 16 May 2022 18:49:30 +0300

Xiaozha's learning notes python day54 [MySql] (2020-09-09 18:12)

Database DB The database itself supports concurrent network operations Using database to add, delete, check and modify data is more efficient than storing data in files Each folder is a database Database management system DBMS: sqlserver MySQL Oracle install Download: https://downloads.mysql.com/archives/community/ Select the version and ...

Posted by osiris1603 on Mon, 16 May 2022 17:00:40 +0300

Read MySQL index structure and query optimization

Review the previous: Learn the explain tool of MySQL (at the same time, it is emphasized again that these articles on MySQL are based on version 5.7, and the relevant conclusions and conclusions are not necessarily applicable to other versions) MySQL official documents( https://dev.mysql.com/doc/refman/5.7/en/optimization-indexes.html )There is ...

Posted by jamkelvl on Mon, 16 May 2022 11:45:34 +0300

Issue 17 - what is MySQL database? It's enough to read this dry article!

preface Why study MySQL? Because MySQL is one of the most popular relational database management systems, MySQL is the best software in web applications. The sql language used by MySQL is the most commonly used standardized language for accessing databases. Rest assured, friends who read this issue are suitable for: website development, softwar ...

Posted by keigowei on Mon, 16 May 2022 11:38:44 +0300

Go launched http2 0 request flow analysis (later) - header compression

Reading suggestions This is HTTP 2 0 series, the author recommends reading in the following order: HTTP request in Go -- http1 1 request process analysis Go launched http2 0 request process analysis (previous) Go launched http2 0 request flow analysis (Part 2) -- data frame & flow control review In the previous article (* http2clientco ...

Posted by brandone on Mon, 16 May 2022 09:17:40 +0300