At the beginning of the study, Baidu to check, but found a lot of said too complex and difficult to understand, combined with each article summed up (suggest probably read the text, do not understand it does not matter, then look at the diagram of
1, two machines, install a consistent version of MySQL192.168.29.128 (Master) MySQL-5.6.21192.168.29.129 (slave) MySQL-5.6.212. Configure MasterConfigure binary log and server ID[[Email protected] ~] # vi/etc/my.cnfThe configuration is as
Win7 64-bit how to install the configuration mysql-5.7.5-m15-winx64It's been a long time since MySQL was last installed. Steps these, there may be forgotten. Simply record it. (Refer to blogs on some networks.) )1.mysql-5.7.5-m15-winx64.zip
MySQL Cluster is a technology that allows the Cluster of an "in-memory" database to be deployed in a system that is not shared. With no shared architecture, the system can use inexpensive hardware and has no special requirements for hardware and
Many MySQL programs come with the ability to log on anonymously. After you've just installed MySQL, you can log in to the database.This is basically nothing to use MySQL, but if we want to deploy the database, this type of login can never exist!
http://hi.baidu.com/wylinux/item/cbc458c2984381300831c651 View Index CommandsMysql> Show index from Tblname;Mysql> show keys from Tblname;· TableThe name of the table.· Non_unique0 if the index cannot include a repeating word. 1 if it is possible.·
http://toptree.iteye.com/blog/812642 today, in the development of the mail system to find a lot of mail is not sent successfully, want to manually change the data. Find the MySQL date functionThe obtained pubtime is a string type, which is converted
[MySQL Optimizer]--How to find the reason for SQL efficiency underground
Source: Chinaunix Blog Date: 2009.07.20 16:12 (Total reviews ) I want to comment
Reprinted from Http://www.cnblogs.com/ggjucheng/archive/2012/11/05/2755683.htmlThe syntax of loadLOAD DATA [Low_priority | CONCURRENT] [LOCAL] INFILE ' file_name.txt ' [REPLACE | IGNORE] into TABLE tbl_name [Fields [TERMINATED by '
MySQL database MyISAM storage engine to InnoDB before the company's database storage engine is all MyISAM, the amount of data and access is not very large, so there is no problem. But recently the MySQL data table is often locked, directly caused
1. About multi-table queriesI understand: Since MySQL multi-table query when the connection between the table is a Cartesian product, so as little as possible to use a multi-table query, if used to use nested statementsExample: Description: '
PHP connection MySQL is the first step in the database operation, in PHP, you can use the built-in PHP function mysql_connect () to implement, the function format is mysql_connect ("MySQL hostname", "MySQL User name", "MySQL password" ), the
MySQL replication is a multi-MySQL database master from a synchronous scheme, characterized by asynchrony, widely used in a variety of situations where MySQL has higher performance and higher reliability requirements. Another technique that
Basically, there are 3 ways to represent an inheritance relationship in SQL.respectively, 1 table Inheritance (TPH), 2 table Inheritance (TPC), 3 table Inheritance (TPT)1 table:PersonID Type name Classroom office1 student Keat 1 b NULL2 teacher
MySQL floating point representation
MySQL floating-point and fixed-point types can be expressed by the type name plus (M, D). M indicates the total length of the value, and D indicates the length after the decimal point, M and D are also called
MySQL Database Study Notes (12) ---- use of the open-source tool DbUtils (Database addition, deletion, modification, and query), mysqldbutils
[Statement]
Reprinted, but keep the original source of the article → _ →
Life One:
MySQL database usage process, code explanation, mysql usage process
Database usage process:1. Registration driver;2. Use DriverManager. getConnection to obtain the connection object con;Method:3. Use the createStatement () method of the connection
Mysql stress test script instance and mysql stress test instance
This article describes the mysql stress testing script for your reference. The details are as follows:
Create Table DEPT Copy codeThe Code is as follows: create table dept (/*
Mysql show command usage details, mysqlshow
This document describes how to use the show command in a mysql database.
A. show tables or show tables from database_name; -- displays the names of all tables in the current database.
B. show databases; --
Notes for converting MySQL from MyISAM engine to InnoDB Engine
After analyzing the differences between the two engines, you can easily know the key points.
In general, considerations for switching from MyISAM to InnoDB include:
1. In the primary key
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service