查看内存页
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