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 #备份网页文件

MySQL version 5.6 Open Gtid mode, you must turn on the parameter log_slave_updates,Simply put, a binary log must be recorded on the slave. This, regardless of the cost of performance or storage, will undoubtedly increase correspondinglyThe MySQL 5.7

1, Slave_sql_running:noReason:1. The program may have been written on the slave2. It is also possible that the transaction rollback is caused by the slave machine being reset.Solution One:mysql> slave stop;Mysql> set GLOBAL

MySQL Memory usage instructions (global cache + thread cache)First, let's look at a formula in which the memory in MySQL is divided into global memory and thread memory (in fact not all, just the larger part):Per_thread_buffers=

There are two tables in the databaseT1 storing message information+-----------+------------------+------+-----+---------+----------------+|Field|Type| Null | Key | Default |Extra|+-----------+------------------+------+-----+---------+----------------

By default, MySQL will keep the mysql-bin file, so that at some point, the disk may be full, whether it is possible to delete these files, whether it can be safely deleted, is a problem.First of all, these files are MySQL log files, if not the

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

The installation process:First step: Open a terminal.Step two: Enter the sudo apt-get install mysql-server and press ENTER to enter the password.Step three: Terminal prompt "Do you want to continue?" [y/n] ". Enter Y and press ENTERFourth step: The

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

Let's go on to the previous article on adding a constraint. Three add constraints (3) Adding foreign KEY constraints ALTER TABLE table_name ADD [CONSTRAINT [symbol]] FOREIGN KEY [index_name] [Index_type](Index_col_name,...)

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

Python connects to MySQL database:In Python programming, you can use MYSQLDB for database connections and operations such as query/insert/update, but each time you connect a MySQL database request, it is independent to request access, a waste of

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 ()

--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

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

MySQL sub-table method:Method One, do the database cluster! Master-Slave database bidirectional hot backup (or one-to-many database real-time backup strategy), which can allocate database queries to several servers (can be combined with server load

Install MySQL 5.5.32 and centoscmake in CentOS 6.5 cmake under VMware10.0.4 I. Preparations 1.1 create the zhuzz/tools directory [root@localhost ~]# mkdir -p /home/zhuzz/tools[root@localhost ~]# cd /home/zhuzz/tools   1.2、upload the

Mysql stored procedure function trigger, mysql Stored ProcedureMysql stored procedure and function Stored Procedure download demo Mysql> delimiter // -- here // modify the default delimiter; mysql> create procedure simpleproc (OUT param1 INT)->

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