在debian上测试最新进入主线内核的容器虚拟化-lxc
**介绍** \\
Linux conatiners (LXC) 是在Linux平台上基于容器的虚拟化技术的未来标准，它和传统的解决方案如Linux-VServer和OpenVZ有所区别。最初的LXC技术是由IBM研发的，目前已经进入Linux内核主线，这意味着LXC技术将是目前最有竞争力的轻量级虚拟容器技术，相比较传统的VServer和OpenVZ轻量级虚拟技术（两者都需要对标准内核进行补丁），发展潜力更大。 \\
关注HandlerSocket-Plugin-for-MySQL与MyCached UDF
原文地址：[[http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-story-for.html |]] (长城之外)
译文：http://tech.it168.com/a2010/1027/1118/000001118500_all.shtml
关注两个项目：
[[http://developer.cybozu.co.jp/kazuho/2009/08/mycached-memcac.html|MyCached UDF]]
[[https://github.com/ahiguti/HandlerSocket-Plugin-for-MySQL|HandlerSocket-Plugin-for-MySQL]]
今天软件推荐-Vagrant
Vagrant是一个基于Ruby的工具，用于创建和部署虚拟化开发环境。它 使用Oracle的开源VirtualBox虚拟化系统，使用 Chef创建自动化虚拟环境。
\\
主页：[[http://vagrantup.com/|]] \\
安装方法：\\
sudo gem install vagrant \\
vagrant box add base http://files.vagrantup.com/base.box \\
mkdir vagrant \\
vagrant init \\
vagrant up
运维SA Gtalk群
Linuxtone Gtalk群:linuxtonegroup@appspot.com \\
无广告，详见http://goo.gl/z1xBf #linuxtone
架设方法(参考http://tiant.me/archives/22)：\\
mysql压力测试及优化
===== 环境 =====
硬件环境：
|型号 |CPU |内存 |网卡 |
|Dell PowerEdge \\ R410 |双路四核 \\ Xeon E5506 2.13G |8G ECC \\ DDR3 1333 MHZ内存 |Broadcom Corporation \\ NetXtreme II BCM5716 Gigabit Ethernet |
\\ 软件环境：
| 操作系统版本 |DB |
|Debian GNU/Linux \\ Lenny 5.0 amd64 |mysql Ver 14.14 Distrib 5.1.47, \\ for debian-linux-gnu (x86_64) using readline 5.2 |
经测试，
innodb_flush_log_at_trx_commit影响较大，\\
innodb_flush_log_at_trx_commit = 1(默认)时的测试情况：
{{{
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 43.718 seconds
Minimum number of seconds to run all queries: 43.718 seconds
Maximum number of seconds to run all queries: 43.718 seconds
Number of clients running queries: 2000
Average number of queries per client: 10
User time 0.10, System time 0.19
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 15784, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 63228, Involuntary context switches 1499
}}}
innodb_flush_log_at_trx_commit = 0(改动后)的测试情况：
{{{
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 4.469 seconds
Minimum number of seconds to run all queries: 4.469 seconds
Maximum number of seconds to run all queries: 4.469 seconds
Number of clients running queries: 2000
Average number of queries per client: 10
User time 0.18, System time 0.19
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 15480, Physical pagefaults 5, Swaps 0
Blocks in 736 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 61984, Involuntary context switches 2991
}}}
