MySQL

The default Nginx only supports HTTP reverse proxy, if you want to support TCP reverse proxy, you also need to increase the TCP proxy module support at compile time, that is Nginx_tcp_proxy_moduleThe following steps only let Nginx support Tcp_proxy,

Download Xtrabackup:# wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.6/binary/tarball/ Percona-xtrabackup-2.4.6-linux-x86_64.tar.gzDecompression Software:# tar xvf percona-xtrabackup-2.4.6-linux-x86_64.tar.gz-c/usr/local/#

First, the concept of row lock and characteristics1. Concept: Lock a single row of records, mainly applied to the InnoDB table storage engine2. Features: in InnoDB storage engine application is more, support transactions, high overhead, locking slow;

After installing MySQL, the default boot will not start automatically, you need to manually set up MySQL let it boot from boot.First, with the Chkconfig command to see if MySQL is not in a manageable list, the command is:Chkconfig--listMessagebus

Set Meal GroupA php+mysql-based takeout ordering site, including front-end and backstage.Source AddressSOURCE Demo Address: http://dingfanzu.com Business backend System: http://dingfanzu.com/admin Test Account: admin Password: admin

One MySQL overall framework:MySQL is composed of SQL interface, parser, optimizer, cache, storage engine and so on.1. Connectors refers to the interaction with SQL in different languages.2. Management serveices & Utilities: System Management and

1. Create User: ' username ' @ ' host ' identified by ' password ';Username: User name; host: Specify on which host can log on, the local machine is available localhost,% all remote host; password: User login password;2. Authorization: Grant all

Show variables like ' character% '; To view the character encoding format of the current system locationsQuestion one: Incorrect string value: ' \xb4\xf3\xb4\xf3 ' for column ' name 'Workaround: Execute the Set names GBK before executing the INSERT

MySQL Performance optimization Related:To view a running SQL process:# mysql-u root-p ' xxxx '-e "show processlist;"Generally sleep too much will consume higher CPU and other resources# mysql-u root-p ' xxxx '-e "show processlist;" | grep Sleep | Wc-

What is a trigger Features and functions Example: Create a trigger, record a table's increment, delete, change operation record Disadvantages What is a triggerSimply put, a table has something (INSERT, delete, update operation), and

Read Catalogue What is a function Differences from stored procedures MySQL Self-band function Custom functions What is a functionFunctions in MySQL are similar to stored procedures, and are a set of SQL sets;Differences

Previously wrote a python query MySQL data article, today writes through Python inserts the data to the MySQL database.1. Build a library, build a table, build a usermysql> create database top_ten;mysql> use top_tenmysql> create  table log 

One, MySQL storage engine　　Second, how the storage engine chooses Whether the transaction is supported Retrieving and adding speed Lock mechanism Cache Whether full-text indexing is supported Whether foreign keys are

Environment Preparation:Deploy a master one from two servers, achieve master-slave replication, the main library to open Binlog, the main library and the Server-id from the library to be differentMain Library:[Email protected] ~]# hostname-i10.0.0.51

#!/bin/bashdbuser=rootdbpasswd=123456dbbak1=mysql_testbackupdir1=/data/backup_v2/mysql_testbacktime= ' Date  +%y%m%d%h%m%s ' if [ ! -d  $BACKUPDIR 1 ];then         mkdir  $BACKUPDIR 1fiecho  "========== $BACKTIME   Database $dbbak1 backup start =====

1, the first type:INSERT [into] tbl_name[(col_name, ...) {VALUES | VALUE} ({expr |default}, ...), (...), ...If you assign a value to an AutoNumber field, you can use NULL or default to allow it to be implemented in the form of an increment that is

The steps are as follows:1. Modify Master server Master:#vi/etc/my.cnf[Mysqld]Log-bin=MySQL-bin//[must] enable binary loggingserver-id=222//[must] server unique ID, default is 1, usually take IP last paragraph2. Modify the slave from the

Mybatis+mysql returns the inserted primary key, and the parameter only provides a partial parameter id= "Insertbychannelidopenid" usegeneratedkeys= "true" Keyproperty = "id" parametertype= "Com.model.StatisticSaler"> INSERT INTO

1. Preparation of installation Environment# Wget-o/etc/yum.repos.d/centos-base.repo Http://mirrors.aliyun.com/repo/Centos-6.repo# yum Install cmake-y# yum install ncurses-devel-y# useradd-s/sbin/nologin-m MySQL2, the compilation environment

Multi-Table query and Table query Multi-Table query1. Category:* Merge result sets (understanding)* Connection Query* SubqueryMerge result set* The table to be merged is required,The column type is the same as the number of columns.* UNION: removes