note



create table usertable (y_id varchar primary key,field0 varchar,field1 varchar,field2 varchar,field3 varchar,field4 varchar,field5 varchar,field6 varchar,field7 varchar,field8 varchar,field9 varchar);

create keyspace ycsb WITH REPLICATION = {'class' : 'SimpleStrategy', 'replication_factor': 3 };
drop table usertable;

bin/ycsb.sh load cassandra-cql -P workloads/workloada -P cassandra.properties  -s  > loada.dat
bin/ycsb run cassandra-cql -P workloads/workloada -P cassandra.properties -s -threads 256 > transactions.dat
bin/ycsb run cassandra-cql -P workloads/workloada -P cassandra.properties -s -threads 10 -target 100 > transactions.dat

CREATE USER test WITH PASSWORD 'test123' SUPERUSER ;

no module named yum
修改yum文件
#vi /usr/bin/yum
将 #!/usr/bin/python 修改为 #!/usr/bin/python2.4

ln -s /usr/Python-2.7.13/python ./python 
python 版本切换
cd /usr/local/bin;
rm -rf python
ln python2.6 python
rm -f /usr/local/bin/python-config
cd /usr/local/bin;
ln -s python2.6-config python-config

wget --continue --no-check-certificate https://pypi.python.org/packages/78/6a/11dc31b5479ff56dfbfd4bc58cd6e3c58fa37ebd3ade5b331bcd06618452/openpyxl-2.2.5.tar.gz#md5=3329fe102469f53a9b571444df697f0f
下载openpyxl2.2.5源码
解压 tar zxvf openpyxl-2.2.5.tar.gz
cd openpyxl-2.2.5
python setup.py install #安装openpyxl

pip install openpyxl --proxy=https://child-prc.intel.com:913
pip install -t /usr/local/lib/python2.6/site-packages/ openpyxl  --proxy=https://child-prc.intel.com:913 安装到指定路径

wget --continue --no-check-certificate https://bootstrap.pypa.io/get-pip.py 下载pip
python get-pip.py安装pip

export http_proxy=http://child-prc.intel.com:913
export https_proxy=https://child-prc.intel.com:913

 vi /etc/resolv.conf
vi  /etc/sysconfig/network-scripts/ifcfg-eth0修改gateway为172.18.0.49
route
env|grep proxy

http://support.primatelabs.com/kb/geekbench/installing-geekbench-on-linux
http://smilepad.blog.51cto.com/6094369/1333478

/etc/init.d/ntpd restart时间同步

for line in fp.readlines()报memory error修改成for line in fp

 du -smh *|grep 'G'

cat /proc/cpuinfo | grep "cpu cores" | uniq  查cpu多少core
netstat -tunpl |grep 7180查看端口有没有起来
/etc/init.d/postgresql restart
sudo service cloudera-scm-server restart
sudo service cloudera-scm-agent restart
sudo service cloudera-scm-server status

su - hdfs
hadoop dfsadmin -safemode leave

1. enable os cache: 不执行 clear_cache, 直接run query（main.py)
2. enable hdfs cache: 执行 impala_cache_partition.pl (数据load 到hdfscache); 执行clear_cache(清空os cache); 执行main.py

yum install perf
perf --version
[root@tracing041 tracing044]# perf
perf: /usr/lib64/libdw.so.1: version `ELFUTILS_0.158' not found (required by perf)
perf: /usr/lib64/libdw.so.1: version `ELFUTILS_0.156' not found (required by perf)
You have mail in /var/spool/mail/root
[root@tracing041 tracing044]#  ls -la /usr/lib64/libdw.so.1
lrwxrwxrwx. 1 root root 14 Jan 27  2016 /usr/lib64/libdw.so.1 -> libdw-0.152.so

yum -y install elfutils
[root@tracing041 tracing044]#  ls -la /usr/lib64/libdw.so.1
lrwxrwxrwx 1 root root 14 Mar 16 10:33 /usr/lib64/libdw.so.1 -> libdw-0.164.so

cat /etc/cloudera-scm-server/db.properties

psql -U scm -p 7432 -h localhost -d postgres

pg_dump -U postgres -p 7432 scm | gzip > scm.gz

yum install postgresql
cp  /etc/yum.repos.d/back/cdrom.repo /etc/yum.repos.d/
yum install cloudera-manager-server-db-2-5.10.0-1.cm5100.p0.85.el6.x86_64.rpm
yum repolist

yum update openssl
cd /etc/yum.repos.d
wget http://people.centos.org/hughesjr/chromium/6/chromium-el6.repo
yum install chromium
# cd /opt/chromium-browser/

# vi chromium-browser.sh
找到exec -a "$0" "$HERE/chromium-browser" $CHROMIUM_RHEL_FLAGS "$@"

在后面添加 --user-data-dir

修改后为：exec -a "$0" "$HERE/chromium-browser" $CHROMIUM_RHEL_FLAGS "$@" --user-data-dir