查看内存页
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
MySQL基本
原创
©著作权归作者所有:来自51CTO博客作者kuailegao的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Centos 基本部署
记录项目的基本部署
mysql nginx tomcat -
mysql 基本管理
mysql DDL、DCL语句
mysql MySQL