MySQL

For large data volume of query processing, remember to use Explian to see, as far as possible optimization For example: Explain select surname,first_name form A, a where a.id=b.id Explain Explanation: Table: The data that

Personal original address:http://www.phpthinking.com/archives/433 In the database we usually index some of the fields, which can improve the query speed of the data, and improve the performance of the database like order by, the group by before the

1 mmm high-availability MySQL solution1.1 Program IntroductionMMM is Master-master Replication manager for MySQL (MySQL master replication Manager) a set of scalable scripting suites for monitoring, failover, and management of MySQL primary master

1. Create database create database lush;2. Delete Database drop database lush;3. Select the database use lush;4. Create user Grant  all on *.* to  ' lush ' @ '% '  identified by  ' 123456 '; 5. CREATE TABLE create  Table zhu (Id int,name varchar (20)

Description, check and repair of MyISAM tables.Used without options all tables on the command would be a checked for errorsUsage:myisamchk [OPTIONS] tables[. MYI] Global Options: -H,--help display this Help and exit. -?,--help display this help and

Introduction to the three paradigmsThe paradigm of the table: only the first normal paradigm can satisfy the second paradigm, and the third paradigm can be satisfied further.1. The first paradigm :The columns of the table are atomic and can no

Two MYSQL databases availableOne is 192.168.1.1 Port 3306 has a database DB1 a table TABLE1One is 192.168.1.2 Port 3307 has a database DB2 a table TABLE2192.168.1.1 remote connection 192.168.1.2 The user name Root1 password used by the database root1

MySQL version is more than 5.5Semi-synchronous definition: The primary server side performs a write operation and must be copied from the server side to return the submission status to the client.Here we need to install semisync_master.so from the

OverviewUsually to test the performance of some tools, you have to use data to speak. The data can be objectively verified by some things. For example, the performance of some database middleware, for a beginner will only see the surface of the Kua.

Sorting by index optimization: ORDER BYSingle-Table query:The order of the indexed columns is exactly the same as the ORDER BY clause, and all columns are sorted in the same direction,MySQL can use an index to sort the results. The ORDER BY clause

1. Configuring the Log4net.config File-->""-->2. Project Start-Up officeLog4net. Config.XmlConfigurator.Configure ();3.assemblyinfo.cs[Assembly:log4net. Config.xmlconfigurator (configfile = "Log4net.config", Watch = True)]4. Call Log4netLog4net.

Database performance is critical to a data-centric application that directly affects the performance of the program. In general, to ensure the efficiency of the database, to do the following four aspects of the work: database design, SQL statement

In this section we want to talk about MySQL master-slave replication, the reason for master-slave replication, mainly can read and write separation, reduce the pressure of MySQL server. So let's take a look at how to implement master-slave

Display effect:Traditional writing:echo "This is a test";echo "ASDFASDFADSF";$mysql _server_name= "localhost"; Database server name$mysql _username= "root"; Connect to database user name$mysql _password= "??????"; Connect Database Password$mysql

How to turn on MySQL remote account2008-07-09┆13,114 views┆179 Tags: Remote AccountThere are two major strides in opening MySQL's remote login account:1. Determine that the firewall on the server does not block port 3306.MySQL default port is 3306,

Installation of navicat_for_mysql_10.0.11 under LinuxOfficial: http://www.navicat.com/cn/download/download.htmlNavicat_for_mysql_10.0.11_cn_linux.tar.gzHow to use:1. Open Terminal: Application---system tools (or accessories), terminal, switch to

First, define the concepts of character sets and proofing rules:Character Set (charset): A set of symbols and encodingsProofing Rules (collation): A set of rules that are used to compare characters within a character set, such as rules that are case-

#!/bin/sh# ****************************************************************************# Filename:# master_slave_configure.sh# Function:# Automatic configuration of Master to slave.# Author:# [Email protected]## Usage

Install, configure, and set the encoding format for mysql 5.6.20. I,Install Installation environment System: Window 32 Version: Mysql 5.6.20 1,First download Mysql 5.6.20 Win32 version from the official website http://dev.mysql.com/downloads/mysql/

Clear, delete, and modify mysql tables. I. Clear mysql table data Delete from table name;Truncate table name;The delete statement without the where parameter can delete all content in the mysql table. You can also use the truncate table to clear all