show processlist

In order to quickly synchronize data needs, I staged two Python scripts, that is, two process synchronization data opened, the results of the server reported the database deadlock exception, through the troubleshooting Code and database log

Slave latency monitoring in MySQL replicationHttp://imysql.com/2014/08/30/mysql-faq-howto-monitor-slave-lag.shtmlIn a MySQL replication environment, we usually only judge the latency of the slave based on the value of the seconds_behind_master .

This article mainly introduces the latency analysis of slave monitoring in MySQL, which is mainly used in the MySQL replication environment. If you need it, you can refer to the MySQL replication environment, we usually only judge the SLAVE latency

Overview The built-in replication function of Mysql is the basis for building large and high-performance applications. This distribution mechanism replicates data from a Mysql host to another Server Load balancer instance, and execute it again.

MySQL lock Blocking Analysis During routine maintenance, threads are often blocked, resulting in slow database response. Let's take a look at how to obtain which thread causes blocking. Blog: http://blog.csdn.net/hw_libo/article/details/390808091.

I. Permission tableThree permission tables in the MySQL database: User, DB, hostThe access process of the permission table is:1) check whether the connected IP address, user name, and password exist in the table from the host, user, and password

Https://forum.eviloctal.com/thread-30618-1-1.html   Platform: RedHat as4.0 Mysql-max-5.0.16-linux-i686 (original)Author: jiang313hua MSN: jiang313hua@hotmail.comYou are welcome to point out the error! Reprinted!This article has been tested by the

There are many methods. Here we will introduce lazy practices, that is, using tools. However, in the production environment, can't programs be installed or swollen? It doesn't matter. Our great percona has carefully considered the birds for

MySQL lock Blocking analysis, mysql lock Blocking During routine maintenance, threads are often blocked, resulting in slow database response. Let's take a look at how to obtain which thread causes blocking. Blog: http://blog.csdn.net/hw_libo/article/

Why does mysql encounter Waitingfortablemetadatalock and its solution bitsCN.com? Causes and Solutions for Waiting for table metadata lock in mysql Metadata Locking MySQL 5.5.3 and up uses metadata locking to manage access to objects (tables,

Summary of problems with high usage of mysql CPU bitsCN.com through previous operations on mysql, I first excluded the mysql configuration problem and checked whether msyql is running normally, view the *. errfile (change the extension name to .txt)

In order to quickly synchronize data needs, I staged two Python scripts, that is, two process synchronization data opened, the results of the server reported the database deadlock exception, through the troubleshooting Code and database log

I. theory: 1. Advantages: 1) reduce the operation risks of the system administrator and facilitate the overall database migration. During database migration, scheduling events can be migrated at the same time. Scenario 2: 1) collect statistics

Mysql master-slave database synchronization environment: Master server: centos 5.2 mysql 5.1.35 source code IP: 192.168.1.22 Slave server: centos 5.2 mysql 5.1.35 source code IP: 192.168.1.33 Configuration: I. master server 1.1 Create a replication

This article mainly introduces how MHA implements manual switching between mysql master databases and slave databases. it describes in detail the steps and methods for switching between master and slave databases, which is very practical, for more

In php, how does one use mysqli connection to obtain the mysql process List, which is similar to showprocesslist? Php version: 5.2.17 & nbsp; mysql version: 5.0.14 uses the connection method of mysqli. to obtain the list of current database

This blog is prepared in two parts for a detailed introduction to MySQL (based on MySQL 5.6) in metadata lock,I. Description of metadata locking in official documentation (5.6)8.11.4 Metadata Lockingmysql uses Metadata locking to manage concurrent

Mysql5.6 Based on gtid master-slave replication (this article is: MariaDB-10) The GTID (GlobalTransactionIDs) introduced by MySQL5.6 makes the configuration, monitoring and management of its replication function easier to implement and more robust.

Mysql master-slave replication principle and Configuration1 copy Overview The built-in replication function of Mysql is the basis for building large and high-performance applications. This distribution mechanism replicates data from a Mysql host to

Website bottleneck analysis-MYSQL performance analysis, website bottleneck mysql Performance 1. Slow query settings and Analysis Search for slow query parameters mysql> show variables like 'long%';+-----------------+----------+| Variable_name |