java ssh免密登录
packagecom.meituan.stabletest.sshtest;importjava.io.InputStream;importcom.jcraft.jsch.Channel;importcom.jcraft.jsch.ChannelExec;importcom.jcraft.jsch.
[8.0][MGR][bug]多主模式,外键冲突错误
https://bugs.mysql.com/bug.php?id=96758
内核月报bookmark
http://mysql.taobao.org/monthly/2015/05/
netcat 传输T级别大文件
接收端nc-d-l5002|tarxf-nohupshreceive.sh&发送端tarcf-.|nc1.1.1.15002nohupshtransfer.sh&
innodb部分内部操作
tab_node_t*tab_create_graph_create(/*====================*/dict_table_t*table,/*!<in:tabletocreate,builtasamemorydatastructure*/mem_heap_t*heap,/*!
qps.sh
mysql-p''-Bse'showglobalstatuslike"com_%";'>qps.newwhiletruedosleep0.5mvqps.newqps.oldmysql-p''-Bse'showglobalstatuslike"com_%";'>qps.newdatepas
比较值的周期变化
catlatency_s.output|grep-v"mysql"|awk'{print$4,"\t",$7,"\t",$9,"\t",$11,"\t",$13}'mysql-p''-Bse'selectevent_name,total_latencyfromsys.x$io_global_by_w
sysbench的新用法
相同QPS下,看响应时间。
999线监控
io、线程调度?
linux查看每秒的网络流量
importosimporttimecmd='ifconfig|grep"RXbytes"|tail-1|awk-F":"\'{print$2,"",$3}\'|awk\'{print$1,"",$6}\'>network_speed.temp'os.system(cmd)tx=0rx=0wh
软件编程
软件编程是艺术、是手艺
批量创建空连接
importmysql.connectorimporttimefrommysql.connectorimportErrorfrommysql.connector.connectionimportMySQLConnectionfrommysql.connectorimportpoolingtry:co
Certification information不能过大
/*Ifcertificationinformationistoobigthiseventcan'tbetransmittedasitwouldcausefailuresonallgroupmembers.Toavoidthis,wenowinsteadencodeanerrorthatwillma
task_loop
独自完成所有任务的调度
coroutine的意义就是不要stack
https://www.chiark.greenend.org.uk/~sgtatham/coroutines.html
一张MGR切换的图,不解释
change buffer太复杂了
http://mysql.taobao.org/monthly/2015/07/01/
mtr语言真是逆天了
实践证明,设计一个语言,还不是简单的解释没一行哦
mysql自动化测试第一个例子
#################################################################################Thistestverifieswhetherthegroup_replicationworksfinewhentheserver#ina
mysql mtr写入数据
BEGIN;--disable_query_log--let$rows=100WHILE($rows){--evalINSERTINTOt1(a)VALUES($rows)--dec$rows}--enable_query_log--errorER_RUN_HOOK_ERRORCOMMIT;