On our job schedule system. Using osc-tool cause deadlock problem.
We investigated the root cause in detail and published this PDF doc.
October 24, 2018 Internals, MYSQL, rdbms No comments
On our job schedule system. Using osc-tool cause deadlock problem.
We investigated the root cause in detail and published this PDF doc.
August 16, 2017 Architect, Internals, MYSQL, replication No comments
Actually, Mysqlbinlog tools can’t miner mysql binlog exactly correct.
In this post ,a special environment we got may hexadecimal characters what we[……]
October 21, 2015 Architect, Architecture, hardware, Internals, MYSQL, performance No comments
MariaDB TokuDB benchmark on FusionIO ,Compare TokuDB and InnoDB engines.
read: TokuDB_benchmark[……]
October 8, 2015 Internals, MYSQL, rdbms No comments
Description:
I create a empty table and then alter this table's "AUTO_INCREMENT" starts from 10000000.After a long time ,MySQL lost[......]
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 sup[……]
August 24, 2015 Internals, linux, MYSQL, rdbms No comments
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 s[……]
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 la[……]
July 9, 2013 Internals, MYSQL 2 comments mysql
最近关于下厨房的数据恢复,讨论的很火热,乘机测试了把Percona Data Recovery Tool for InnoDB工具,并且事实证明这款工具对一些操作的恢复,还是比较困难的。
我们以一张小表为例做一个测试:
mysql> select * from customer;[......]