how to use percona-tookit to verify mysql data
Read this PDF : mysql_checksum[……]
How to configure AWR system
In this article, we introduce myawr and mongoawr system .
Read this PDF, you will learn how to configure them.
How to configure Tcpdump system
MySQL Tcpdump system : use percona-toolkit to analyze network packages
We can identify problem SQLs with high execution frequency.
With DBMON system and AWR system we can find problem SQLs in a special time (high frequency, occurs over a period of time)
View this PDF:
How to configure WEBM
Architecture of WEBM system.
Reference:
http://www.louisliu.blog/2014/10/webm_v2-has-been-released/
http://www.louisliu.blog/2014/09/webm-mysql-database-performance-web-monitor/
View this PDF:
http://www.louisliu.blog/docs/How%20to%20configure%20WEBM.pdf[……]
linux tools part 10– Monitoring process iostat
We can use iopp tool to monitor process io performance
download from github : https://github.com/markwkm/iopp
pid: The process id. rchar: The number of bytes which this task has caused to be read from storage. wchar: The number of bytes which this task has caused, or shall cause to be written[......]
MariaDB : Bug when add index on Partition table
Version: 5.5.5-10.0.10-MariaDB-log MariaDB Server
When I use mariadb as multi-source slave DB I met a strange problem . Creating index on a vary large partition table , Mariadb do — copy to tmp table on the slave side. It takes a long time and still not finish over 9 hours.
Primary : MySQL 5.[……]
MySQL 5.7 milestone
MySQL 5.7 will be a great milestone in MySQL total history.
Oracle has released many useful new features in LAB version . MySQL is becoming more similar to Oracle database 🙂
Read this presentation I post on slideshare:
Design for “seckilling ” on MySQL
Today I read a nice article , which give a new design for mysql database . In this article , Author (Mr.lou) uses OneSQL (a branch of MySQL) for the whole test.
you can read from : http://www.onexsoft.com/?page_id=378
This article explain how to use mysql in seckilling scenario (especially f[……]
Architecture of data warehouse which is based on MQ
Recently, we create a mysql data warehouse which is based on message queue.
Most companies must prepare for particular queries in their systems if they consider to split their databases or tables into many pieces.
some problems should be solved in this situation:
1. how to get correct re[……]
MHA with binlog server
In this post ,we mainly talk about MHA GTID behavior, we test different cases and find something is different from previous versions .
we have four machines for this test.
environment:
master server: 10.0.128.77 slave server : 10.0.128.110/113/114 port : 3306
———————–[……]