MySQL

Installing Percona-xtrabackuphttp://990487026.blog.51cto.com/10133282/1759237[email protected]:/backup# cat xtrabackup.sh  #!/bin/bash Backdir=/backup/mysql Web_page_ Backdir=/backup/user=r**t pass=a**********t logfile=innobackupex.log #备份网页文件

MAC OS10.11 Install and configure MySQL, mainly diagram, step I briefly explain.First visit the MySQL official website and download the installation program, of course, before downloading you need to register a line account.Website address: MySQL

There are no mysql-sever files in the Yum source for CentOS 7 and need to be downloaded from the official website:1. Download the rpm file that supports Mysql-sever# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm2. Install

mysql5.6 started to support Online DDL, and online DDL provides the following benefits;1 Improve production environment availability 2 during DDL execution, you get the balance of performance and concurrency, you can specify the LOCK clause and the

On the multi-level menu bar or the authority system in the hierarchical tree traversal, Oracle has connect by to implement, MySQL does not have such a convenient way, so MySQL traversal data table is often we encounter headache problem, the

Xtrabackup is a physical backup tool that supports the INNODB and XTRADB storage engines, and it has the following features:(1) The backup process is fast and reliable;(2) The backup process does not interrupt the transaction being performed;(3) can

Initialize table structure DROP TABLE IF EXISTS ' data ';create TABLE Span class= "hljs-string" > ' data ' ( ' dates ' varchar (255 ) character set UTF8 default null , Span class= "hljs-string" > ' id ' int (11 ) Span class= "Hljs-keyword"

Query a comma-delimited field, you can use the String function Find_in_set ();Query a field in a database table (the value is displayed as a branch), you can use function in ().Today's work encountered a problem, is to use the Find_in_set ()

Install MySQLInstalling MySQL and Php-mysqlConfigure MySQL[[Email protected] ~] #vim/etc/my.cnf Edit the MySQL configuration file [mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Default to using old password format for compatibility

--1:case when--SELECTCaseWhen (admin_id are NULL) Then ' no creator 'When (admin_id = 0) Then ' admin 'ELSE admin_idEND as admin_idFrom Hsb_investor--2:if else is not available in the SELECT statement. A process that can only be used to control SQL

First, data backup　　1. Backup with mysqldump commandThe mysqldump command backs up the data in the database into a text file. The structure of the table and the data in the table are stored in the generated text file.The mysqldump command works very

1. Go to MySQL official website: http://www.mysql.com/2. Enter: Downloads, Community, MySQL on Windows/mysql Installer, MySQL Installer3. Because we are locally installed, select the full version hereNote: Click on the download, will jump to the

/* Look at the table */describe test --view the structure of the table show create table test --view the table creation statement Show create  table test  \g --queries the created statement and normalizes the display (this command is supported only

Operating system cluster size is generally 4K, and InnoDB page size is generally 16K, then it is possible that 16K pages are not stored in a continuous cluster, so that the scanning software will not scan out such a page. To solve this problem, we

It should be known that the InnoDB Single-column index cannot exceed 767bytes, and a federated index has a limit of not more than 3072 length. mysql> CREATE TABLE ' TB ' ( ' A ' varchar (255) DEFAULT NULL, ' B ' varchar (255) DEFAULT

--select * from Products--select prod_name from Products/*limit 7 offset 2 */--take 7 rows of data from the second row, if less than 7 rows, then take the actual number of rows--limit 2,7--equivalentHand shake to turn over the village board, scared

With the structure and characteristics of the page, it is necessary to implement the salvage work of the database page;In order to facilitate the common use of Windows and Linux, plan to make a C language console application, and try to use only

Mysql master-slave backup and SQL statement backup, mysql master-slave SQL statement The master-slave configuration of the MySQL server is a very simple task. Instead of starting from scratch, it is always on the mysql server that has been installed

Install Mysql and windowmysql on Linux/UNIX and Windows Platforms For Mysql on all platforms: Download MySQL. Select the MySQL Community Server version you need and the corresponding platform. 1. Install Mysql on Linux/UNIX On Linux, we recommend

MySQL enables the log-slow-queries Method for slow query, logslowqueries A page of a common WEB site often needs to query n SQL statements to get the PAGE result. When the Website access speed is slow and the front-end has done a lot of optimization