On our job schedule system. Using osc-tool cause deadlock problem.
We investigated the root cause in detail and published this PDF doc.
Category: Internals
MySQL special character rollback
Actually, Mysqlbinlog tools can’t miner mysql binlog exactly correct.
In this post ,a special environment we got may hexadecimal characters what we[……]
TokuDB benchmark on PCIe
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[......]
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 sup[……]
[Reprint]Injection MySQL – Function
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 s[……]
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 la[……]
MySQL InnoDB的一些非常规恢复
最近关于下厨房的数据恢复,讨论的很火热,乘机测试了把Percona Data Recovery Tool for InnoDB工具,并且事实证明这款工具对一些操作的恢复,还是比较困难的。
我们以一张小表为例做一个测试:
mysql> select * from customer;[......]