DBAeyes

Meet at the Southern Cross constellation

Trouble shooting the high SYS CPU in MySQL server

MySQL服务器sys cpu过高的解决 One MySQL database server's load was very high, especially the SYS CPU, then the applications could not get enough connections...

Posted by Vincent on October 22, 2012

replace the "or" with "union all" in MySQL subquery

MySQL tuning advise: replace the "or" with "union all" in MySQL subquery MySQL version: 5.5.18 Table info: [cc lang='sql']root@xf_test 02:33:06>sho...

Posted by Vincent on October 21, 2012

杭州西湖博览会国际烟花节

9月13号，朋友邀请一起去西湖看烟花，还是第一次看有门票的烟花大会，位置柳浪闻莺！4点半就到了观赏点，人已经非常多了，还有3个多小时才开始！漫长的等待过程中，人越来越多，后来，人真的是太多了，路上也都坐满了人（有小板凳），只留了一条缝隙走人，不得不惊叹人多啊！ 最后一个小时几乎是掐着时间过的，...

Posted by Vincent on October 17, 2012

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