MySQL

1 OverviewIn general, there is only one primary node, there are multiple from the node, only read operations are supported from the node, and the master node supports write operations.The realization of read and write separation has two solutions,

Often for convenience and intuitive, we will first directly in the database design tables, but then the structure and design of the table will be written in the design document, so that the code can be intuitive query, once the database table is

Linux operations must be the MySQL enterprise face question Daquan recommendation(1) Examination of the basic written order 1. Turn on MySQL service/etc/init.d/mysqld startservice mysqld startsystemctl start mysqld2. Detect if the port is

Working with the MySQL service for AWS and Azure, you need to test the performance of the two cloud services. So start Baidu + Google, find performance testing tools. Finally decided to use Sysbench.Sysbench IntroductionSysbench is an open source

[TOC]1. Install MySQL1.1 in RedHat using Yum mode to remove the system's own MySQL 5.1rpm|grep mysql #查看已经安装的mysqlrpm -e mysql　　 #普通删除模式rpm -e --nodeps mysql #强力删除模式1.2 Uninstall RPM package with Yum to prevent MySQL installation

Recently because the business requirements need to calculate the age according to the date of birth, on-line check a lot of methods, summarized here.On the Internet, many of the calculation methods have referred to the Gregorian calendar,

MySQL adds a time interval for the date: Date_add ()Now ()//now function to get the current timeSelect Date_add (now (), Interval 1 day); -Plus 1 daysSelect Date_add (now (), interval 1 hour); -Plus 1 hoursSelect Date_add (now (), interval 1 minute);

MySQL user management 1. Create a regular user and authorize[[email protected] ~]# mysql -uroot -p‘szyino-123‘Warning: Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL

I. Exporting a databaseMy MySQL installation directory is D:\Program files\mysql\mysql Server 5.5\bin\, the export file is expected to be placed in D:\sql\Execute command in MySQL installation directory: Mysqldump-hhostname-uusername-ppassword

LBS Spherical Distance formulaHttp://wiki.myoa.info/zh-blog:20java,mysql-500 meters of nearby locations based on a given latitude and longitude point-rational use of the algorithmRecently do a project: you need to query a site (known to the site

MySQL data types describe numeric types (integer type tinyint,smallint,mediumint,int,bigint; floating point decimal data type float and double, fixed-point decimal type Decimal), Date/Time type (year, Time,date,datetime,timestamp) and String types

use third-party tools to back up MySQL-----perconaFirst, pre-preparation work:1, install the dependency package: Yum-y Install PERL-DIGEST-MD5 Perl-dbd-mysqlRPM-IVH libev-4.15-1.el6.rf.x86_64.rpm2. Installation Main package: percona-xtrabackup-24-2.4

Before describing Python's operations in the database, let's briefly introduce the operating language in MySQL:[[Email protected]2018- on- -]# Mysql-u Root-Penter Password:welcome to the MySQL Monitor. Commands End With; or \g.your MySQL

There are tables in the library and there are fields in the table. For example, change the password Operation user table, the operation of the field is passwordThe command does not take effect until the # sign is added.1. What database does the

Mysql Innodb Lock Mechanism and mysqlinnodb Lock MechanismLatch and lock Latch can be considered as a lock in an application. It can be called a latch (lightweight lock) because it requires a very short lock time. If the lock lasts for a long time,

Mysql does not enter 0 implementation code on the current day according to the daily statistical report. mysql Statistical Report1. recurrence of the problem: Count the total number of days per day. If there is no data for a few days, the group by

MariaDB multi-instance and MariaDB instance1. Install MariaDB in yum and start yum install MariaDB-serversystemctl start mariadb.service  2. Create a directory by case and set the owner Group Store configuration files and databases by case mkdir -pv

Mysql learning day 3, mysql Day 3 1. add, delete, and modify data in the table (DML)Create table t_user (Id int primary key auto_increment,Name varchar (20) not null,Email varchar (20) unique) Add records to a table (required) Insert into table name

MySQL Checkpoint technology, mysqlcheckpoint   For personal reading notes, see MySQL technology insider Innodb Storage Engine   1. Background generated by checkpointWhen the database adds, deletes, queries, and modifies data, it is completed in the

Mysql transaction isolation level, mysql transaction isolationTransaction Isolation Levels InnoDB supports four isolation levels in the SQL1992 standard: read uncommitted, read committed, repeatable read, and SERIALIZABLE. The default isolation