MySQL

Recently in the things about the FTP server, to tell the truth the FTP server is simple and simple, said that complex is also more complex. There have been a lot of articles about FTP server before, the introduction is some of the most basic

Configure:error:mysql Configure failed. Please check the Config.log for the more information. Add MySQL module to PHP times wrong Configure:error:mysql Configure failed. Please check the Config.log for the more information. Workaround:

The INFORMATION_SCHEMA database is MySQL-brought, which provides a way to access database metadata. Metadata is data about data, such as database name or table name, column data type, or access rights, and so on. Some other terms used to express

First, Xtrabackup Simple overview: Percona Xtrabackup is open source free MySQL database hot backup software, it can innodb and XTRADB storage Engine database non-blocking backup (for MyISAM backup also need to add table lock). Xtrabackup supports

Now put your heart and soul into MySQL. Project requirements: Synchronize the changes in the database in the development environment to the online environment. The solution for developers is to use the south framework, like Python, to

A notable feature of MySQL is its pluggable storage engine, so there are two types of MySQL files, one that is related to the MySQL database itself, and one that is related to the storage engine. This article mainly describes the files associated

Today we introduce the second feature of the InnoDB storage Engine-two writes (Doublewrite), and if the insertion buffer is to improve write performance, then two writes are to improve reliability, sacrificing a bit of write performance. Partial

Environment: Vmware workstation6.5 Operating system: Centos 5.2 (2 units) First station: Host Name: MYSQL1 ip:192.168.1.30 Second station Host Name: Mysql2 ip:192.168.1.32 Software Download Installation Download software Address:

Document Introduction This document uses Mysqldump to back up the database, mysqldump is a SQL-level backup mechanism that guides the data tables into SQL script files and is relatively appropriate when upgrading between different versions of MySQL,

Open profile Mysql> SELECT @ @have_profiling; +------------------+ | @ @have_profiling | +------------------+ | YES | +------------------+ 1 row in Set (0.00 sec) Mysql> SELECT @ @profiling; +-------------+ | @ @profiling | +-------------+

1.1.1. mysql5.6.14 encountered an error while migrating datadir "Environment description" The Perconamysql 5.6.14 is installed on machine A, the database is deactivated, the DataDir path is Patha, and the initialization of the application database

MySQL automatic backup is critical, especially for DBAs. Here the main use of code to illustrate this issue, I hope to help you. You can put this script into the crontab, perform it once every morning, and automatically back up. This script

#!/bin/bash #author: Itnihao #mail: itnihao@qq.com #date 2013-02-18 #version v1.0 #function: Repair MySQL table user=root password=123456 host=192.168.1.10 database=$ (Mysql-u${user}-p${

MySQL stored procedures are not easy to use, generally in the application development process is not recommended. But sometimes in the environment such as data migration, especially involves the complex point of logic processing, requires the

1), id column select identifier. This is the Select query serial number. This is not important, the query sequence is the order of the SQL statement execution2), Select_type columns are common: a:simple: Represents a simple select query that does

This article describes seven types of MySQL indexes. In a database table, indexing a field can greatly improve query speed. By leveraging these indexes, you can make MySQL queries and operations more efficient.First, introduce the type of indexMySQL

ALTER [IGNORE] table Tb_name alter_spec,alter_spec ....Alter_specification:ADD [COLUMN] create_definition [first| After column_name]--Add a new fieldAdd index [index name] (index_col_name)--Adds an indexed nameAdd PRIMARY Key

1. Server-level lock waitsthe thread ID of the wait lock can be seen through show processlist, but there is no way to know exactly which thread holds the lockcan be mysqladmin by debug The associated thread waiting for the lock and who holds the

Environment Preparation:MySQL installation package: mysql-5.7.17.tar.gzYum Source:[Email protected]_1 ~]# Cat/etc/yum.repos.d/server.repo[Local]Name=localBaseurl=file:///mnt/cdromGpgcheck=0Enabled=1[[Email Protected]_1 ~]#System version:[Email

Troubleshoot the deadlock caused by index_merge and index_mergeOverview I checked a deadlock problem a few days ago and was puzzled at first, because the two deadlocks are single-statement transactions with the same statement type (where attribute