MySQL

First, modify the Linux default IO scheduling algorithm.Linux default IO scheduling algorithm for CFQ, need to be modified to dealine, if it is SSD or PCIE-SSD device, need to change to NoOp, you can use the following two ways to modify.1, online

First Spit slot Linux, I wipe, the full command of the exercise is really a pain in the egg. Many people say that Linux, indeed, I am the lowest Linux server fully enough, but really feel that the configuration of things to do not have Windows

Last night tossing all day, finally installed in Linux environment successfully MySQL database, first with command rpm-qa| grep MySQL, check if MySQL is already installed on your computer. If so, if it is not installed, but there are dependent

Drop trigger IF EXISTS T_trigger;Create Trigger T_triggerBefore insert on AAA for each rowBeginINSERT into Readandwrite_test.user (time) VALUES (new.timeline);End/*Insert: Activates the trigger when inserting a new row into the table, for example,

1. First check if mysql,rpm-qa|grep-i MySQL is installed2, if already installed, first uninstall the old, Rpm-e--nodeps3, installation, there are three installation packages are as follows:Mysql-server-5.6.15-1.linux_glibc2.5.i386.rpmmysql

A function that generates the following 15-bit random number:delimiter $ $CREATE  FUNCTION  ' Getrand ' (counts integer)  returns varchar   Charset utf8begin    declare stemp varchar (;    ) declare stempcounts integer;       set stemp =   round

1, first off B, the data of a to export, mysqldump-hlocalhost-uroot-p123456--database IBPRPU >ibprpu.sql2. Turn off A, start B, enter MySQL to create a new database Ibprpu3, Import Database mysql-hlocalhost-uroot-p123456 or go to MySQL and import

Refer to this article: (But I disagree with this article)http://blog.csdn.net/leshami/article/details/397795091: Build a test environmentCREATE TABLE T(t Int (ten) primary key auto_increment);Mysql> Show variables like '%increment% '; +--------------

1. Download a version of the MySQL free install version.The following can be consulted.: Http://url.cn/YXTsSU can be downloaded directly. This version is a stable version of 5.0. Noinstall2. Unzip the downloaded file to a certain place. For example,

1. QuestionsThere is a table data as shown. In the data, the running_number should be a continuous 5-bit character. Now you need to get to the running_number that the connection is broken off. If the 00002,00003,00004 between 00001 and 00005 is

DROP TABLE IF EXISTS ' t_areainfo '; CREATE TABLE ' t_areainfo ' (' id ' int (one) not NULL auto_increment, ' level ' int (one) DEFAULT 0, ' name ' varchar (255), ' Parenti d ' Int (one), ' status ' int (one) default 0, PRIMARY KEY (' id '))

One, backup and import of database1), Backup of the database1. Export the entire databaseMysqldump-u user name-p database name > exported file nameExample:mysqldump-u dbadmin-p myblog >/home/zhangy/blog/database_bak/myblog.sql2. Export a

Install mysql and centosmysql in Linux (CentOS 6.5) There are many ways to install software in linux. Here we use simple and convenient yum for installation. 1. Use yum to install the mysql service and client 1. Check whether yum list installed |

The last step of installing mysql 5.5 win7 always stops responding. Today just began to install the 64-bit version of mysql5.5, the installation is very smooth, and later found that the library is not compatible with the problem, so uninstall,

(15) mysql triggersOverview A trigger, as its name implies, executes a program when something (event) occurs. Trigger has four main elements: Monitoring location (table_name), monitoring event (insert/update/delete), triggering time (before/after),

Mysql releases SpaceMysql releases SpaceSome tables in the production system use delete to delete some rows and the space is not released.Cause: similar to the high-water line production principle of OracleSolution: Method 1: Execute the optimize

Differences between status and variables in mysql Optimization Differences between mysql status and variables First, you can use the following two commands to view the corresponding mysql system parameters. Show status like '% abc % '; Show

Mysql recursive query tree table Drop table if exists 't_ areainfo '; create table 't_ areainfo' ('id' int (11) not null AUTO_INCREMENT, 'level' int (11) DEFAULT 0, 'name' varchar (255), 'parentid' int (11), 'status' int (11) DEFAULT 0, primary key (

Install MySQL in Linux1. Download the MySQL Installation File to install MySQL requires the following two files:MySQL-server-4.0.16-0.i386.rpmMySQL-client-4.0.16-0.i386.rpmFor: http://www.mysql.com/downloads/mysql-4.0.html, open this page, drop-down

MySQL can be connected locally and the remote connection fails. I have encountered the problem that MySQL can be connected locally but cannot be connected remotely. I have not recorded the problem. I encountered this problem on the new server