Master slave replication of a database that has been running for a period of time

Master slave replication of a database that has been running for a period of time Preface: a few days ago, the master-slave replication of MySQL database that has been running for a period of time and has not opened bin log was made. Hereby, the detailed operation steps and instructions are recorded. Note that this synchronization does not use ...

Posted by virtuexru on Wed, 11 May 2022 23:14:11 +0300

Development oriented memory debugging artifact, how to use ASAN to detect memory leakage, stack overflow and other problems

The original content of GreatSQL community cannot be used without authorization. Please contact Xiaobian and indicate the source for reprint.[toc]introduceFirst of all, let's introduce it Sanitizer The project is an open source project produced by Google. The project includes memory and thread error detection tools such as ASAN, LSAN, MSAN and ...

Posted by realnsleo on Wed, 11 May 2022 07:47:07 +0300

MySQL common statements

MySQL common instructions Modify table structure service mysql start #Start the MySQL service. mysql55 is the server name specified when installing the MySQL server net start mysql55 #Stop mysql service net stop mysql55 Create database #Create database Set character set Set collation create database Database name character set gb2 ...

Posted by a94060 on Wed, 11 May 2022 00:09:32 +0300

Modify table structure

Learning objectives: 1. Modify field related information 2. Modify constraints 3. Modify other options 4. Modify table name Learning content: Create table Syntax: create table if not exists table name( Field type constraints, ... [constraint information]# last line information without comma )engine=InnoDB[MyIASM] default charset=utf8; For examp ...

Posted by aiikcmo on Tue, 10 May 2022 23:39:45 +0300

1.3 MySQL multi table & foreign key & database design, multi table relationship, multi table query, internal and external connection query, sub query, three paradigms and anti three paradigms

catalogue MySQL multi table & foreign key & database design 1.1 multi table description 1.2 disadvantages of single meter 1.2.1 data preparation 1.2.2 single table problems 1.3 solutions 1.3.1 two tables are designed Table 1.3.2 relationship analysis 1.3.3 problems in multi meter design 1.4 foreign key constraints 1.4.1 what ...

Posted by roy on Tue, 10 May 2022 18:19:19 +0300

MyBatis learning notes (including SSM integration and reverse engineering)

1. Introduction to mybatis 1.1 what is MyBatis? MyBatis official website MyBatis is an excellent persistence layer framework that supports common SQL queries, stored procedures and advanced mapping. MyBatis eliminates almost all the manual setting of JDBC code and parameters and the retrieval of result sets. MyBatis uses simple XML or ann ...

Posted by kyme on Tue, 10 May 2022 16:23:56 +0300

Data warehouse 001 - full backup of time zipper

Demo in mysql Full backup of zipper during mysql demonstration: 1, Demonstrate the first and second full backups. 1. First, there is the business system table. //Enter the test database. use test //Create business table user_data and give the initial business data. create table user_data( userid int, ustate varchar(4) ); insert into user_da ...

Posted by Mark.P.W on Tue, 10 May 2022 06:57:38 +0300

Zabbix 5.0.0beta1 experience 1- MySQL monitoring

It has been several months since the last article was published. Recently, there are many things to resume work, which has been delayed for some time. Look back at zabbix5 The 0beta 1 version has been released! The functions of the new version are described below. 5.0 has not been officially released at present. Do not use it in production envi ...

Posted by waldo on Tue, 10 May 2022 02:30:16 +0300

My JDBC learning path

JDBC What is JDBC JDBC (Java database connectivity) is a Java API used to execute SQL statements. It provides unified access to a variety of relational databases. It is composed of a group of classes and interfaces written in Java language Connect database Connect before mysql8 Database driver name: com mysql. jdbc. Driver url connection: ...

Posted by mrhinman on Mon, 09 May 2022 06:28:50 +0300

MySQL index as I understand it

Hello, nice to meet you. Starting from September, I decided to launch the goal of "weekly blog": publish at least one blog every week, which can be a variety of source code analysis and study, or a problem encountered in recording work. After a period of aimless study, I found that it didn't seem to be very useful. I forgot what I had ...

Posted by kid_drew on Mon, 09 May 2022 00:21:49 +0300