MySQL

Environment: CentOS 6.3, mysql5.1Centos 6.3 After installing MySQL client and server, garbled, have to modify the encoding.Attention:About the difference between UTF8 and GBK detailed: Linux Chinese garbled problem resolution http://www.linuxidc.com/

Database performance is critical to a data-centric application that directly affects the performance of the program. In general, to ensure the efficiency of the database, to do the following four aspects of the work: database design, SQL statement

Log type for MySQL:Error log: Log-errorQuery log: LogSlow query log: log-slow-queriesUpdate log: Log-updateBinary log: Log-binTurn on the error loglog-error=/usr/local/mysql/log/log-error. LogStart query Loglog=/usr/local/mysql/log/log-query.

Des_decrypt (Crypt_str[,key_str])Use Des_encrypt () to encrypt a string. If an error occurs, this function returns NULL.Note that this function will only work if MySQL is configured with SSL support. See section 5.8, 7, "Using a secure

Questions: MySQL data from the library can not be synchronized, from the library show SLAVE status prompts the following error:Last_sql_error:relay Log read failure:could not parse Relay log event entry. The possible reasons Are:the master ' s

(1) ErrLogContains the phase when MYSQD starts and stops, and when the server has any serious errors during operation.related information;You can use the--log-error[=file_name] option to specify where MYSQLD saves the error log file. If no file_name

How do I restart MySQL under Windows ? this has 3 A way for everyone to refer First,MYSQL serviceMy Computer- ( Right-click ) management - Services and Applications - - service --mysql-- turn on ( stop, restart )Second, the command line

Method 1: Use the Set password command first log in to MySQL. format:mysql> Set password for user name @localhost = password (' new password ');example:mysql> set password for [email protected] = password (' 123 ');Method 2: Use Mysqladmin Format:

MySQL Master-Slave installation1 Introduction to the environmentOperating system: Oracle Linux Server Release 6.22 Installing the SoftwareUsing the source installation method1. mysql installation package:

Here's how to configure and monitor semi-synchronous replication:1. The semi-synchronous replication feature plugin access to MySQL and requires half-sync support in both the main library and the Slave libraries, as follows:On the mastermysql>

1. Lock mechanism1) When dealing with concurrent reads and writes, a set of locking systems is usually used to solve the problem. The lock system consists of a read lock (also known as a shared lock) and a write lock (also known as an exclusive lock)

Blink of an eye has been to 2015, the past few months, learning a lot of things, but also summed up a lot, during the encounter many problems, many of them are search without fruit, and then their own research, thinking more also want to share their

Since our server will be lent to some of our companies to use, but some companies do not have operations, are developing direct operations, resulting in a number of problems directly to me to deal with. To this end, also learn a lot.Recently, a

　　　　MySQL Introduction(1) MySQL database is Swedish AB developed.(2) mysql--> Sun---Oracle.(3) features of MySQL database.1. Open source.2. Free.3. Cross-platform (windows/linux/unix/Apple).4. Handling concurrency (13,000)/security/stability.5. The

Using count () in SQL seems like a natural thing to do:SELECT COUNT (*) from TABLE_NAME;Sometimes it is really thought that the difference between count (*) and individual count (column_name) is that the latter will be more efficient (take too much

1. Transaction processing and concurrency1.1. Basic knowledge and related concepts1) All table types can use locks, but only InnoDB and BDB have built-in transactional functionality.2) Start the transaction using begin, use commit to end the

First,: Mysql_5.6.22_winx64_xiazaiba:http://rj.baidu.com/soft/detail/12585.html?aldSecond, install the software, install to the specified path, here is C:\Program files\mysql\mysql Server 5.6\, you can refer to

Recent projects have encountered the logic that the ID of the record needs to be returned when a single record is modified.First talk about my use of the environment, Springmvc+mybatis, so the mother looked at the degree, the results recorded, only

MySql optimization solution, mysql Optimization MysqlSummary U Mysql database Optimization Technology A comprehensive technology for mysql optimization, mainly including A: Table Design rationalization (in line with 3NF) B: add an appropriate index.

[ShellCommand] global list of MySQL Clusters Author: skateTime: 2015/01/19 Global list of MySQL Clusters Usage:# Monrep-hUsage: monrep [-d dbname]-D Database Cluster name-H Display basic help# For example, if a cluster named dbx is used