"High availability MySQL" 1–windows environment compressed version of MySQL installation

Recently in Reading O ' Reiliy series of"High availability MySQL", it is natural that the master-slave (master-slave) configuration and scale-out related content.Master-slave this thing. It is standard in many companies. In the development of the

Shared and exclusive locks in MySQL

original link Row-level locks, table-level locks, page-level locks are described in MySQL, row-level locks are the most granular lock in MySQL, and row-level locks can significantly reduce database operation conflicts. Row-level locks are

MySQL Group Replication

This article mainly explains the MySQL group replication Introduction, the article related to the Mysql,group content, hoped to be helpful to everybody."MySQL Group Replication"The group replication is an open source plugin developed by MySQL and is

MySQL inquiry null and NOT NULL

Original: http://blog.csdn.net/fwkjdaghappy1/article/details/7703974/Believe that a lot of people who have been using MySQL for a long time, the concept of these two field properties is not very clear, the general will have the following questions:1,

Php+mysql Member System Development Example Tutorial

md5

This article mainly introduces the Php+mysql Member System Development example tutorial, through a complete membership system development, further deepen the understanding of the Php+mysql program design process, the need for friends can refer to

How to quickly resolve MySQL 1032 master-Slave errors

3 minutes to resolve MySQL 1032 master-slave errorPart1: Writing at the top1032 Error----Now a lot of data in the production library, in the wrong delete from the library, the production database is not found after the update, and now the master

"Original" no Brain operation: Windows 5.5 + MySQL installation use and free installation

This article describes the installation and use of MySQL 5.5 in a Windows 10 environment and is free of installationResources Download:MySQL installation file: http://download.csdn.net/detail/lf19820717/9892711MySQL free install file:

"Turn" Nodejs Learning Notes (iv)---interaction with MySQL (felixge/node-mysql)

Directory Introduction and Installation Test MySQL Meet Connection Options MYSQL Curd Insert Update Inquire Delete Nodejs call a stored procedure with an out parameter and get the return

MySQL Database sub-table partition (i)

In the face of today's big data storage, imagine a significant drop in performance when the total record of a table in MySQL exceeds 1000W? The answer is yes, the total record of a table is more than 1000W, and retrieval at the OS level is also a

Using full-text indexing in MySQL (fulltext index)

Using full-text indexing in MySQL (fulltext index)A useful feature of MySQL is the ability to find text using full-text indexing (fulltext index). Currently only valid when using the MyISAM type table (MyISAM is the default table type, and if you

MySQL data type

Numeric typeMySQL supports all numeric types in standard SQL, including strict data types, INTEGER,SMALLINT,DECIMAL, NUMBERIC as well as approximate numeric data types FLOAT,REAL,DOUBLE PRESISION , and expands on this basis. This extension adds

MySQL Group Replication Introduction

"MySQL Group Replication"The group replication is an open source plugin developed by MySQL and is a tool for implementing MySQL's highly available clusters. The first GA version is officially released in MySQL5.7.17; To use group replication you

MySQL lock mechanism detailed and deadlock processing method

In order to better optimize MySQL in high concurrency, it is necessary to understand the locking table mechanism when MySQL query is updated.I. OverviewMySQL has three levels of Lock: page level, table level, row level.The MyISAM and memory storage

Original Centos7 configuring MySQL from zero compilation

Preface It's a tough time to play. In addition to the compiler using Yum installation, all others are compiled manually. Hum ~Seemingly on Nginx, PHP, MySQL three east, but they are too much to rely on others.There is no way to use them to be

MySQL query today, yesterday, nearly 7 days, nearly 30 days, this month, last month data

Recent projects have used the function of querying the data record of the month, the initial idea is to construct a good time period in the logic business query, when writing SQL statements feel very troublesome. So I went to search the Internet to

MySQL Binlog maintenance detailed analysis (open, Binlog related parameters function, Mysqlbinlog interpretation, binlog delete)

Binary log role: the main implementation of three important functions: for replication, for recovery, for auditing.Binary Log related parameters:Log_binSetting this parameter means enabling the Binlog feature and specifying the path

atitit MySQL stored procedure captures all exceptions, as well as logging exception information

atitit mysql stored procedure captures all exceptions, as well as logging exception information1.1. exception Handling mode exit continue undo Mode 11.2. capturing all exceptions using DECLARE continue HANDLER for SqlException 11.3. capturing

Native JDBC, jdbc

Native JDBC, jdbc JDBCJava DataBase Connectivity and java DataBase connection are Java APIs used to execute SQL statements.JDBC is a Standard Specification for Java database access. It provides unified access for different relational databases. It

Mydumper principle and mydumper Principle

Mydumper principle and mydumper PrincipleInstallation of mydumper: http://www.cnblogs.com/lizhi221/p/7010174.htmlMydumper Introduction MySQL's mysqldump tool supports single-threaded operations. Multiple tables are exported one by one without a

MySQL basic Tutorial: mysql5.7.18 installation and connection tutorial, mysqlmysql5.7.18

MySQL basic Tutorial: mysql5.7.18 installation and connection tutorial, mysqlmysql5.7.18 Starting from this article, I will use a new series of articles to introduce and learn MySQL. Why do we need to learn MySQL? From a product perspective, most

Total Pages: 3233 1 .... 399 400 401 402 403 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.