Binlog mode can be divided into the following three types (row,statement,mixed)1.RowThe log is recorded as each row of data is modified form, and then on the slave end of the same data modified, only the data to be modified, only the value, there is
Mysqldump-hhostname-uusername-ppassword databasename > Backupfile.sqlBacking up the MySQL database to a format with a delete tableBacking up the MySQL database is a format with a delete table that allows the backup to overwrite the existing database
SqlDDL: Data definition language CREATE DROP ALTERDML: Data Manipulation language SELECT INSERT UPDATE DELETEDCL: Data Control Language GRANT REVOKE COMMIT ROLLBACKThe most basic (build a library, build a table)SHOW DATABASES;Use database
I did a MySQL multi-instance experiment today,Enter 3307 no problem.Enter 3306 : Enter : mysql-s/data/3306/mysql.sock error :
ERROR 2002 (HY000): Can ' t connect to local MySQL server
Solve:1.Kill 33934Kill 342282,I removed the
MySQL commonly used data types are numeric type, text type, binary type, and time date.1. Numeric type
Data type
Description
BIT (M)
Bit type. m specified number of bits, default value 1, Range 1-64
Whim to install a CDH cluster on a virtual machine, install MySQL in the middle, and install the process notes againMySQL official website: http://www.mysql.comI installed the Centos7,mysql-5.7.13-1.el7.x86_64.rpm-bundle.tarThe installation method
Python connects MySQL to connector there are many, we choose MYSQLDB
Let Python support MySQLdb module
#pip2.7 Install Mysql-pythonSee if the modules available with python2.7 are present
First, to prepare two servers, virtual machine can be, to the author as an example: master:192.168.1.105 slave:192.168.1.106Two. Ensure that the two virtual functions ping each other, first shut down the firewall: service iptables stopThree. Install
If you do not know the path to the profile you are currently using, you can try the following:# which mysqld/usr/local/mysql/bin/mysqld#/usr/local/mysql/bin/mysqld-- Verbose--help |grep-a 1 ' Default options '2016-06-02 16:49:39 0
MySQL 5.6 Dual machine Hot standbyDirectory:1. Description2. Manual synchronization of data3. Modify the master database configuration file4. Modify the configuration file from the database5. Add a backup user to the primary database6. Set from
1 , query loglog={on| OFF}: Log information for all statements is logged in the General query log file (General_log);log_output={table| file| None},table and file can appear at the same time, separated by commas.General_log: Whether query logging is
Under Window1. Export the entire databaseMysqldump-u user name-p database name > exported file nameMysqldump-u dbuser-p dbname > Dbname.sql2. Export a tableMysqldump-u user name-P database name Table name > exported file nameMysqldump-u dbuser-p
Index purposeThe goal of the index is to improve the efficiency of the query, you can analogy dictionary, if you want to check the word "MySQL", we definitely need to locate the letter M, and then find the Y letter from the bottom, and then find the
According to the error, the obtained main library file format is wrong.First, lock the master-slave Normal LibraryMysql> flush tables with read lock; Lock tableUnlock tables; UnlockSHOW MASTER STATUS;Main MySQL add user to connect from server: GRANT
Written in the firstAbout the start and configuration of slow SQL before I clean up the article:Http://www.cnblogs.com/hanxiaobei/p/5515624.htmlPrerequisite Preparation:tomcat7.xMysql--perfteachJmeterTest interface:
First look at what images are in this machine, and the commands are as follows: Docker images650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/82/0F/wKiom1dJYJDzNfTgAAAqY6qN28s530.png-wh_500x0-wm_3 -wmp_4-s_3636605211.png "title=" qq
Connection and shutdown of 1.mysql databasesTo connect to a database:Mysql-h Server host address-u user name-p passwordTo close the connection:Enter exit or quit at any time2. Create a new user and authorizeGrant permissions on the database. Data
Login MySQL: mysql-u root-pIf you need to change your password, first: mysqladmin-u root password NewPasswordSet over: mysqladmin-u root-p ' oldpassword ' password NewPasswordExecute the following command to turn on remote access Restrictions grant
MySQL Data Type
The data field type defined in MySQL is very important for your database optimization.
MySQL supports multiple types, which can be roughly divided into three types: numerical value, date/time, and string (character) type.
Value Type
How to view or modify the Root password of Mysql, mysqlroot
How to view or modify the Root password of Mysql:1. Start the command line first.2. Run taskkill/f/im mysqld-nt.exe on the command line3. Continue to run mysqld-nt -- skip-grant-tables on
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service