Mysql tutorial - binary distribution installation

Environmental Science Server: alicloud server Operating system: CentOS 6.8 mysql version: 5.5 Memory: 2G download Address: https://dev.mysql.com/downloads/mysql/5.5.html deploy Download and unzip mysql 1> cd /usr/local/ 2> mkdir mysql5.5 3> rz [Select localmysql-5.5.59-linux-glibc2.12-x86_64.tar.gz] ...

Posted on Wed, 01 Apr 2020 19:09:54 -0700 by behzad

Mysql commands commonly used in operation and maintenance

1. Check which libraries are available > show databases; 2. View the table of a library > use db1; show tables; 3. View the fields of the table > desc tb1; 4. View the statement of table creation > show create table tb1; 5. Which user is it currently > select user(); 6. View the current library > select databa ...

Posted on Wed, 01 Apr 2020 09:42:57 -0700 by phil88

MySQL MyISAM and Innodb table generation sequence

Catalog background Analysis test conclusion background The application side needs to generate the sequential increasing sequence to make the pipeline sequence number. The schemes are as follows: 1. redis /MySQL SEQUENCE engine generates the sequence; 2. Mysam table replace into mode in MySQL; 3. innodb table insert... On duplicate key mode ...

Posted on Wed, 01 Apr 2020 09:08:18 -0700 by anybody99

20.20 alarm system main script 20.21 alarm system configuration file 20.22 alarm system monitoring project

20.20 main script of alarm system Define the main script in / usr/local/sbin/ cd /usr/local/sbin/ mkdir mon cd mon mkdir bin conf shares log mail Main script under bin cd bin vim main.sh • main.sh content #!/bin/bash #Written by aming. # Whether to send mail export send=1 //All monitored items will be emailed. export means that all v ...

Posted on Tue, 31 Mar 2020 15:52:13 -0700 by sxiix

Slow query log of MySQL optimization

Overview of slow query log The so-called slow query log is used to record SQL statements with response time exceeding the set threshold in MySQL. By turning on the slow query switch, MySQL will record SQL with response time greater than the threshold in the log for performance analysis. The slow query log option is off by default. If you want t ...

Posted on Tue, 31 Mar 2020 14:44:01 -0700 by misteraven

3.21 study database design of python operation database authority system

pip3 download pymysql Python operation Mysql #pypi inside pip3 install pymysql 2. Use pymysql def yanga11ang(): #------------------1. Execute SQL--------------------------- import pymysql # Create connection conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='654321', db='t1',charset='utf8') # ...

Posted on Tue, 31 Mar 2020 07:04:26 -0700 by Errant_Shadow

Invalid ThinkPHP multi table rollback

Today, for the first time, we used multi table rollback and encountered a pit. The error code is as follows: try{ $Member = D("Member"); $Member->startTrans(); $member_condition['id'] = 11641; $member_data['id'] = 10000; $member_res = $Member->where($member_condition)->save($member_data); if ...

Posted on Tue, 31 Mar 2020 00:19:34 -0700 by abhijeet

On the use of dtle in data transmission

Author: Ma yingle A member of the research and development team of akesheng, responsible for the testing of mysql middleware and database management platform. Good at finding fault (testing technology enthusiasts), welcome to try dtle~ Source: original contribution *Aikesheng is produced by the open source community. The original content can ...

Posted on Mon, 30 Mar 2020 02:53:10 -0700 by Crysma

Quick use of spring data jpa

rely on maven dependence <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> .yml file Configure mysql,jpa, etc server: port: 8080 context-path: / helloWorld: spring Boot\u5927\u7237\u ...

Posted on Sun, 29 Mar 2020 12:07:07 -0700 by hkay1

Fault analysis of row based dual master master replication Err 1677

1, Error message Recently, the project implementation colleagues upgraded the system and changed a field of test.test tab T1. The SQL statement is as follows: ALTER TABLE TEST.TEST_TAB_T1 MODIFY BXXX VARCHAR(200);   After the system upgrade of the project, the MySQL master-slave synchronization error is reported as follows: mysql>show slave ...

Posted on Sun, 29 Mar 2020 11:21:13 -0700 by gaz_hayes