MySQL

Background: The responsibility of the automated continuous delivery platform business gradually increased, safekeeping, need to build a backup system, after a number of considerations;Choose to take MySQL master-slave system for backup, mutual main

Environment IntroductionOs:centos6.x & Win2003 & Win2008MySQL version: 5.5.xIn addition to the common MySQL management tools, mysql client command-line tools are often used1.Linux Installing the command-line tool(1). Enable the Epel Source:(2).

1: using show statement to find out what database currently exists on the server:Mysql> SHOW DATABASES;2:2 , create a database Mysqldatamysql> CREATE DATABASE Mysqldata;3: Select the database that you createdmysql> use Mysqldata; ( Press ENTER to

The morning just work about ten minutes, colleagues said in the use of Jira problems, as follows:650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6F/88/wKiom1WfLDXD_ag0AAX0GXUN_xc840.jpg "title=" The number of database connections is too

1 , change master and slave configuration filesMaster configuration file# CP/MYSQL/SUPPOTS-FILE/MY-DEFAULT-CNF[Client]port=socket=[Mysqld]Basedir=Datadir=port=Server-id=Socket=/data/mysql.sockLog-bin=/data/mysql_binBinlog_format=mixed/row/sqlbinlog-

?Mydumper is a lightweight third-party, open Source tool for MySQL database backup, backed up in logical backup mode. It supports multi-threading, and backups are much faster than the mysqldump of the original ecosystem and many of its outstanding

Compile and install MySQL1 Find out if the system has MYQL installedRpm-q MySQL Mysql-server1.1 If it is installed. Just deletesudo yum-y remove MySQL mysql-serversudo rm-rf/etc/my.cnf2 Installation Dependenciessudo yum install ncurses-devel-ysudo

Syntax:Object: BOOL mysqli::multi_query ( string $query ) Process: bool mysqli_multi_query ( mysqli $link , string $query ) Usage: mysqli::multi_query  (  string  $query  ) $dataStr = ' Multiple SQL statements to execute '; $mysqli new

Source: http://blog.csdn.net/dapeng0112/article/details/37053407The initial configuration is this:scripts/mysql_install_db--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data--user=mysqlCame up[[Email protected] mysql-5.6.14]# service MySQL

A. First stop the service/etc/init.d/mysqld stop and add it in/ETC/MY.CNF:Socket=/var/lib/mysql/mysql.sockSkip-grant-tablesUser=mysql Start MySQL service, enter MySQL login mysql> use MySQL;Reading table information for completion

#/bin/sh #检测mysql server is serving as expectedMysqladmin-u sky-ppwd-h localhost Ping #获取mysql当前的几个状态值Mysqladmin-u sky-ppwd-h localhost status #获取数据库当前的连接信息Mysqladmin-u sky-ppwd-h localhost processlist #获取当前数据库的连接数Mysql-u

Reprint Please specify source: http://blog.csdn.net/l1028386804/article/details/46763767In the MySQL database, there are mysql_install_db scripts to initialize the permissions table, and the tables that store the permissions are:1. User table2. DB

The two most common bottlenecks for MySQL databases are CPU and I/O bottlenecks, which typically occur when the CPU is saturated, when the data is loaded into memory or read from disk. Disk I/O bottlenecks occur when the load data is much larger

Because MySQL database additions and deletions suddenly burst, need to query is the operation of those tables is particularly frequent, wrote a tool to analyze Bin-log, find and add and change the table, and the number of operations in descending

numeric type, string type, date Time type numeric types (integers, decimals):　 Zerofill: The number of digits is not sufficient for 0 padding. ALTER TABLE t1 MODIFY id1 int zerofill; Decimal (floating point, fixed point): floating

Password problem handling during installationA RANDOM PASSWORD have BEEN SET for the MySQL root USER!You'll find that password in '/root/.mysql_secret '.Vi/root/.mysql_secretMysql-uroot-p Random PasswordUPDATE user SET Password=password (") where

After doing the data migration, it is found that Japanese data is garbled through UI, and it is normal to modify Japanese directly through the UI.After checking the information, the MySQL character set functions as follows:MySQL Character set

Sometimes the project needs to follow the pinyin of Chinese characters, such as contact list, mineral classification, etc., some of which need to be phonetic Alphabet from A to Z.　　if the stored Chinese character field encoding uses the GBK

1. Forget the root passwordHttp://www.lishiming.net/thread-252-1-1.htmlGo to MySQLwhich MySQL/usr/local/mysql/bin/mysql You can open MySQL like this before you set a passwordLogin/usr/local/mysql/bin/mysql-uroot-p123456If you forget the root

transferred from: http://blog.csdn.net/codeforme/article/details/5539454foreign KEY constraints The meaning of the child table:Insert/update is not allowed on a child table if a candidate key is not found in the parent tableWhat foreign KEY