DBAeyes

Meet at the Southern Cross constellation

MySQL lock info -- Waiting for table metadata lock

现象： 1. 数据库发现一条根据主键更新的sql特别慢，持续70秒后显示更新超时。 [cc lang='sql']update user_quotation set GMT_MODIFIED = now() where ID = 230967517;[/cc] 2. 任何DDL操作都显示 [c...

Posted by Vincent on February 27, 2013

MySQL error 1535 --table definition on master and slave does not match

It will be slave error when change column type on slave first. Table definition: [cc lang='sql'] CREATE TABLE `table_xf` ( `i` int(11) NOT NULL AUT...

Posted by Vincent on January 21, 2013

Airbnb coupon 2013 25$ off

Register now and save $25 off your first trip with Airbnb: How does it work? 1. You can’t be logged in. This is discount for new accounts. click t...

Posted by Vincent on January 21, 2013

不管怎么样写点东西

其实写或者不写，在当时的感觉差别不大，但是到一段时间之后，回头再看会有很大的区别。 所以呢，检查谢谢blog还是很好意义的！ 很多事情不要只顾着想，需要去做，做了才知道好不好做，才会发现那是件简单的事情！ just do it！ DREAMS ARE ALWAYS DREAMS WHEN YO...

Posted by Vincent on January 20, 2013

bye-bye 2012, new in 2013

2012就这么过去了，2012有些特别，玛雅人的预言没有实现。大家都还好好的，照样过活，个人和国家的事情照常在上演。能顾上自己的小家就很不错了！ 2012 1. 7月份工作从城西换到了滨江，从此上班路上时间少了3个小时，自己感觉生活品质是提高了。在b2b的工作还算顺利，只是感觉更忙了。 2. ...

Posted by Vincent on January 3, 2013

Iterm2 auto login 自动登录脚本

入了MAC PRO后，terminal工具需要重新考虑，同事严重推荐使用iterm2，刚开始还没适应过来，用了一段时间的secureCRT，不过secureCRT不支持retina屏，还是转向免费又好用的iterm2 使用iterm2必须要配置好自动登录,在 Preferences->Prof...

Posted by Vincent on November 1, 2012

breakdown caused by swap in MySQL

One case about breakdown caused by swap in MySQL. 一个因为swap导致故障解决案例。 MySQL version: 5.1.60 A lot of queries( more then 500) were blocked, the applat...

Posted by Vincent on October 22, 2012

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