摘要：
Preface Today,I'm gonna say something what is related with the character set in Oracle database,the scenarios in changing character set from UTF8 to Z 阅读全文
摘要：
Preface We are always obliged to analyze many outputs generated by various tools directly even in flat text files in server performance diagnosis.Furt 阅读全文
摘要：
Preface As wel all know,replication base on GTID with row format of binary log is comprehensive used nowadays,especially in MySQL 5.7 version above.I' 阅读全文
摘要：
Preface We've got a lot of files related with system performance which generated by pt-stalk in directory "/var/lib/pt-stalk" in my last blog.We can u 阅读全文
摘要：
Preface We have a lot of methods to diagnose problems in our system such as strace,pstack,gstack,gdb,pt-pmp,etc.But sometimes there will be some fitfu 阅读全文
摘要：
Preface I've got a db design job about meeting room booking system last week.There're many suitable tools which can be used to handle this kind of job 阅读全文
摘要：
Preface We all know that Xtrabackup is a backup tool of percona for innodb or Xtradb.It's usually used to back up whole databases physically.But how t 阅读全文
摘要：
Preface There're many ways in backing up or migrating data from one server to another one.Logically,we can use mysqldump,mydumper,mypump to do that ki 阅读全文
摘要：
Preface Null is a special constraint of columns.The columns in table will be added null constrain if you do not define the column with "not null" key 阅读全文
摘要：
Preface MySQL use character set & collation to organize the different charater.It provides a flexible way in setting individual character set on a dat 阅读全文