PHP

The optimization of MySQL database performance is the only way to develop MySQL database. the optimization of MySQL database performance is also a witness to the development of MySQL database. The following describes how to optimize MySQL database

A new feature of the new generation of products is that users can choose to use full-flash storage or use both hard drives and flash devices to balance customers' different needs for superior performance and storage capabilities. For various reasons,

What is MinimalLogging )? When the recovery mode of the database is SIMPLE or BULK_LOGGED, for operations that minimize the log type, the transaction log does not record the logs of each individual data row, but records the modification logs of the

Considerations for optimizing the database: 1. create an index in the key field. 2. using stored procedures makes SQL more flexible and efficient. 3. back up the database and clear junk data. 4. SQL statement syntax optimization. (You can use

This article mainly introduces the basic usage and speed-up optimization methods of the altertable command in MySQL, including the use of ALTERCOLUMN. For more information, see I. Basic usage 1. add columns alter table tbl_name add col_name

MySQL character encoding system (II) -- Data transmission encoding The character encoding system of MySQL can be divided into two parts: one is about how to manage the encoding of character data when the database server stores data tables, and the

Text, varchar, char personal understanding of storage length this document is limited to mysql 5.5 or above Summary in utf8 format Mysql provides the following description in mysql official documentation: 1. refer to the following description in

When the disk is full, MySQL cannot be started: Diskisfullwritingamp; amp; # x27;. mysql-bin .~ Rec ~ Amp; # x27; (Errcode: 28). Wa received a monitoring email saying that the blog access failed. Open the page and check that the huge 502 Bad Gateway,

Mysql table sharding method ----- MRG_MyISAM engine table sharding method generally, when the data in our database exceeds records, we should consider table sharding or partition. this time I will detail some table sharding methods. Currently, all

Snapshot backup MySQL database and example 1. create logical volume Create a logical volume according to the following connection document Http://www.178-go.com/tags/lvm Requirement: physical volume 20 GB; volume Group name: vg0; logical volume 2

[MySQL optimization case] series-RAND () optimization we all know that in MySQL, if order by rand () is used directly, the efficiency is very poor because it will be executed multiple times. In fact, this is also true if the equivalent query uses

Verify MySQL master-slave consistency (pt-table-checksumamp; amp; pt-table-sync) percona-toolkit-2.2.8-1.noarch.rpm has two tools to verify MySQL master-slave data consistency Installing tookkit requires some dependent packages Yum install perl-

[MySQL case] error. log Warning: Ifacrashhappensthisconfigurationdoesnotguaranteethattherelaylo 1.1.1. If a crash happens thisconfiguration does not guarantee that the relay log info will be consistent [Environment description] Msyql5.6.14 [Error

Mysql and other languages also have many operators, including arithmetic operators, comparison operators, logical operators, bitwise operators, etc. This article introduces the mysql operators, their priorities, and examples to coders, for more

Hot backup uses the mysqldump command for backup. This tool is a built-in MySQL backup and recovery tool with powerful functions. it can back up the entire database and back up multiple databases, you can back up a single table or several tables.

There are several default configuration templates after successful installation of MySQL, the list is as follows: my-hugecnf: For high-end product servers, including 1 to 2 GBRAM, mainly run mysqlmy-innodb-heavy-4Gini: for installation of innodb

In windows, mysql5620 used mysqldumpslowpl to analyze slow logs. Today, we see a tool pt-query-digest, which was originally intended to be installed and used on windows. The result is to run C on windows: before ProgramFilesMySQLMySQLServer56b,

We always see our advantages and disadvantages in the comparison, which is the same for mongodb. the comparison study allows us to master the basic knowledge about mongodb as soon as possible. Comparison between mongodb and mysql commands relational

The following is a simple example of how to back up and restore each Database. For more details about the parameters and configurations, see related information. 1. mysql: parameter description: $ user $ password $ targethost $ port $ charset $

Mysql encoding settings MYSQL2009-09-1115: 37 read 73 comments 1 font size: Large and medium small mysqlSHOWVARIABLESLIKEcharacter_set _ %; 43; -------------------------- 43; -------------------------- mysql encoding settings MYSQL read 73 comments