Benchmark for NVMFS (supports atomic writes ,so we can close double-write option on specific MySQL version )
tips: some Flash-based cards could support large block map , the main idea is to avoid fractured page writes.
September 6, 2015 Architect, hardware, Internals, MYSQL No comments
Benchmark for NVMFS (supports atomic writes ,so we can close double-write option on specific MySQL version )
tips: some Flash-based cards could support large block map , the main idea is to avoid fractured page writes.
August 24, 2015 Internals, linux, MYSQL, rdbms No comments
August 19, 2015 MYSQL, replication, system No comments
August 6, 2015 Architect, Architecture, mongodb, MYSQL, NoSQL, rdbms, software No comments
In this article, we introduce myawr and mongoawr system .
Read this PDF, you will learn how to configure them.
July 24, 2015 Architect, Architecture, Internals, MYSQL, network, system No comments
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:
July 15, 2015 Architect, mongodb, MYSQL, software No comments
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[……]
April 24, 2015 system No comments
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[......]
April 23, 2015 Internals, MYSQL, replication No comments
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.[……]
April 22, 2015 Architect, MYSQL, software No comments
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:
March 13, 2015 system No comments
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[……]