MySQL

1. When you uninstall the old MySQL database service from your computer, first stop the MySQL service in the Windows service.2. In the control Panel to delete the add-in program, but you can not completely delete the MySQL service,3. Clear your

1. View all library sizes under the DB instance, and the result is in megabytesMysql> Select Table_schema,sum (data_length)/1024/1024 as Data_length,sum (index_length)/1024/1024 as Index_length, SUM (data_length+index_length)/1024/1024 as sum from

1.2. Configure MasterModify/ETC/MY.CNF Increase[Mysqld]log-bin = Master-binlog-bin-index = Master-bin.indexserver-id = 1　　3. Master creates a replication userCREATE USER Repl_user; GRANT REPLICATION SLAVE on * * to Repl_user identified by ' 123456 ';

Set the site encoding to Utf-8, which is compatible with all characters in the world.If the site has been working for a long time, there are many old data, can not change the setting of Simplified Chinese, then it is recommended to set the page

Org.gjt.mm.mysql.Driver is the early driver name, later renamed to Com.mysql.jdbc.Driver, now generally recommended to use Com.mysql.jdbc.Driver. In the latest version of MySQL JDBC driver, in order to maintain the old version of compatibility,

①, getting the running MySQL process to use each server parameter and its valuesMariaDB [(None)]> Show Global variables\g# View server global Parameters MariaDB [(none)]> SHOW SESSION variables\gmariadb [(None)]> Show variables\g# View the server

1, do not use Mycat hosting MySQL master server , simple use the following configuration:Writetype= "0" dbtype= "MySQL" dbdriver= "native" switchtype= "1" slavethreshold= ">"selectuser () password= "123456" >2 , using Mycat managed master-slave

1. Uninstall the original mysql-libs of the systemRPM-E [Name]--nodeps2. Install MySQLRPM-IVH mysql-server--ivh mysql-client-xxxxxx3. Initialize and set the password/usr/bin/mysql_install_dbservice mysql startcat /root/-uroot-pmysql>set PASSWORD =

First, install the Sysbench1. Software version sysbench-0.4.12.72. Compiling the installation1) Compile the configuration#./configure--with-mysql-includes=/opt/mysql/include/--with-mysql-libs=/opt/mysql/lib/2) compiling#make......../bin/sh. /libtool-

0, change Password: mysqladmin-u root-p password 123456Export database: Mysqldump-u root-p yunpay>yunpay.sqlImport Database: Mysql–u root-p Yunpay 1, for MySQL add a named admin, host name arbitrary network user, which through the password ' 123 '

MySQL timestamp to date formatSELECT from_unixtime (add_time, '%y-%m-%d%h:%i:%s ') from ' Wh5_username ' where id=23;Show processShow ProcesslistConnecting to a databaseMysql-uroot-ppwd.secret-s/data/mysql/mysql_3306.sockDelete a data tableTRUNCATE

Centos6.4 under Compile and install MySQL5.6. -Overview: CentOS6.4 the version of MySQL installed through Yum is version 5.1, older, so you want to install the high-level 5 through the source code.6.14. Text: One: Uninstall the old version use the

1. Environmental statement System for CentOS 6.5 Need to install Mutt and MSMTP and can send mail Need to install Xtrabackup 2. Backup Scheme Function Module introduction650) this.width=650; "title=" MySQL backup

1. Configure the Master LibraryYou must turn on the second-level log and assign a unique server ID• If you do not set Server-id or set it to the 0,master node, the slave connection will be rejected• It is recommended to set

Recently learning slick, found in MySQL created under the table, can not specify the database engine, the source of research, found that after modification can achieve the desired purpose.The code is as follows and is then used directly in the

1. Description of the problem: In the execution CREATE TABLE Goodsandprops (goodsid varchar) NOT NULL, Propsid varchar (+) NOT NULL, Propsvalue varchar (+) NOT NULL, primary key (Goodsid, Propsid, Propsvalue)); When it happens, the three-field key

2015-10-24DirectoryResources[1] Tang Hanming. mysql database development, optimization and Management Maintenance (2nd edition) [M]. Beijing: People's post and Telecommunications press, 2014[2] Schwartz. High-Performance MySQL (3rd edition) [M].

Due to some problems in MySQL master, such as Phantom Reading, and so on master-slave synchronization occurs when the main fault, need to master and slave cross-cutting, just learning python with Python wrote a master-slave cross-cutting script,

if AB different steps1) View the auxiliary SQL log tailf/var/log/mysqld.log140304 11:59:18 [Note] Slave I/O thread:connected to master ' [email protected]:3306 ', replication started in log ' Binlog .000011 ' at position 294# whether the server can

1. List the number of employees and department numbers in each department with wages higher than the department's average salary, sorted by department numberSelect A.deptid, COUNT (*) from employee921 as a INNER JOIN(Select DeptID, AVG (Salary) as