MySQL

ZZ from http://www.magedu.com/First, installation1. IntroductionXtrabackup is a MySQL database backup tool provided by Percona, officially described, which is the world's only one by one open source tools that enable hot provisioning of InnoDB and

Prior to the operation of the database, it was found that some content should be submitted as a transaction, rather than being submitted separately, which would require these operations to be handled as a transaction. And I have previously written a

Original address: http://www.uml.org.cn/sjjm/201205302.asp00– Basic ConceptsWhen concurrent transactions access a resource at the same time, it is possible to cause inconsistent data. Therefore, a mechanism is needed to order access.A lock is one of

First, what is insert bufferInsert buffer is a special data structure (b + tree) that is not part of the cache, but a physical page that caches secondary index pages when the affected index page is not in buffer pool . when the buffer page is read

MySQL from getting started to mastering (performance testing and tuning)Course View Address: HTTP://WWW.XUETUWUYOU.COM/COURSE/33Courses from the School of worry-free network : http://www.xuetuwuyou.com/Starting from the basics, all the way up to the

The MySQL server suddenly fails to start, looking at the last boot log as follows:080825 09:38:04 Mysqld started080825 9:38:04 [ERROR] Can ' t start server:bind on Unix socket:permission denied080825 9:38:04 [ERROR] Do you already has another MYSQLD

We may encounter this problem when we use the MySQL server database, and if one of the MySQL databases goes down, we want to fix it in the shortest possible time and use the database as quickly as we can, but what if we encounter some failures that

Please refer to MySQL official documentation reference Manual, version 5.6.10.Replication allows data to be copied from one MySQL database (Master Master Library) to another or multiple MySQL databases (slave from the library). By default,

How to batch modify MySQL engine in production environmentIn general, this demand is not much, but occasionally, here we recommend the use of SED to the backup of the content of the engine conversion method, of course, do not forget to modify the MY.

The recent online frequent occurrence of slave delay, after the detection of the user in the deletion of data, due to the table primary key of the missing primary key, while deleting the condition is not indexed, or delete the condition of the

Several Web servers have been configured recently to post the installation notes. There is no time like before, the article written as the system, please forgive me. Detailed configuration, you can see the previous old article:

MySQL UseFloating-point numbers: float and doubleFixed-point number: decimalRepresents decimals　　From which we know that the decimal type is the same as the double type, but the byte number of the decimal is m+2, that is, the storage space of the

MySQL database insert and UPDATE statementsCitation: SQL used to manipulate the database is generally divided into two types, one is the query statement, which is what we call the SELECT statement, the other is the UPDATE statement, also known as

MySQL Get table informationmysql> use Test;database changedmysql> Show Table status;+---------------+--------+---------+------------+---- --+----------------+-------------+-----------------+--------------+-----------+----------------+---------------

MySQL Create stored procedureIn MySQL, the basic form of creating stored procedures is as follows:CREATE PROCEDURE sp_name ([proc_parameter[,...]]) Where the Sp_name parameter is the name of the stored procedure, Proc_parameter represents

Enter the database:1 mysql> use sunshine_blog;Output:2Database changedCheck the database table:1Mysql>Show tables;Output:2 +-------------------------+3 |Tables_in_sunshine_blog|4 +-------------------------+5 |Test|6 | User |7 +----

Heartbeat+drbd+mysql+haproxyHeartbeat+drbd+mysql main realization of MySQL master single point of failureHaproxy implementation of MySQL slave load balancerSpecific testing of the architecture diagram and IP settings650) this.width=650; "src=" Http:/

code example:1 ' 2012-07-18 00:00:00 ' On completion preserveenabledoupdate ' om_courselist ' SET ' status '=6 WHERE ' status ' =5 and ' Closetime ' current_timestamp ();You can create events with Navicat, and more quickly:Navicat creating and

first, mathematical functionsABS (x) returns the absolute value of XBIN (x) returns the binary of X (Oct returns octal, HEX returns hex)CEILING (x)Returns the smallest integer value greater than XEXP (x) return value E (base of natural logarithm) x

A system was recently developed to deploy on a test environment (Win7 environment) and tested, no problem was found, but after the system was deployed to win SERVER2008R2, some pages reported "the requested. NET Framework data provider could not be