mysql

The following article is mainly about the MySQL hidden space-related issues, we all know that the use of the MySQL database tmpdir value of the environment variable is to save the actual path name of the relevant directory of the temporary file. If

MySQL's master-slave synchronization is a very mature architecture, the advantages are: ① can perform query work from the server (that is, we often say read function), reduce the pressure of the primary server; ② is backing up from the primary

In Linux, often the case is the use of VBB this forum system, the emergence of slow, MySQL suspended animation state, the sleep process is too much and so is like. Led to dozens of users, the system is done.In fact, this is a MySQL configuration

Recently, because of the need to study the MySQL random extraction implementation method. For example, to randomly extract a record from the TableName table, the general wording would be: SELECT * from TableName ORDER by RAND () LIMIT 1. But then

Ubuntu10.04 on the back of the MySQL, executed theroot@ubuntu:~ #sudo apt-get Install MySQLAfter installing Mysql-server Start MySQLRoot@ubuntu:~#/etc/init.d/mysql start Local connections can be entered into the database.root@ubuntu:~ #mysql-uroot-

MySQL left connection query is a way to connect the query, the following is to introduce you to the MySQL left connection query some of the questions to talk about, if you are interested, may wish to see. The main Table I'm talking about here

This article describes how to backup and restore the MySQL database under Linux. Database backup is very important. If you do a regular backup, you can restore the data to the last normal state in the event of a system crash, minimizing the loss.

Concurrency and isolation control mechanism in 1.MySQL Meta-data metadata Lock: Implemented in the table cache buffer, provides isolation for DDL (Data Definition Language). A special Meta-data metadata type, called Name Lock. (SQL Layer)

The SQL used to manipulate the database is generally divided into two types, one is the query statement, which we call the SELECT statement, the other is the UPDATE statement, also known as the data manipulation statement. The implication is that

MySQL uses the user name for the authentication purpose, regardless of the UNIX user name (login name) or the Windows user name. By default, most MySQL clients try to log on using the current UNIX username as the MySQL username, but this is only for

Here we will describe the MySQL memory usage on the thread exclusive, thread exclusive memory is mainly used for each client connection thread to store the exclusive data of various operations, such as thread stack information, packet sorting

With MySQL, security issues cannot be noticed. Here are 23 things to note about MySQL tips: 1. If the client and server-side connections need to cross over and pass through an untrusted network, you need to use an SSH tunnel to encrypt the

The following article is mainly about the performance of MySQL closely related to the five configuration parameters of the introduction, I saw a few days ago in the relevant web site on the performance of MySQL closely related to the five parameters

The following article mainly describes the MySQL operation log to see the actual operation steps and the actual operation steps of the specific description, if you encounter similar situation in the actual operation, but you do not know how to solve

First, Summary: Today, as Web networks continue to provide businesses with an economic way to sell their goods and services, we will see more investment in web-based applications. An internal feature of the Web, and one of the most common technical

1. Find out if you should use MySQL cluster first. Reduce data Center node pressure and large amount of data processing, using the MySQL distribution, one or more application corresponding to a MySQL database. A few MySQL database common data to

The role of foreign keys: Maintain data consistency and integrity, primarily to control the storage of data in foreign key tables. Causes the two tables to be associated, the foreign key can only reference the values of the columns in the outside!

Environment:Master server: CentOS 5.2 mysql 5.1.35 source ip:192.168.1.22From server: CentOS 5.2 mysql 5.1.35 source ip:192.168.1.33Configuration:First, the main server1.1, create a replication user, with replication slave permissions.Mysql>grant

See also: http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#Password_functions I paraphrase, roughly is the following content: Before the 4.0 version 1, the server sends the random string (Scramble_buff) to the client. 2, the

Here we will describe the MySQL memory usage on the thread exclusive, thread exclusive memory is mainly used for each client connection thread to store the exclusive data of various operations, such as thread stack information, packet sorting