MySQL

Using the whole library replication scheme, easy to manage MySQL 5.5 + rhel5.810.4.11.12 Master10.4.11.13 slave---master-side settings1, create the replication account, need to copy and slave permissionsMysql> GRANT REPLICATION SLAVE, REPLICATION

A lot of integrated PHP environment (Phpnow WAMP Appserv, etc.) from the MySQL does not seem to open MySQL strict mode, what is the strict model of MySQL, in simple terms is the MySQL itself on the data for strict calibration (format, length, type,

Because my MySQL did not know why suddenly can't open and reported a 10061 error, check the next reason is because the database is connected to conflict, the trouble died so reload, in the last step of the start service stopped, installation failed,

Conditions:2 servers: A and B, the tables on a server are required to migrate to the B server.InnoDB table: Sysuser, record number: 351781.The following tests are performed in the MySQL 5.5.34.Start processing:1: Establish the Sysuser table on the B

In the script you can set up a list of database tables that need to be backed up, and the backup files will be compressed by gzip. It should be noted that this script only applies to environments where data consistency requirements are not high.

Recently, I have just entered a new company, and took over a site here, because the site's architectural design is not reasonable, resulting in the pressure of MySQL is always very large, often the locked process of time out, so wrote a section of

Length: is a calculation of the lengths of a field a Chinese character is counted three characters, a number or letter is counted as a character The Char_length (str) return value is the length of the string str, and the length of the unit is a

Its encapsulated MySQL simple Operation class, has been stuffed in the Ben Framework, based on PDO to write, the code has some nonsense style ... mysql.class.php server = $server; $this->database = $database; $this->user = $user;

If you need to internationalize a website, you need to convert the code from GB2312 to UTF-8, which has a lot of problems to note, if not converted thoroughly, there will be a lot of coding problems appear! PHP page UTF-8 encoding problem1. In the

Timestamp data type in MySQL is a very special data type, he can automatically update the time when you update the record without using the program update timestamp Usually there is a field in the table that creates date, and other databases have

Use test; DROP table if exists T8; CREATE TABLE T8 (S1 int,primary KEY (S1)); drop procedure if exists handlerdemo; DELIMITER $$ CREATE PROCEDURE handlerdemo () BEGIN declare xx int default 4; DECLARE oh_no condition for sqlstate ' 23000

1, view log situation Copy Code code as follows: Mysql> show global variables like '%log% '; +---------------------------------+---------------------------------+ | variable_name | Value | +---------------------------------+------------

Connection: Mysql-h host address-u user name-P user Password (note: U and root can be without spaces, others are the same) Disconnect: Exit (Enter) Create authorization: Grant SELECT on database. * To User name @ login host identified by \

Installation Environment: CentOS 5.4MySQL version: MySQL 5.1.xx with rpm direct installationRequired Software: Xtrabackup 1.2.22 with RPM direct installation1. master:/etc/my.cnf Copy Code code as follows: [Mysqld] Server-id = 1

This example for you to share the Java connection MySQL database code, for your reference, the specific content as follows Java connection MySQL database instance code package Com.abc.dao; /*dkplus specializes in collecting and compiling

Recently in the tangle of how to modify the MySQL password, finally finished. In the WAMP environment, left-click your Wamp icon. Find MySQL under the service and then you'll see a MySQL console and go to the following steps. Run->cmd First we

1. The fields that will be used frequently (such as frequently using these fields for sorting, or for searching), are best indexed. 2. The type of field can be as int or tinyint as possible. The other field uses not NULL as much as possible. 3. Of

Repeatable-read can be read repeatedly, and the contents of the Select table in set autocommit= 0 or start transaction state will not change. This isolation level may result in something that has been read that has been modified. Like what: Read a

MySQL log system online for some time, the front end in the slowly cut the site to write, proactive DIY set of MySQL monitoring tools. Divided into slave status, Sync,objec infot,userprivileges,job status, Slowlog. This time, Slow_log. MySQL 1.5

Php+mysql background, part of the program page does not display content, Error prompts error, need to repair. Open phpMyAdmin Select Database view, and sure enough, 3 tables are displayed as "in use." Check the "Repair table", the error can not be