PHP

MySQL5.6 replication: Advantages and limitations of GTID (part 1) bitsCN.com The Global transaction Identifier (Global Transactions Identifier) is a new feature of MySQL 5.6 replication. It provides multiple possibilities for DBAs who maintain

[MySQL] InnoDB row format analysis bitsCN.com [MySQL] InnoDB row format analysisLike most row-based databases, InnoDB stores records in the row format. It provides two formats: Compact and Redundant.CompactThe Compact format is introduced only when

One MySQL server starts multiple ports: bitsCN.com One MySQL server starts multiple ports In the test Mysql multi-master and one slave server, that is, one slave server synchronizes multiple ports to different master databases. This document

Mysql updates multiple different records at a time, bitsCN.com Mysql updates multiple different records at a time Recently, a friend in oschina asked me how to update multiple different records in mysql. I know two methods: on duplicate key update

Install and run two mysql database instances bitsCN.com on one server Install and run two mysql database instances on one server To facilitate the test, we want to use two mysql database instances. Take windows as an example Of course,

How MYSQL master/slave server is configured How MYSQL master/slave server configuration works I. principle of master-slave configuration: Mysql Replication is an asynchronous Replication process, from one Mysql instace (we call it the Master) to

Magic MySQL partition bitsCN.com Amazing MySQL partition = First View result = There are two tables with the same structure: no_part_tab and part_tab. one uses partitions and the other does not. The result is as follows. Mysql> select * from

What is Database Sharding technology bitsCN.com? What is Database Sharding technology? I. Overview Table Sharding is a popular concept, especially in the case of large loads. table Sharding is a good way to distribute database pressure. First,

The failover processing process bitsCN.com after the master database of db0101 is down in 48 nodes groups online Failover processing after 48 nodes in the online group and db0101 master database are down When a call is received, db0101 is Down and

Set up the second mysql instance bitsCN.com with Port 3306 in the case of the mysqld service. Create a mysql instance with the second port 3306 in the case of the original port 3308 mysqld service 1 download the tar.gz [root @ 472322 tmp] #

[MySQL] install bitsCN.com in Linux MySQL-5.6 source code [MySQL] Linux MySQL-5.6 source code installation This article describes how to install MySQL 5.6 in the source code of centos. the centos version is 5.8. 1) first, you need to go to the

Repair of grub boot and modification of default startup items for Ubuntu after Windows and Ubuntu are reinstalled BitsCN.com Repair of grub boot and modification of default startup items after Windows and Ubuntu are reinstalled Today, he helped

Mysql concatenation operator bitsCN.com Mysql join operator 1. the effect of the comma-separated JOIN operator is similar to that of inner join: [SQL] Select t1. *, t2. * from t1, t2 where t1. I = t2. I; It is equivalent: [SQL] Select t1

Paip. mysql Performance Test report homeright bitsCN.com Paip. mysql Performance Test report home right Environment: xpsp3, mysql5.6.12 Hard disk information: Serial: WD-WMAV29469153 Capacity: 160.0 gB (149.0 GB) Cache size: 8192 KB Large File

MySQL's 101 tuning and optimization tips: bitsCN. comMySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limit. Here are 101 Tips for adjusting and optimizing MySQL

Evergrande mighty! Some basic knowledge about SQL review bitsCN.com First, Evergrande Weiwu! Start. Relational algebra: Currently, mainstream relational databases are built on relational algebra, that is, their mathematical support is relational

LINUX summary article 4th: installing and using mysql bitsCN.com in LINUX To install mysql in LINUX, you must install both the client and server. Because the mysql system is distributed, both the server and client systems exist. The server system

How to solve the problem of forgetting the password of mysql in Windows bitsCN. comWindows Mysql5.0 Http://www.bitsCN.com/article/21984.htmMethod 1: 1. input in DOS window net stop mysql5 Or net stop mysql 2. open a DOS window and switch to

Mysql optimized the method of slow random data retrieval. bitsCN.com the day before yesterday because of work requirements, I randomly extracted several records from a database with a 5 million records, here, I directly use the mysql rand by

MySQL-four methods for modifying the root password (taking windows as an example) bitsCN.com Method 1: Use the set password command First, log on to MySQL. Format: mysql> set password for username @ localhost = password ('New password '); Example: