DBAeyes

Meet at the Southern Cross constellation

The sequence of updated value in MySQL

It was a confused phenomenon when I found it. [cc lang="sql"]CREATE TABLE `tmp_xf` ( `id` int(11) NOT NULL AUTO_INCREMENT, name varchar(32) no...

Posted by Vincent on October 5, 2012

Holiday

It is a long holiday for us. Have fun! I test a picture from the flickr.

Posted by Vincent on September 30, 2012

How to do with the duplicated data in MySQL

MySQL: 5.1.48 Phase: the trade_id are duplicated in table tmp_xf_test Purpose: select the record which the gmt_modified is minimum and the trade_id...

Posted by Vincent on September 29, 2012

something was changed in my work

Something was changed in my work these days. I think it is useful and important. 1. adjust some variables in mysql, it looks good for database. 2. ...

Posted by Vincent on September 29, 2012

Yeah!!!

还没起床就收到了一个非常非常振奋人心的消息，全家都开心啊！期待老久了 什么好消息呢，卖个官子先，后面再告诉大家！   yeah! yeah! yeah!!!   心情大好！

Posted by Vincent on September 28, 2012

忙傻掉了呗

忙的都有点头疼，而且关键是心境有点烦躁，没能让我好好看问题超过10分钟的，一会一个电话。这年头脾气再好也要恶劣起来的。   昨天想把魔法给转出来，转到最后，发现自己完全没法集中注意力了。 今天想花几分钟转下，没那个空闲。   有点头疼，是真的疼，不是烦。   不过...

Posted by Vincent on September 26, 2012

MySQL覆盖索引 LIKE优化

测试过程： [cc lang='sql'] 表结构,创建数据 root@test 02:16:15>show create table tmp_xf_like\G *************************** 1. row *************************** Ta...

Posted by Vincent on September 19, 2012

不能说忙

忙这个字从字形上来说是心字旁加亡，心亡。 所以不能说忙，只能说最近事情有点多，非常的多。 最近事情确实够多，从到公司忙到下班，还剩下一堆事情没干完。当被5个以上开发催着办事情时，心情就开始不爽了。事情太多不利于提升服务质量，会遭到投诉，而且都是日常杂事，到头来得到了啥呢？ 必须提升效率，工具是...

Posted by Vincent on September 14, 2012

command: nc

--translate some info host_A: nc -l 1521 host_B: telnet 172.22.27.8 1521 --file translate, translate file from B to A 1. host_A : nc -l 1521 > /...

Posted by Vincent on September 13, 2012

mysql逻辑备份完成备库搭建

场景： 当前1主1备，MM结构 master A:192.168.0.1:3306 slave B:192.168.0.2:3306 要搭建新的一主一备用于替换老的机器 master C:192.168.0.3:3306 slave D:192.168.0.4:3306 1. 先搭建好C-&g...

Posted by Vincent on September 13, 2012