mysql query checker

Pt-duplicate-key-checkerThe function is to find duplicate indexes and foreign keys from the MySQL table, the tool lists the duplicate indexes and foreign keys, and generates a statement to delete the duplicate index, which is very convenient   find

Let's take a look at the basic features of MySQL: 1. Internal Components and portability Written using C and C + + Tested with a number of different compilers Able to work on many different platforms. See 2.1.1 "MySQL Supported

today's plan to install the experience: Percona-toolkit_3.0.4-1.jessie_amd64.deb to detect MySQL indexes and slow query analysisbut encountered the lack of: libmysqlclient18 and Libdbd-mysql-perl

First, MySQL commonly used statementsCreate, delete, and most basic queries:Display database mysql->show databases;Create DATABASE Mysql->create db;Delete database Mysql->drop db;Select Database Mysql->use dbCreate Tables Mysql->create table MyTable

Usage of mysqltoolkit [memo] bitsCN.com Mysql toolkit is a small plug-in used to monitor and analyze databases. it is usually used to call perl to analyze and compare the current environment and database. it is worth learning.

Analysis of index transformation in MYSQL management As a mysql dba, you need to regularly check the indexing status of the server, especially when you arrive at a new environment and start to take over some database maintenance work, you need to

Here is the MHA from boot, to failover's complete manager.log, and all of the MySQL General.log in the cluster. We can learn more about the workings of MHA through these logs. There is a lot of help in using good MHA.The architecture is as

More comprehensive MySQL optimization reference (next) 8 replies. This article has compiled some general MySQL optimization methods, a simple summary share, designed to help those who do not have full-time MySQL DBA to do basic optimization work, as

Introduction of Percona-toolkit Tools The Percona-toolkit, "PT Tool", is a collection of advanced command-line tools for performing various MySQL and system tasks that are complex and cumbersome to perform by hand, including: Check the consistency

Background Description: Friends Unit OA system soon completed upgrade big transformation, back end with the MySQL storage data, on-line ran for a month, complaining about the phone began to dozen, not here, is not open, there is no response, some