MySQL

This method is simple. Compile with the source code every time, waste a lot of time Ah!The same website program runs under Linux much faster than under Windows, so decided to use the Linux distribution version of CentOS , this article mainly

a thrilling Percona XTRA Cluster DB data repair process2014.12.27 noon at about 12:30, the telephone rang, is a colleague Yi's phone, told that there is a large number of deadlock in the library, with "service MySQL restart" can not be restarted.

one, MySQL installationInstall MySQL under CentOS Please open: http://www.centoscn.com/CentosServer/sql/2013/0817/1285.htmlIi. several important directories of MySQLMySQL installation is not as if SQL Server is installed by default in a directory,

This post documents how to build MySQL cluster environment with 4 machines. Their IP addresses and roles are listed below. Host #1:192.168.1.100, Management node Host #2:192.168.1.101, SQL node Host #3:192.168.1.102, Data node #1

As the amount of data in the database becomes larger, if you want to erase a month's data and delete it with the delete command, MySQL will not free up space, must defragment, or rebuild the table with the modification engine to free up space, but

At first, I thought it was my own character length problem, and after shortening it was still a problem. The original is because the Chinese code.Workaround: Modify the DEFAULT_CHARACTER_SET=GBK in the My.ini file;# CLIENT section#-------------------

For most Web applications, a database is a very basic part. If you're using PHP, you're probably also using the Mysql-lamp series as an important part.For many beginners, using PHP can easily write code with specific features in just a few hours.

As we all know, in the case of large traffic, can add node or change the schema can effectively alleviate the database pressure, but all the origin, all from a single MySQL start. The following summarizes some of the experiences that have been used

1 background 11.1 Mvcc:snapshot Read vs current Read 21.2 Cluster Index: Clustered Indexes 31.3 2pl:two-phase Locking 31.4 Isolation Level 42 A simple SQL Lock implementation Analysis 52.1 Combination one: ID primary key +RC 62.2 Combination two: ID

Transferred from: http://www.cnblogs.com/c840136/articles/2388512.htmlA new feature is introduced in the mysql5.1.x release, which, as the name implies, is an event, timed task mechanism that performs a specific task within a specified time unit, so

For operations on string positions, the first position is marked as 1. ASCII(str) Returns the str ASCII code value of the leftmost character of the string. If str It is an empty string, return 0 . If

"High Performance MySQL" is a classic good book, from the application layer to the database to the hardware platform, a variety of tuning skills, FAQs are all mentioned. The database of various conceptual skills usually have contact, such as index,

SELECT * FROM news where N_date>unix_timestamp (Subdate (now (), Interval 7Day)) Order BY N_click DescN Days of recordingWHERE To_days (now ())-To_days (Time field) Today's recordWhere date (Time field) =date (now ())OrWhere To_days (Time field) =

Text: SQL drip 40-mysql garbled problem SummaryThis article will explain how to handle the Java connection process of MySQL Chinese garbled problem. General MySQL Chinese garbled problem is related to the character set, the author's experience here

Source: SQL drip 41-mysql Common SQL syntaxALTER table: Add, modify, delete table columns, constraints, and other table definitions. View column: Desc table name; Modify table name: ALTER TABLE T_book Rename to BBB; Add column:

Because the system uses a large number of GUIDs as primary keys, the data file is large and the data query speed is slow. The intent is converted to an int primary key. First look at the results of the next single table test GUID and int as the

This article by show according to Lin Feng to provide friendship sponsorship, starting in the mud row world. In the previous article, we explained the basics of MySQL's binlog logs. In this article, we'll explain how to recover a database using

MySQL-Python Installation notes, mysql-python notes After installing mysql-python, the import module prompts the following error, Copy codeThe Code is as follows:ImportError: libmysqlclient_r.so.16: cannot open shared object file: No such file or

Mysqldump export does not contain stored procedures, mysqldump stored procedures Mysqldump export does not contain stored procedures     Mysqldump-u database username-p-n-t-d-R -- triggers = false Database Name> file name In this way, the

Use keepalived to build highly available MySQL-HA   This article describes how to use keepalived to build highly available MySQL-HA to ensure data consistency between the two MySQL instances. Then, keepalived is used to implement virtual IP