<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[mirabelle521的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/mirabelle521</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; mirabelle521]]></copyright><item><title><![CDATA[cpu核数]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/75282143</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/75282143</guid><author>mirabelle521</author><pubDate>Tue, 18 Jul 2017 10:51:46 +0800</pubDate><description><![CDATA[1.      开机重启，按下F2，进入BIOS，选择Processor
 Configuration



 


2.      找到Hyper
 Threading Tech,选择Enable



 

 


3.      调整CPU
核数，找到Active Processor Cores，选择要设置的个数



或者使用命]]></description><category></category></item><item><title><![CDATA[IntelliJ IDEA编写Java工程]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71482421</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71482421</guid><author>mirabelle521</author><pubDate>Tue, 09 May 2017 18:00:30 +0800</pubDate><description><![CDATA[新建工程FileàNewàProject





选择Java，添加JDK目录








创建完成后，会有一个src文件夹，把代码拷贝到src目录下



File-->Project Structure-->Modules,添加Jars







添加完需要jars，点击OK.


代码打包编译成Jar文件，现在Projec]]></description><category></category></item><item><title><![CDATA[Hyper Thread]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71171593</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71171593</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 16:07:01 +0800</pubDate><description><![CDATA[﻿﻿





开机重启，按下F2，进入BIOS，选择Processor
 Configuration 


 

找到Hyper
 Threading Tech,选择Enable



 

 

调整CPU
核数，找到Active Processor Cores，选择要设置的个数


或者使用命令修改，需要几个core，把其他core都禁掉
]]></description><category></category></item><item><title><![CDATA[note]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71169645</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71169645</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 13:37:33 +0800</pubDate><description><![CDATA[﻿﻿
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 varch]]></description><category></category></item><item><title><![CDATA[cdh安装记]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71169631</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71169631</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 13:36:04 +0800</pubDate><description><![CDATA[﻿﻿



manager node:
yum installcloudera-manager-server  cloudera-manager-daemonscloudera-manager-server-db
yum installpostgresql
service postgresql initdb 
（如果是重启初始化失败，把对应的data目录直接删除重启初始化）
se]]></description><category></category></item><item><title><![CDATA[cpu 内核]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71169528</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71169528</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 13:32:35 +0800</pubDate><description><![CDATA[﻿﻿
Cpu
内核个数设置,

 

echo 0 > /sys/devices/system/cpu/cpu0/online 
echo 1> /sys/devices/system/cpu/cpu0/online
 
 
或者BIOS里面
Active Processor Cores设置]]></description><category></category></item><item><title><![CDATA[建立repo库]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71169524</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71169524</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 13:31:53 +0800</pubDate><description><![CDATA[﻿﻿
自己建立repo库：
1.yum install httpd
2.yum install createrepo
3.拷贝下载好的rpm包到/var/www/html
 cp -a /home/chenmeixiu/5.10.el7/ /var/www/html/5.10
 createrepo -p -d -o /var/www/html/5.10
  /var/www/htm]]></description><category></category></item><item><title><![CDATA[CDH安装]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71169492</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71169492</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 13:28:12 +0800</pubDate><description><![CDATA[在安装cdh之前先安装这些包以及jdk和python环境

yuminstall postgresql-server
yuminstall mod_ssl
 yum install python-psycopg2 MySQL-python
yuminstall redhat-lsb
yuminstall httpd
yuminstall perl
Yumlist]]></description><category></category></item><item><title><![CDATA[kudu-ycsb]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71169486</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71169486</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 13:26:51 +0800</pubDate><description><![CDATA[﻿﻿


<img width="530" height="740" alt="Kudu configure--gflag

--metrics_log_interval_ms=10000

Untitled picture.png rablet Server Advanced Configuration 
*lippet (Safety Valve) for gflagfile 
]]></description><category></category></item><item><title><![CDATA[os cache]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71169478</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71169478</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 13:25:33 +0800</pubDate><description><![CDATA[﻿﻿



OS CACHE
配置sql:q19，q63,q68,q73,直接运行main.py
 
HDFS_CACHE
1.先把数据set cache
impala-shell-i "tracing024:21000" -d tpcds_parquet_3000 -q "alter table 
customer_address_parquet         set ca]]></description><category></category></item><item><title><![CDATA[centos 网络配置]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71169386</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71169386</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 13:21:07 +0800</pubDate><description><![CDATA[﻿﻿
Vi /etc/resolv.conf
domainsh.intel.com
searchsh.intel.com
nameserver10.248.2.5
nameserver10.239.27.228
nameserver172.17.6.9
 vi /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=tracing047
v]]></description><category></category></item><item><title><![CDATA[cloudera add host]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71169355</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71169355</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 13:17:43 +0800</pubDate><description><![CDATA[yum install perl部署之前先安装perl
\\10.239.44.128\home\chenmeixiu\CentOS-Base.repo
配置yum源,放到/etc/yum.repo.d
vi /etc/yum.conf设置代理
http_proxy=http://child-prc.intel.com:913
<img width="958" height="599" ]]></description><category></category></item><item><title><![CDATA[磁盘操作]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71168275</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71168275</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 13:14:30 +0800</pubDate><description><![CDATA[﻿﻿

查看几块硬盘
Lsblk
cd /mnt
mkdir sda
挂载硬盘mount /dev/sda /mnt/sda
 mount -a挂载全部
 du -smh *|grep 'G' 查看磁盘占用
df -h 
du -h --max-depth=1
[root@tracing047~]# lsblk
NAME                           ]]></description><category></category></item><item><title><![CDATA[ntp安装]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71162980</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71162980</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 13:08:06 +0800</pubDate><description><![CDATA[﻿﻿
exporthttp_proxy=代理地址
exporthttps_proxy=代理地址
yum -yinstall ntp

chkconfig --add ntpd /*添加NTP*/ 
chkconfig ntpd on /*开机自启动NTP*/]]></description><category></category></item><item><title><![CDATA[ssh免密码登录]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71161691</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71161691</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 12:25:30 +0800</pubDate><description><![CDATA[﻿﻿
在A机器上执行
cd ~
cd .ssh

ssh-keygen -t rsa会生成两个文件，一个公钥，一个私钥id_rsa和id_rsa.pub
 
然后在B机器上执行ssh
 A cat ~/.ssh/id_rsa.pub >>authorized_keys

 

这样这两台机器就实现了免密码访问。]]></description><category></category></item><item><title><![CDATA[Install chromeium]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/71160067</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/71160067</guid><author>mirabelle521</author><pubDate>Thu, 04 May 2017 12:11:51 +0800</pubDate><description><![CDATA[﻿﻿
yum update openssl
cd /etc/yum.repos.d
wget 
http://people.centos.org/hughesjr/chromium/6/chromium-el6.repo
yum install chromium
 然后打开Applications--->internet-->chromeium
遇到错误chromeium can n]]></description><category></category></item><item><title><![CDATA[Ubuntu网路配置]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/48373555</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/48373555</guid><author>mirabelle521</author><pubDate>Fri, 11 Sep 2015 15:35:57 +0800</pubDate><description><![CDATA[1.修改/etc/network/interfaces

nano /etc/network/interfaces加入以下内容

# The primary network interface
auto lo
iface lo inet loopback
auto eth0
iface eth0 inet static
address 192.168.1.100
gateway]]></description><category></category></item><item><title><![CDATA[profile,rc.local执行顺序]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/48373531</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/48373531</guid><author>mirabelle521</author><pubDate>Fri, 11 Sep 2015 15:33:03 +0800</pubDate><description><![CDATA[profile 是登陆后执行，只能执行登录用户权限下的程序，而且用户不登录就不会执行相应程序
rc.local是系统启动后就会执行，优先级高于登陆后执行；还有，他可以指定执行程序的权限]]></description><category></category></item><item><title><![CDATA[数据库数据容量和索引容量查询]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/48373475</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/48373475</guid><author>mirabelle521</author><pubDate>Fri, 11 Sep 2015 15:30:51 +0800</pubDate><description><![CDATA[-- Check Database SPACE
select concat(round(sum(DATA_LENGTH/1024/1024), 2), ' MB') as data from TABLES where table_schema='VWS2';


-- Check Index SPACE
SELECT CONCAT(ROUND(SUM(index_length)/(102]]></description><category></category></item><item><title><![CDATA[mysql 修改字符串最后一位]]></title><link>https://blog.youkuaiyun.com/mirabelle521/article/details/40504717</link><guid>https://blog.youkuaiyun.com/mirabelle521/article/details/40504717</guid><author>mirabelle521</author><pubDate>Mon, 27 Oct 2014 11:08:18 +0800</pubDate><description><![CDATA[﻿﻿
update table set 字段=CONCAT(LEFT(, 31),'2')
 where  SourceDeviceUniqueID='100009' and  TransactionTime>'2014-10-25 00:00:00' and  TransactionType='10'
 AND (SUBSTRING(ICCardEngravedID,17,8) = '55]]></description><category></category></item></channel></rss>