percona vs mysql

The previous article briefly introduced the usage of the EXPLAIN statement. Today we will introduce the following: Slow query log Enable slow query log Save slow query logs to the table Slow query log analysis Percona Toolkit Install Pt-query-digest Pt-index-usage Pt-query-advisor SHOW PROFILE Performance_schema Slow query log open slow query log Slow query logs, as the name implies, are logs that record slow query execution. Check whether

It's time to replace MySQL with PerconaDB with bitsCN.com. it's time to replace MySQL with PerconaDB. Author: chszs, reprinted with note. Blog Homepage: http://blog.csdn.net/chszs Percona database server is an enhanced MySQL version. it is not complicated to replace MySQL. 1

through the vip. # Pkill keepalived # Ip a show # Mysql-h192.168.17.166-uaaron8219-pzlm 4. configure database synchronizationAfter keepalived is installed, it only ensures the high availability of the mysql database. to ensure mutual master and slave, you also need to configure the MySQL master-slave replication mode so that the database can be consistent. 1. p

--1mysqlmysql2329nov 2316:14join.sql-rw-r-----1mysqlmysql38140 oct2712:37libev-4.04-2.el6.x86_64.rpm Drwxr-xr-x4rootroot 4096oct2711:09libev-4.15-rw-r--r--1 mysqlmysql513919oct2711:05libev-4.15.tar.gz-rw-r----- 1mysqlmysql43344Dec118:16 Libzip-0.10.1-1.3.x86_64.rpm-rw-r-----1mysqlmysql62768 Dec118:05libzip-0.11.1-3.fc20.x86_64.rpm-rw-r-----1mysqlmysql 24145dec117:33libzip-0.11.2-3.4.1.x86_64.rpm-rw-r----- 1mysqlnbsP;MYSQLNBSP;NBSP;NBSP;NBSP;65760NBSP;DECNBSP;NBSP;1NBSP;17:58NBSP;LIBZIP-0.11.2-5.

"aaaa" records. If the page itself is damaged, it makes no sense to redo it. This means that a copy of the page is required before the application retries the log. when the write failure occurs, the page is restored through the copy of the page before redoing, this is doublewrite. 1. download and installThe latest version of XtraBackup is 2.1.5, and the official version 2.0 is available for download. official link: Release. As there is no need for special customization, we recommend that you d

is a MySQL database backup tool provided by Percona and features:(1) The backup process is fast and reliable;(2) The backup process does not interrupt the executing transaction;(3) Can save disk space and traffic based on functions such as compression;(4) Automatic implementation of backup inspection;(5) Fast restore speed.Official link address: http://www.percona.com/software/

A new feature of the new generation of products is that users can choose to use full-flash storage or use both hard drives and flash devices to balance customers' different needs for superior performance and storage capabilities. For various reasons, data inconsistency often occurs in the mysql master/slave architecture, which is roughly attributed to the following categories: 1: write data to the slave database 2: execute non-deterministic query

mysql monitoring Zabbix comes with a template to monitor MySQL, but it's not Zabbix's own template that really monitors MySQL. But percona A monitoring MySQL template percona Official website: www.percona.com

Label:The last time I encountered MySQL master server data consistency problem, think of it was a few years ago, but also vaguely remember the panic scene, fortunately, finally with the help of Maatkit solve the problem. A few years later, when I faced the same problem again, Maatkit had ceased to exist, and became part of the Percona Toolkit, unchanged is that I am still in a hurry, so keep a record of it,

applying the redo log, we need a copy of the page, and when the write failure occurs, the page is restored by the doublewrite of the page and then redo. First, download and installXtrabackup is now the latest version of 2.1.5, the official also provided a 2.0 version available for download, official link address: http://www.percona.com/software/percona-xtrabackup , you can download the source compilation installation, or you can download the approp

Xtrabackup, an Open-source software developed by Percona, is an open source alternative to the InnoDB hot standby tool Ibbackup (fee-based commercial software). The xtrabackup consists of parts: Xtrabackup and Innobackupex, where the Xtrabackup tool is used to back up the tables of the InnoDB and XTRADB engines; The Innobackupex tool is used to back up tables for the MyISAM and InnoDB engines, and this article describes how to do both full and increme

requirements of high throughput, mission-critical applications for system performance and scalability. But in the case of SolidDB being acquired by IBM, MySQL's acquisition of Oracle, basically SolidDB for MySQL is an engine that cannot continue to be used by MySQL, so it is also a MySQL engine with a cup. Official website: http://www.ibm.com/software/data/Solid