MySQL

74277381MySQL database design, where the performance optimization, field type is very important, the following bigint, int, mediumint, smallint and tinyint range of values for a simple summary, for viewing.1, bigintInteger data (all numbers) from -2^

Docker container Master node: 172.17.0.9Docker Container Sub-node: 172.17.0.10Asynchronous replication: First confirm that the main library and from the library is consistent, preferably a clean database that has just been initialized if the main

1, the basic Operation command:1. View all Storage enginesShow engines;2, view the existing table storage engine;Show create table table name;3. Create the storage engine specified by the tableCREATE TABLE table name (...). )

MyISAM and InnoDBMyISAM is the storage engine used before the mysql5.7 version.The advantage is used in the case of high query frequency, such as the data fetch of the website store.The disadvantage is not to support transactions, not suitable for

1. Retrieving MySQL images from DockerInstructions:Docker search MySQL2. Image downloadInstructions:Docker Pull mysql:5.7.193. View the local mirror listInstructions:Docker images#修改镜像名称Docker tag mysql:5.7.19 mysql:5.74. Create a container based on

The mysql-utilities in the Yum package within CentOS is not the latest version. So the installation is done by compiling the method. mysql-utilities-1.6.5 is implemented based on Python2 , so Python does not need to be upgraded to 3. Installation

Privilege control mechanismFour tables : User db Tables_priv Columns_priv privilege privilegesMysqlFrom User\gMysqlFrom db\gMysqlFrom Tables_priv\gMysql1. User authenticationView Mysql.user Table2. Authority authenticationTake SELECT permission as

Concatenation of strings1,mysqlIn Java, C # and other programming languages, the concatenation of strings can be achieved by the plus "+", such as: "1" + "3", "a" + "B".You can also use the plus sign "+" to connect two strings in MySQL, such as the

In daily operations, backup of MySQL database is crucial! The importance of the database to the website makes our management of MySQL data not be lost!Then, it is inevitable that people will make mistakes, maybe one day the brain short-circuited to

IndexAn index is a special kind of file that contains reference pointers to all the records in the data table. More generally, the database index is like a directory in front of a book, which can speed up the database query.Federated IndexAlso known

Joint queries are more efficient, with examples to illustrate Federated queries: The benefits and usage of inline inner join, leftist left outer join, right-outer JOIN, full-union, fully outer join.The efficiency of joint queries is high, and the

MySQL Performance optimization purposeHow to design the database rationally?What database design can provide the cornerstone for post-DBA optimization?The difference between database design and program design?Early optimization of database design1.

this article python version 3.5.3,mysq version 5.7.23Basic use# Imports Pymysql Module Import pymysql# Connection Database conn = Pymysql.connect ( database= "database name", user= " username", password= "password", host= "The address

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

Spring Boot integrates MyBatis, once a few small puzzles and trampling the pits.First, the structure of MyBatisMyBatis and spring boot integration, countless tutorials on the web, are teaching you step-by-step integration, do not have a problem, but

MySQL Database viewThe view in the database is a virtual table. As with real tables, row and column data, rows and columns, are used to customize the tables referenced by the view query and are generated dynamically when the view is referenced. You

"Preface" The previous blog introduced the index mechanism of the INNODB engine, mainly around the establishment of B + tree, the primary key and page number in the Catalog item record, the binary location data in the page directory, the primary key

ObjectiveMySQL database is currently the largest open source application of relational database, there are a huge number of applications to store data in the MySQL database. The security and reliability of storing data is the focus of the production

Definition of master-slave introduction MySQL master is also called replication, AB replication. Simply speaking is a and b two machines from the back, write the data on a, another B will follow the writing data, real-time data

How to start/stop/restart MySQL I. Startup Mode 1. Start with service: Service mysqldStart 2. Use the mysqld script to start:/etc/inint. d/mysqld start 3. UseStart safe_mysqld: safe_mysqld & Ii. Stop 1. Use ServiceStart: Service mysqld stop 2. Use