MySQL

Encountered a SQL statement that created the databaseCREATE DATABASE testdb DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci;Note : This specifies that the character set is used UTF8instead of utf-8.Interested in character SET and collate in the

1. What are the MySQL log files on the master server?View by command:Show binary logs;650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/85/45/wKioL1ee4Bqi9Zz0AAAwuxXkZk0315.png-wh_500x0-wm_3 -wmp_4-s_6781112.png "title=" 1.png "alt="

http://blog.itpub.net/28218939/viewspace-1975822/Concurrent Replication ( Parallel Replication ) Series II: Enhanced multi-threaded slavesMa Pengfei Technology MySQL database engineer First, we comb the basic principle of traditional

The MySQL load method must be built in case the MySQL service allows the command to be used:How to open the command:1. Add a row local-infile=1 (the default appears to be on) to the MY.CNF (Windows My.ini) for the instance , and switch to 0 to OFF,

Preface: When the data stored in a table is particularly high, such as a single. MyD data has reached 10G, it is inevitable that the reading efficiency is very low, this time we can use to divide the data into several tables to solve the

Recently, I am doing a project deployment, this project is nginx for the front-end agent two Tomcat node, through the Mysql-proxy proxy access to two master-slave MySQL database.The entire project was deployed, tested and found to be garbled in

One, the installation of MySQL:1. Download mysql, you can download MySQL software via http://mirrors.sohu.com/.wget http://mirrors.sohu.com/mysql/MySQL-5.1/mysql-5.1.73-linux-i686-glibc23.tar.gz2. Unzip and renameTAR-ZXVF

How do i show all users in MySQL? This is a question that MySQL beginners often ask, and today we'll show you how to display all the users in MySQL. Usually we use show DATABASES in MySQL to display all the databases, showTABLES will show all the

Online service Monitoring has been basically done, and now there is no detection of MySQL master-slave state, here to use Zabbix monitoring, but also to write a master-slave state script, and then set a key, create a template to apply this key to

When using MySQL, there are many types of int that need to be noted:1. Range of values Type Storage Minimum Value Maximum Value ( Bytes)( signed/unsigned) (

Source: The transaction support reproduced in MySQL is not tied to the MySQL server itself, but is related to the storage engine 1. MyISAM: Transaction not supported, for read-only program lift high performance 2.InnoDB: Acid transaction, row level

After you have installed MySQL, use the new configuration file. The MySQL server can start successfully, but at the time of login error 2002 (HY000): Can ' t connect to local MySQL server through socket, that is, unable to connect through the socket

In the previous article, "MySQL database Transaction and Replication" analyzes how to ensure the consistency between binlog and transactional data during MySQL replication, this paper further analyzes the need to consider what aspects are needed to

MySQL Maximum connection number problemIn MySQL source code, the default maximum number of connections is 16384 {"Max_connections", Opt_max_connections,"The number of simultaneous clients allowed.", (gptr*) &max_connections,(gptr*)

If you are dissatisfied with the execution plan selected by the optimizer, you can use several hints provided by the optimizer to control the final execution plan, the specific usage of each hint, the recommended direct reading of the official

How to install MySQL database using MySQL yum source, yummysql5.7 1. install and configure the MySQL yum Source # Install the MySQL yum source. The following is the RHEL6 series mysql5.6: Wget

MySQL Time Zone modification method summary, mysql Time Zone Summary This example summarizes how MySQL modifies the time zone. We will share this with you for your reference. The details are as follows: Note:Here we will summarize three methods for

Brief description of fast data migration in MySQL sharding, brief description of migration in mysql Recommended: the fastest way to migrate MySQL databases across operating systems Mysql backup and Migration Data Synchronization Method Operation

InnoDB source code analysis-transaction log (1), innodb source code Original article, reprinted please indicate the original link (http://www.cnblogs.com/wingsless/p/5705314.html) In the previous article "InnoDB WAL learning" (http://www.cnblogs.com/

SQL-database materials used for basic learning, SQL-basic database materials   -------------------------- Create MERs table------------------------Create table MERs(Cust_id char (10) not null,Cust_name char (50) not null,Cust_address char (50)