Louis Liu

Head of Data & AI Innovation @ Ping An Good Doctor

AI models / AI Infra / Bigdata

GitHub About RSS

NVMFS Supports Atomic Writes

Updated on September 6, 2015 by Louis Liu

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.

http://www.louisliu.blog/docs/nvmfs_benchmark.pdf[……]

[Reprint]Injection MySQL – Function

Updated on August 24, 2015 by Louis Liu

Reprint a PDF for MySQL Injection Test

MySQL Error Based SQL Injection Using EXP[……]

MySQL checksum

Updated on August 19, 2015 by Louis Liu

how to use percona-tookit to verify mysql data

Read this PDF : mysql_checksum[……]

How to configure AWR system

Updated on August 6, 2015 by Louis Liu

In this article, we introduce myawr and mongoawr system .

Read this PDF, you will learn how to configure them.

How to configure AWR system.[……]

How to configure Tcpdump system

Updated on July 24, 2015 by Louis Liu

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:

http://www.louisl[……]

How to configure WEBM

Updated on July 16, 2015 by Louis Liu

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

Updated on April 24, 2015 by Louis Liu

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

Updated on April 23, 2015 by Louis Liu

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

Updated on April 22, 2015 by Louis Liu

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:

MySQL 5.7 milestone[……]

Design for “seckilling ” on MySQL

Updated on March 13, 2015 by Louis Liu

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[……]