MySQL

1. Source code package Download: HTTP://DOWNLOAD.SOFTAGENCY.NET/MYSQL/DOWNLOADS/MYSQL-5.1/2. Compiling the installationGroupadd Mysqluseradd-R-g MySQL MySQLmkdir/data/mysql_multi/mysql_exa1/CD/data/mysql_multi/mysql_exa1/mkdirData Binlog

The reason why MySQL is garbled is that there are several reasons:1, stored in the database before the garbled2, stored in the database process garbled3, stored in the database after garbledWant to know where the garbled is very simple, in the

MORE: http://www.webyang.net/Html/web/article_138.htmlMySQL is often used to query specific fields, and occasionally need to show a certain part of the value in a particular field, how to deal with it?Then there are fuzzy queries, if you need to

Master-Slave synchronization principle:Execution of any SQL statement on the primary server will write the statement to the Mysqlbinlog binary log, from the server will always synchronize to update the binary log file to the local, and then the log

1. Install/remove of the service denied! error occurred while installing MySQL serviceToday in a machine (OS for windows7 64bit) The MySQL5.6.16 database, looked at the next machine, before the installation of MySQL, but did not start the

CentOS 6.4 Under compile install MySQL 5.6.14Overview:In CentOS 6.4, the installation of MySQL via Yum is version 5.1, older, so you want to install the high version of 5.6.14 via source code. Body:One: Uninstall the old versionUse the following

DDL: Database Definition languagePrimarily used to define databases, tables, views, indexes, triggers, and moreCreate: Primarily for creating databases, creating tables, and creating viewsAlter: Primarily used to modify the definition of a table,

Many times we want to get a continuous set of data from a row in the middle, for example, starting from line 10th to query 10 rows of data, which is used more in the forum database, because the Forum's reply is often hundreds of, need pagination

First step : Turn on all MySQL server's bin log, each server set a unique Server-id value (default is 1, generally take IP last paragraph)Modifying the my.cnf of the primary server (master)[mysqld] log-bin=Mysql-binserver-id=91Modify the MY.CNF from

1. To optimize the query, avoid full-table scanning as far as possible, and first consider establishing an index on the columns involved in the Where and order by.2. Avoid null-valued fields in the WHERE clause, which will cause the engine to

1. First check whether the profiling function is turned on like ' %pro% 'OrSELECT @ @profiling2. Open ProfilingSET Profiling=13. Execute SQL statementsFor example:SELECTTable_schema as 'Db Name', ROUND(SUM(Data_length+Index_length)/ 1024x768 / 102

For automated operations, such as backup recovery, DBAs often need to encapsulate SQL statements into shell scripts. This paper describes several methods of SQL statements for shell scripts in MySQL database under Linux environment, for your

Because of its free, MySQL database is used more and more extensively in the project, and its security can be particularly high, no less than large database software such as Oracle. To put it simply, in some small and medium-sized projects, using

The first MySQL automatic backup script.#!/bin/bash#auto backup MySQL database for test#by HagBackcmd=/usr/bin/mysqldumpDbuser=rootDbpasswd=admin123Databasename=testBackup_dir=/opt/backup/mysqlif [!-D $backup _dir]; ThenMkdir-p $backup _dirFiIf

The New Year's egg pain, so look at MySQL optimization, read a lot on the internet on the optimization method of pagination, but, I personally try on a time, did not appear they said the phenomenon ... Is it my machine problem?Take a look at my

Sometimes when the program is updated, the database load suddenly comes up, or the number of concurrent doubled. This time if with show full processlist; There is no full SQL at all. How to see what SQL is causing it, on the Internet to check the

MySQL engine learning notes MySQL has the following engines: ISAM, MyISAM, HEAP, InnoDB, and Berkley (BDB ). Note: different versions support different engines. Of course, if you feel that you are indeed highly skilled, you can also use MySQL ++ to

Use the AB command on the Apache server for stress testing AB is a performance testing tool for Apache Hypertext Transfer Protocol (HTTP. It is designed to describe the execution performance of the currently installed Apache, mainly to show how

Install and optimize Mysql in LinuxSystem Environment: CentOS 6.5Mysql version: mysql-5.6.19.tar.gzSoftware upload path:/doiido/soft1. Install Mysql1: Firewall opens the corresponding port#/Sbin/iptables-I INPUT-p tcp -- dport 3306-j ACCEPT#/Etc/rc.

MySQL Stored Procedure The Mysql stored procedure is actually a function, which can execute multiple SQL statements and create temporary variables.For example, the main functions of the following stored procedure are:(1) create two temporary