MySQL

[Email protected] ~]# Unzip Tpcc-mysql.zip[Email protected] ~]# CD TPCC-MYSQL/SRC[[email protected] src]# make[Email protected] src]# CD.[email protected] tpcc-mysql]# LL[Email protected] tpcc-mysql]# mysql-uroot-pabcd.1234mysql> CREATE DATABASE

General optimization MySQL First look at the data to find whether the index, no index to index, index time to avoid the index failure.Look at the following two statementsMySQL [release_test_oa]> EXPLAIN SELECT * from Workflow_logs WHERE ID-100 MySQL

Learn about MySQL master-slave replication:MySQL's replication capability is the foundation for building large, high-performance applications. Master-slave replication refers to the fact that one server acts as the primary database server (master),

MySQL Machine Host ip:192.168.1.112 Slave machine ip:192.168.1.114 Host Configuration My.ini Configuration (restart service after modification) # master-Slave replication Primary server configurationServer-id =

Pro-Test can be, recorded February 5, 2018 11:03:221,/etc/my.cnf [mysqld] Increase datadir =/DATA/NAS2,/etc/rc.d/init.d/mysql from "datadir=/data" revision to "Datadir=/data/nas" from "datadir_set=" to "datadir_set=1" 3, move/data directory from the

Since as middleware, need, before, and the front end of the data interaction, after the data with the database interaction, in the previous step, we have sent out the data, as long as the front-end calls to the data is good, below we describe how to

SET sql_safe_updates = 0;Update and delete operations will be performed smoothlySET sql_safe_updates = 1; ( safe update mode)In the update operation: The update is rejected when the Where Condition (column) has no index available and no limit

1.IsNull (expr): Exper is null, returns TRUE, otherwise falseIfnull (EXPR1,EXPR2): If EXPR1 is not NULL, the return value of Ifnull () is expr1; Otherwise its return value is EXPR2Format (X,D): formats X as a number of D decimal places, can format

Saltstack execution results are saved to MySQL for command security auditsMust be an environment above python2.7Install related modulesUbuntu System InstallationApt-get install-y Python-mysqldbCentOS System InstallationYum Install-y

When mysql5.6.37 is installed, by default, only local logins are allowed, and remote logins are forbidden.You can now install the connection tools locally, such as SQLyog or Navicat.After logging in, switch to MySQL databaseExecute the following 2

1. Add a primary key indexMysql>alter TABLE ' table_name ' ADD PRIMARY KEY (' column ')2. Add unique (unique index)Mysql>alter TABLE ' table_name ' ADD UNIQUE (' column ')3. Add a normal indexMysql>alter TABLE ' table_name ' ADD INDEX index_name ('

Vim/var/log/mysqld.log 2018-02-04 13:22:49 28507 [ERROR] Innodb:cannot allocate memory for the buffer pool2018-02-04 13:22:49 28507 [ERROR] Plugin ' InnoDB ' init function returned ERROR.2018-02-04 13:22:49 28507 [ERROR] Plugin ' InnoDB '

Prevents SQL injection and SQL Injection 1 function checkStr ($ username) {2 // custom string rule 3} 4 5 function checkLogin ($ username, $ password) {6 7 $ password = md5 ($ password ); 8 9 $ username = addslashes ($ username); // escape 10 11 $

MySQL advanced query,   Advanced Query Keyword writing sequence keyword execution sequenceSelect: Projection result 1 5 From: locate Table 2 1 Where: first filter 3 2 before grouping Group by: group 4 3 Having: The second filter after grouping 5

MySQL Group Replication configuration, mysqlreplicationMySQL Group Replication MySQL group replication implements Multi-master Update (single-master mode) based on the replication protocol ). A replication group consists of multiple server members,

Summary of execution issues between mysql max and where, mysqlmax Execution problem between mysql max and where Execute SQL: Create table 'grades' ('id' int (20) not null AUTO_INCREMENT, 'student _ id' int (20) not null, 'subobject' varchar (20)

Detailed installation process of mysql5.7.21 in win10, win10mysql5.7.21 This article will share with you the problems encountered during mysql5.7.21 installation and installation for your reference. The specific content is as follows: 1. I

MySQL quick comparison data skills, MySQL DATA skills In MySQL O & M, R & D colleagues want to compare the data on two different instances and find out the difference. In addition to the primary key, they also need to compare each field. How can

Use sqlyog to connect to ubuntu mysql server Error solution, sqlyogubuntu Currently, many services are deployed in the linux environment, but in the development stage, the use of windows Remote connection tools is intuitive, which is more friendly

MySQL basic statement and MySQL statement Create a table If it is a keyword, use the key below the back quotation mark ''esc Create table [if not exists] table Name (Field 1 Data Type [constraints, indexes, comments],Field 2 Data Type [constraints,