MySQL

MySQL slow log query for the optimization of SQL is still very meaningful, specifically, how to open this MySQL slow query log (default is turned on).There are a lot of official manuals or online settings for MySQL, but note that the mysql5.6 with

1. Database management1.1 CREATE DatabaseCreate Database Firstdb;1.2 Show view all databasesmysql> show databases;+--------------------+| Database |+--------------------+| Information_schema || Firstdb || MySQL || Performance_schema |+---------------

Storage of MySQL data on disk:Data BLOCK:A block of multiple disk blocks in which the storage engine manages data blocks.A disk is a block device, and the data stored on disk is stored in blocks.When MySQL reads the table into memory, it is also

installation of MySQL  A, download mysql        http://dev.mysql.com/downloads/mysql/II, installation         $tar-XZVF mysql-5.1.45-osx10.6-x86_64.tar.gz        $sudo  mv mysql-5.1.45-osx10.6-x86 _64 /usr/local/mysql        $CD  /usr/local       

IndexAn index is a special kind of file (an index on a InnoDB data table is an integral part of a table space), and they contain reference pointers to all records in the datasheet.An index exists to increase the speed of query execution.To create an

One, Structured Query language SQL 1.SQL Advantages:A. Not a specific database vendor language, all DBMS supports SQLB. Simple and easy to learn, case insensitiveC. SQL is a powerful language that uses its elements flexibly to manipulate complex and

Build table: (NOT NULL, auto_increment, unique, primary key)Create Database Balfish;Use Balfish;CREATE TABLE Mytable1 (ID int NOT NULL,Name varchar (20),Grade int);INSERT into mytable1 values (' 1 ', ' Yang ', 97);INSERT into mytable1 values (' 2 ',

1. Create database IF not EXISTS yourdbname DEFAULT CHARSET UTF8 COLLATE utf8_general_ci;Create DATABASE Yourdb DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;2. Switch database use DatabaseName;3. Deleting a databaseThe drop command is used to

1. Database stored procedures: Simply put, a stored procedure is a program stored in a database.2. The database stored procedure functions:First: The stored procedure is running faster because the SQL statement has been pre-programmed Yi.HTML code

DECLARE startTime VARCHAR (+) Default ' 2014-00-00 00:00:00 ';DECLARE temptime VARCHAR (+) default now ();DECLARE endTime VARCHAR (+) Default date_sub (Temptime,interval ' 3 ' MONTH); --Three months back timeDECLARE monthstr VARCHAR (7) Default

The use of havingHaving words allows us to filter the various data after the group, where the words are filtered before aggregation, that is, before group by and having a sentence. The HAVING clause filters the group records after aggregation.SQL

Operating system version: CentOS release 6.5 (Final) 2.6.32-431.el6.x86_64 #1Memory: 32GCpu:intel (R) Xeon (r) CPU e5-2450 v2 @ 2.50GHz (logic 32 Core)Disk: PCIE-SSD (model later)File system type: EXT4MySQL database version: Server Version:5.6.22-72.

1. Download the installation packageDownload. RPM Format installation package, requires the following two files:mysql-server-5.0.26-0.i386.rpmmysql-client-5.0.26-0.i386.rpmNote: When the official website downloads, if chooses the Linux generic

1. InstallationSee if you have installed: Yum list installed mysql*See if there is an installation package: Yum List mysql*Install MySQL client: Yum install MySQLInstall MySQL server side: Yum install mysql-server yum install Mysql-devel2. Start &&

1, configuration onLinux:Added in MySQL config file my.cnfLog-slow-queries=/var/lib/mysql/slowquery.log (Specify the log file location, can be empty, the system will give a default file Host_name-slow.log)long_query_time=2 (record over time, default

Because of the drbd+mysql+heartbeat done before. Feel high available to do is not thorough enough. Just understand the next amoeba. Document Address:http://docs.hexnova.com/amoeba/index.html Download:

One. Install MySQLWindows, download the MySQL installation file directly, double-click the installation file next to proceed;Linux installation is also very simple, in addition to download the installation package for installation, the General Linux

ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using passwordMySQL ERROR 1045 (28000): Access denied for user workaroundProblem Recurrence (The following discussion is for Windows environments only):c:\appserv\mysql> mysql-u

DELIMITER $ $CREATE FUNCTION ' test '. ' Getdistance ' (latbegin float (10,4), Lngbegin float (10,4), latend float (10,4), lngend Float (10,4)) RETURNS float (10,4) begindeclare Distance Float (10,4) DEFAULT 0.0000;declare Earth_radius float (10,4

To create a test table:MariaDB [music]>CREATE TABLE summary (ID int,info char);Query OK, 0 rows affected (0.05 sec)MariaDB [music]>show tables;+-----------------+| Tables_in_music |+-----------------+| Summary || Test |+-----------------+2 rows in