查看内存页

getconf PAGE_SIZE
ipcs
MySQL常用选项
mysqldump -q --lock-tables --single-transaction
mysqldump -w
mysqldump
时区：--tz-utc
日期时间类型推荐：
TIMESTAMP
sysbench:
Installing:
See the file INSTALL for generic installation instructions.
In most cases you will need the following steps:
    ./autogen.sh (unnecessary if you are building from a release tarball)
    ./configure (or ./configure --without-mysql to compile w/o MySQL support)
    make
    make install
    
./configure --with-mysql-includes=/usr/local/mysql/include --with-mysql-libs=/usr/local/mysql/lib && make && make install
hdparm
tpcc_load
tpcc_start
挂在XFS
mount -o remount -o noatime,nodiratime,inode64,nobarrier /dev/sdb1 /backup
监控温度：
yum provides "ipmitool"
关闭query cache
同时设置选项 query_cache_type = 0 和 query_cache_size = 0；
安装SVN 时候：apr apr-util 老是无法找到推荐源码安装
首先安装apr 指定安装到/usr/local/apr
wget http://mirrors.cnnic.cn/apache/apr/apr-1.4.8.tar.gz
tar zxvf apr-1.4.8.tar.gz
cd apr-1.4.8
./configure --prefix=/usr/local/apr
make & make install
然后安装apr-util，指定安装到/usr/local/apr-util
    
wget http://mirrors.cnnic.cn/apache/apr/apr-util-1.5.2.tar.gz
tar zxvf apr-util-1.5.2.tar.gz
cd apr-util-1.5.2
./configure --prefix=/usr/local/apr-util --with-apr=/usr/local/apr
make & make install
经过上面的步骤我们就可以安装其他程序了，比如编译安装svn的时候指定apr和apr-util
指定svn位置/usr/local/subversion 同时也要指定apr和apr-util位置，代码如下
    
wget http://mirror.esocc.com/apache/subversion/subversion-1.8.3.tar.gz
cd subversion-1.8.3.tar.gz
./configure --prefix=/usr/local/subversion --with-apr=/usr/local/apr --with-apr-util=/usr/local/apr-util
make & make install
./configure --prefix=/usr/local/apr-iconv --with-apr=/usr/local/apr
 
 svnserve -d -r /data2/svn
 
 /usr/local/subversion/bin/svnserve -d -r /data2/svn
 
 
 钩子中文报错解决post-commit：
 export LANG=en_US.UTF-8