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
