MariaDB TokuDB benchmark on FusionIO ,Compare TokuDB and InnoDB engines.
read: TokuDB_benchmark[……]
MySQL lost “AUTO_INCREMENT” after a long time
Description:
I create a empty table and then alter this table's "AUTO_INCREMENT" starts from 10000000.After a long time ,MySQL lost "AUTO_INCREMENT" definition when I show this table again. MariaDB has the same problem but Percona Server is fine.
$mysql06
Warning:[......]
NVMFS Supports Atomic Writes
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.
[Reprint]Injection MySQL – Function
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.[……]