<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Mrknowledge]]></title><description><![CDATA[码虫手记]]></description><link>https://blog.youkuaiyun.com/Mrknowledge</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Mrknowledge]]></copyright><item><title><![CDATA[MegaCli修复Unconfigured(good), Spun Up外来磁盘]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/122427930</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/122427930</guid><author>Mrknowledge</author><pubDate>Tue, 11 Jan 2022 11:28:13 +0800</pubDate><description><![CDATA[1.检查


/opt/MegaRAID/MegaCli/MegaCli64 -PDList -aALL -NoLog|grep "Firmware state"
Firmware state: Online, Spun Up
Firmware state: Online, Spun Up
Firmware state: Online, Spun Up
Firmware state: Online, Spun Up
Firmware state: Online, Spun Up
Firmware state]]></description><category></category></item><item><title><![CDATA[shell编程之sed]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/116206528</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/116206528</guid><author>Mrknowledge</author><pubDate>Tue, 27 Apr 2021 18:35:29 +0800</pubDate><description><![CDATA[一、sed (Stream Editor)
1、定位行：
sed -n '12,~3p' pass #从第12行开始，直到下一个3的倍数行（12-15行）
sed -n '12,+4p' pass #从第12行开始，连续4行（12-16行）
sed -n '12~3p' pass #从第12行开始，间隔3行输出一次（12，15，18，21...）
sed -n '10,$p' pass   #从第10行至结尾
sed -n '4!p' pass   #除去第4行

2、正则：’/正则式/’
sed -n ']]></description><category></category></item><item><title><![CDATA[Excel - 判断一个单元格是否属于一个集合]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/105217853</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/105217853</guid><author>Mrknowledge</author><pubDate>Tue, 27 Apr 2021 17:47:56 +0800</pubDate><description><![CDATA[Excel - 判断一个单元格是否属于一个集合
需求
需要针对excel中的记录行，通过某列去匹配一个集合，找出符合条件的记录行。

解决
MATCH用法
[示例下载地址]1
使用如下公式
#判断M列是否属于sheet SF2中B2～B42中

#如果未匹配，填 不包含
#如果匹配，填 匹配到的元素在集合中的序号
=IFERROR(MATCH(M4,'SF2'!$B$2:'SF2'!$B$42,0...]]></description><category></category></item><item><title><![CDATA[AWS SAA C01考试高分通过指南]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/105717571</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/105717571</guid><author>Mrknowledge</author><pubDate>Thu, 23 Apr 2020 21:22:18 +0800</pubDate><description><![CDATA[由于工作需要，要考aws saa认证。经过一个多月的准备，前天终于如愿通过aws saa c01，花了200大洋买了一份题库，并在网上查了aws相关概念，感觉题库题量还可以，但是给出的答案不准确，经过自己的一番资料查找，把题库中认为错误的答案逐一修正了，然后前天考完通过，昨天查分数940分（满分1000），还是很开心的，经过微软、谷歌、亚马逊等一系列考试之后，发现一份高质量的题库对通过的帮助是很大...]]></description><category></category></item><item><title><![CDATA[解决克隆虚拟机后网卡设备无法识别启动问题的方法]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/18810237</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/18810237</guid><author>Mrknowledge</author><pubDate>Wed, 01 Apr 2020 09:41:30 +0800</pubDate><description><![CDATA[一、故障问题
从vmware workstation中克隆(clone)了一个CentOS 6的虚拟机，
启动之后发现网卡没有启动。
于是重启一下network服务，发现提示错误信息
“Device eth0 does not seem to be present, delaying initialization.”

二、解决方法
1）、删除/etc/udev/rules.d/70]]></description><category></category></item><item><title><![CDATA[ios获取屏幕分辨率]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/53125843</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/53125843</guid><author>Mrknowledge</author><pubDate>Wed, 01 Apr 2020 09:40:42 +0800</pubDate><description><![CDATA[1、得到当前屏幕的尺寸：



CGRectrect_screen = [[UIScreenmainScreen]bounds];

 CGSizesize_screen = rect_screen.size;




2、获得scale：

CGFloat scale_screen = [UIScreen mainScreen].scale;




]]></description><category></category></item><item><title><![CDATA[linux umount 时出现device is busy 的处理方法--fuser]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/104295085</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/104295085</guid><author>Mrknowledge</author><pubDate>Wed, 01 Apr 2020 09:38:42 +0800</pubDate><description><![CDATA[* 查询:fuser -m /media/share

* 显示: /media/share: 25023c

就代表是 process 25023(pid) 有使用到此目录
]]></description><category></category></item><item><title><![CDATA[Excel - sum函数示例]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/17786083</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/17786083</guid><author>Mrknowledge</author><pubDate>Wed, 01 Apr 2020 09:36:45 +0800</pubDate><description><![CDATA[统计各表相同位置的和

=sum('第一个工作表名:最后一个工作表名'!A1)
=sum('*'!a1) 这个公式也就是你想要的所有表的a1相加]]></description><category></category></item><item><title><![CDATA[关于length specifier]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/105091038</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/105091038</guid><author>Mrknowledge</author><pubDate>Wed, 01 Apr 2020 09:34:13 +0800</pubDate><description><![CDATA[size_t定义了一个unsigned integer，但是具体所占用字节数依赖系统位数，如何才能可移植地打印size_t？

答案是：%zu格式化字符串。



示例：


size_t val = get_the_value();
printf("%zu",val);

z是长度指定符（length specifier），表示参数长度是size_t的长度。

英文说明：

z --- A ...]]></description><category></category></item><item><title><![CDATA[mysql timestamp使用示例]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/5889125</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/5889125</guid><author>Mrknowledge</author><pubDate>Wed, 25 Mar 2020 11:44:48 +0800</pubDate><description><![CDATA[<br />select unix_timestamp()<br /><br />select unix_timestamp('1970-01-01 22:10:10')<br /><br />select from_unixtime()]]></description><category></category></item><item><title><![CDATA[大数据端口一览]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/105090674</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/105090674</guid><author>Mrknowledge</author><pubDate>Wed, 25 Mar 2020 11:15:14 +0800</pubDate><description><![CDATA[组件
			
			
			节点
			
			
			默认端口
			
			
			配置
			
			
			用途说明
			
		
			HDFS
			
			
			DataNode
			
			
			50010
			
			
			dfs.datanode.address
			
			
			datanode服务端口，用于数据传输
			
		
			HDFS
			...]]></description><category></category></item><item><title><![CDATA[shell value too great for base]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/105089467</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/105089467</guid><author>Mrknowledge</author><pubDate>Wed, 25 Mar 2020 10:42:41 +0800</pubDate><description><![CDATA[示例：


tar_file_month=`date +%m`

rsync -auzq --exclude="2012_0[1-9]" --exclude="2012_1[0-2]" --exclude="2013_0[1-"$(($tar_file_month-1))"]"

当月是8月，tar_file_month变成了08，下面执行 $(($tar_file_month-1))的时候，变成...]]></description><category></category></item><item><title><![CDATA[ping - connect: No buffer space available]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/105089203</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/105089203</guid><author>Mrknowledge</author><pubDate>Wed, 25 Mar 2020 10:37:25 +0800</pubDate><description><![CDATA[修复这个问题需要增加ARP表空间。

查看系统参数命令：


sysctl -p

永久修复方法:

修改/etc/sysctl.conf增加如下行:


net.ipv4.neigh.default.gc_thresh3 = 4096

net.ipv4.neigh.default.gc_thresh2 = 2048

net.ipv4.neigh.default.gc_thresh1 = 1...]]></description><category></category></item><item><title><![CDATA[kipmi0 cpu 100%]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/105089153</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/105089153</guid><author>Mrknowledge</author><pubDate>Wed, 25 Mar 2020 10:33:18 +0800</pubDate><description><![CDATA[解决办法：

echo 100 &gt; /sys/module/ipmi_si/parameters/kipmid_max_busy_us




]]></description><category></category></item><item><title><![CDATA[java.lang.ClassCastException: org.apache.hadoop.conf.Configuration cannot be cast to org.apache.hado]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/105064498</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/105064498</guid><author>Mrknowledge</author><pubDate>Tue, 24 Mar 2020 09:38:42 +0800</pubDate><description><![CDATA[Exception in thread "main" java.lang.ClassCastException: org.apache.hadoop.conf.Configuration cannot be cast to org.apache.hadoop.yarn.conf.YarnConfiguration
	at org.apache.spark.deploy.yarn.Applicat...]]></description><category></category></item><item><title><![CDATA[Java代码中创建子进程并添加JVM参数]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/104924920</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/104924920</guid><author>Mrknowledge</author><pubDate>Tue, 17 Mar 2020 16:33:08 +0800</pubDate><description><![CDATA[class JavaProcess {
  private JavaProcess() {
  }
  public static int exec(Class clazz, List&lt;String&gt; jvmArgs, List&lt;String&gt; args) throws IOException,
        InterruptedException {
    Str...]]></description><category></category></item><item><title><![CDATA[Clear Dead Region Servers in HBase UI]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/104491279</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/104491279</guid><author>Mrknowledge</author><pubDate>Tue, 25 Feb 2020 10:15:13 +0800</pubDate><description><![CDATA[HBase有时候仍然会把退役的regionserver作为dead regionserver展示在UI上。因为这台regionserver的WAL (Write-Ahead Log)在HDFS上还存在splitting状态的日志，因此从HBase的角度，这台机器并未退役。

解决方法：

1.找到这台dead regionserver在HDFS上的WALs splitting文件并删除（通常目录...]]></description><category></category></item><item><title><![CDATA[CentOS 升级 gcc 和 g++ 的方法]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/104295302</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/104295302</guid><author>Mrknowledge</author><pubDate>Thu, 13 Feb 2020 14:21:14 +0800</pubDate><description><![CDATA[CentOS 系统自带的 gcc 或者 g++ 的版本是：g++ (GCC) 4.4.6. GCC 版本太旧，导致了很多使用上的不便，如：无法使用g++ -std=c++11 命令来编译 C++11、无法使用Vim的很多插件（YouCompleteMe等）。因此，有必要对它进行升级。

对 GCC 升级无法直接使用：

yum update gcc

以下是升级的详细过程。

1.使用 redha...]]></description><category></category></item><item><title><![CDATA[Yum更新（http://mirrors.163.com/.help/centos.html）]]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/104295289</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/104295289</guid><author>Mrknowledge</author><pubDate>Thu, 13 Feb 2020 14:20:05 +0800</pubDate><description><![CDATA[1.

mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup



2.

下载repo文件



3.更新缓存

yum clean all

yum makecache
]]></description><category></category></item><item><title><![CDATA[Linker error: undefined reference to symbol 'pthread_rwlock_trywrlock@@GLIBC_2.2.5']]></title><link>https://blog.youkuaiyun.com/Mrknowledge/article/details/104295247</link><guid>https://blog.youkuaiyun.com/Mrknowledge/article/details/104295247</guid><author>Mrknowledge</author><pubDate>Thu, 13 Feb 2020 14:19:04 +0800</pubDate><description><![CDATA[编译时使用 -pthread 而不是 libpthread。
]]></description><category></category></item></channel></rss>