MySQL

1, the principle of master-slave replication:*master, record data change operations- Enable Binlog logging mode- allow Slave to read binlog logs*slave running 2 simultaneous threads-Slave_io: Responsible for connecting Master, copy its binlog log

Start MySQL as a serviceEnter the MySQL installation directory under the bin CD C:\Program Files\mysql\binSet the service name to Mysqld mysqld--install mysqldStart Service net start mysqldService Management net Start|stop|restart start, stop,

1. Transaction InnoDB supports transactional functions, MyISAM not supported.Myisam executes faster and performs better.2. Select, UPDATE, INSERT, delete operation MyISAM: If performing a large number of select,myisam is a better choiceInnoDB: If

[Email protected] ~]# ll/usr/local/|grep mysqllrwxrwxrwx. 1 root root June 01:52 MySQL--/alidata/server/mysql# This is a script-free installation environment (more complex)[Email protected]/]# tree/data//data/├──3307│└──data└──3308 └──data4

The company recently used Microsoft Cloud, the development of a problem, said that the database time and PHP time is not correct, after viewing, sys time and PHP time is the same time zone, but into the MySQL check time, or not, forced to modify the

/*There are two main ways to handle MySQL transactions.1, with Begin,rollback,commit to achieveBegin a transactionROLLBACK TRANSACTION RollbackCommit TRANSACTION Acknowledgement2, directly with set to change the MySQL automatic submission modeMySQL

This article has been included in: Tip: ERROR 1044 (42000): Access denied for user "@ ' localhost ' to database ' MySQL '. The first two days also appeared this problem, online find a more popular method (see method one), done. Today again with this

Desc Tablenamename; Describe TableName; Show Columns TableName; Show CREATE TABLE tablename; The show is+-------------+-------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+------------

Connect to a database (traditional method)mysql_connect("Lcoalhost", "Root", "" ");//connect the native database, connect the external machine localhost can be changed to make IP addressmysql_select_db("Txst",$db);//Select the database to manipulate$

########################### Modify MySQL Maximum connection number ###############################After the MySQL database installation is complete, the default maximum number of connections is 100.The general production environment of the forum or

This article mainly describes the implementation of MySQL from the library through Haproxy load balancing, as for MySQL master-slave construction, this article no longer repeat, you can refer to my previous blog. 1. Download the Haproxy package

Key content Modify the following script Mysql_practice.sql to practice MySQL basic operations:show databases;Create Database if not exists' HA '; UseHA;Create Table if not existsStudent (IDint, nameChar( +), ageint); showCreate Tablestudent

1. Development environment: 1) CLion-2016.1.3 Mixed programming IDE for C/C + + and Python, first install the following 2) 3) compiler re-association 2) Tdm-gcc-4.8.1-3 C + + Compiler 3) winpython-64bit-3.5.1.3

Mysql Installation and configuration:1. Install MySQL:Upload the MySQL server and the client to Linux, install the server first, and then install the client: http://down.51cto.com/data/2222065Installation execution command: RPM-IVH installation

A problem with the database displays too many files, causing the database to be inaccessible. The problem is that the file descriptor has been opened too large. The results of the database search are:Show variables like "%file%";Open_files_limit | 10

First, the preparatory work1. Close the MySQL process# Pkill# Service Mysqld Stop2. Remove Mysqld from System services# chkconfig--del mysqld3. Delete Mysqld# Rm-rf/etc/init.d/mysqld4. Create a directory for each instance# Mkdir/data/{3306/data,3307/

Mysql> SelectFrom_unixtime (1156219870,'%y-%m-%d');+--------------------------------------+|From_unixtime (1156219870,'%y-%m-%d')|+--------------------------------------+| .- ,- A |+--------------------------------------+

add under [mysqld]-------------the primary server---------------"Step 1" VI/ETC/MY.CNF (the MySQL configuration file where source code is compiled and installed)/data0/MySQL/3306/my.Cnf[mysqld]server-id = 1Log-bin =MySQL-Binbinlog- Do-db

show databases; ---See what databases the system hasSelect Database (); ---View the database currently in useUse XXX----Switch databaseSelect User ();---view current userSelect version ();---view database versionSELECT * FROM table name----View

MySQL learns basic MySQL database operations on the fifth day. This article studies the basic operations of MySQL databases. Do not miss this article. The following command lines are used in Windows 64-bit operating systems. Before learning, Let's