Louis Liu

Head of Data & AI Innovation @ Ping An Good Doctor

AI models / AI Infra / Bigdata

GitHub About RSS

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

Architecture of data warehouse which is based on MQ

Updated on January 20, 2015 by Louis Liu

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