mysql实例优化效果

Author: IceskYsl

5 Feb

前段时间写了一篇《实例优化mysql配置文件my.cnf》，这几天看到效果非常明显，别的不说，单mysql cache_hits就很不错（之前竟然没注意到这个参数）

# Increase query_cache_size from 0 to 128M
query_cache_size=128M
# Increase query cache limit from 1048576 to 2M
query_cache_limit=2M

看到效果很明显，如下是munin的监控图：

Twitter: iceskysl

生活回归正常～ 01:54:03 AM August 07, 2010 from web
PAC + SSH翻墙 http://www.nowa.me/posts/pac-ssh 10:43:06 AM June 16, 2010 from web
safari下的pac还是比较好用的。 10:41:14 AM June 16, 2010 from web
Twitter is over capacity. 10:39:05 AM June 16, 2010 from web
11:49am (EDT): The Dallas network operations team has confirmed a network outage and has all hands on deck investigating the issue. 04:02:51 PM May 31, 2010 from web
新华网北京７月１７日电（记者李舒、李志勇）从北京地铁运营公司获悉，１７日８时２５分左右，在北京地铁一号线南礼士路站有人跳轨自杀，当场死亡。造成地铁一号线和八通线全线停运。据了解，由于事发恰逢上班高峰时间，一号线各站均出现人流拥堵，许多人不得不改换地面交通。北京 ... 02:26:05 AM July 17, 2009 from twitgether
Introducing Android 1.5 NDK, Release 1 http://ff.im/4I1eX 12:36:04 PM July 02, 2009 from FriendFeed
了解你的智能手机 http://ff.im/4xLat 05:38:35 PM June 28, 2009 from FriendFeed
罗比尼奥啥时这么老了，当年那个单车小子呢？ 03:40:14 PM June 26, 2009 from web
巴西甚至有点狼狈，有意思，很久没看巴西比赛了 03:38:18 PM June 26, 2009 from web