<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[麻辣香蕉]]></title><description><![CDATA[遇山开山，遇水搭桥，燃烧我的每一分热血，浇铸我的梦想]]></description><link>https://blog.youkuaiyun.com/weixin_36524613</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; weixin_36524613]]></copyright><item><title><![CDATA[clickhouse数据手动迁移]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/122731022</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/122731022</guid><author>weixin_36524613</author><pubDate>Fri, 28 Jan 2022 14:34:34 +0800</pubDate><description><![CDATA[1、需要拷贝文件


#### a、全部迁移：
/var/lib/clickhouse/data
/var/lib/clickhouse/metadata
#### b、迁移单表：
/var/lib/clickhouse/data/pangu/tablename
/var/lib/clickhouse/metadata/pangu/tablename.sql

2、拷贝到新机器目录，注意两个文件，不要忘了metadata


#备份新机器原本的data和metadata
/var/lib/clickhous]]></description><category></category></item><item><title><![CDATA[mysql、clickhouse读写分离性能测试]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/122728473</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/122728473</guid><author>weixin_36524613</author><pubDate>Fri, 28 Jan 2022 11:13:02 +0800</pubDate><description><![CDATA[背景：

直接用clickhosue处理，每次更新有1秒的延迟（目前提交机制1秒或者1000条提交一次）；

clickhouse支持导入mysql数据，也支持统计查询mysql数据；

所以测试评估一下mysql直接统计查询、使用clickhouse统计查询mysql数据、直接使用clickhouse查询统计的性能对比；


1、导入测试数据100w

插入性能：mysql-&gt; 300/s；2核、16g内存

 Clickhouse-&gt; 20000/s；2核...]]></description><category></category></item><item><title><![CDATA[Webserver内存溢出分析]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/122728150</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/122728150</guid><author>weixin_36524613</author><pubDate>Fri, 28 Jan 2022 11:03:00 +0800</pubDate><description><![CDATA[1、监控内存使用率

jps -l 查找webserver进程号




#监控内存使用情况
jmap -heap 91110   




2、生成dump文件


jmap -dump:format=b,file=heap.prof pid

3、将dump文件拷贝出来，使用mat打开

能够清晰定位cpu、内存占用较大模块





4、定位模块啦，接下来就是愉快的优化代码啦


...]]></description><category></category></item><item><title><![CDATA[安装memory analyzer]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/122721020</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/122721020</guid><author>weixin_36524613</author><pubDate>Thu, 27 Jan 2022 17:22:25 +0800</pubDate><description><![CDATA[1、下载

Eclipse Memory Analyzer Open Source Project | The Eclipse Foundation

或者百度网盘：链接：https://pan.baidu.com/s/19S9fCZ9My8VrKpMe41lxlg

提取码：aidl



2、解压





3、启动





4、注意

Mat1.12版本需要java11以上，本地可以配置多个jdk


...]]></description><category></category></item><item><title><![CDATA[clickhouse常用sql]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/120891234</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/120891234</guid><author>weixin_36524613</author><pubDate>Thu, 21 Oct 2021 18:56:07 +0800</pubDate><description><![CDATA[1、慢查询监控


SELECT
    user,
    formatDateTime(query_start_time, '%Y%m%d %T') AS start_time,
    query_duration_ms / 1000 AS query_duration_s,
     query,
    memory_usage / 1024 / 1024 / 1024 AS memory_usage_g,
    result_rows ,
    formatReadableSize(resu]]></description><category></category></item><item><title><![CDATA[按字段顺序加载或解析JSON对象]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/120866147</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/120866147</guid><author>weixin_36524613</author><pubDate>Wed, 20 Oct 2021 15:15:15 +0800</pubDate><description><![CDATA[1、保证json对象按put顺序加载属性


// 保证json对象按字段顺序put
JSONObject jsonObject = new JSONObject(true);

原理：



2、字符串解析json对象字段有序


JSONObject jsonObject = JSONObject.parseObject(jsonString, Feature.OrderedField);



...]]></description><category></category></item><item><title><![CDATA[mysql实时物化到clickhouse（MaterializeMySQL）]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/118734532</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/118734532</guid><author>weixin_36524613</author><pubDate>Wed, 14 Jul 2021 18:53:34 +0800</pubDate><description><![CDATA[Creates ClickHouse database with all the tables existing in MySQL, and all the data in those tables.

ClickHouse server works as MySQL replica. It reads binlog and performs DDL and DML queries.

This feature is experimental.

使用 MySQL 中存在的所有表以及这些表中的所有数据创建.]]></description><category></category></item><item><title><![CDATA[linux安装包安装mysql5.7]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/118733729</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/118733729</guid><author>weixin_36524613</author><pubDate>Wed, 14 Jul 2021 18:14:48 +0800</pubDate><description><![CDATA[1、下载

https://dev.mysql.com/downloads/mysql/5.7.html#downloads



2、本地环境配置


yum install libaio
groupadd mysql
useradd -r -g mysql mysql

3、解压移动


tar -zxvf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.33-linux-glibc2.12-x86_64 /usr/local/mysql
]]></description><category></category></item><item><title><![CDATA[syslog数据接收并处理]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/118357703</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/118357703</guid><author>weixin_36524613</author><pubDate>Wed, 30 Jun 2021 11:42:00 +0800</pubDate><description><![CDATA[导包：


            &lt;dependency&gt;
                &lt;groupId&gt;org.graylog2&lt;/groupId&gt;
                &lt;artifactId&gt;syslog4j&lt;/artifactId&gt;
                &lt;version&gt;0.9.60&lt;/version&gt;
            &lt;/dependency&gt;



重写接收处理器：]]></description><category></category></item><item><title><![CDATA[Mac下安装MariaDB(自用备忘)]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/118186783</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/118186783</guid><author>weixin_36524613</author><pubDate>Thu, 24 Jun 2021 14:21:24 +0800</pubDate><description><![CDATA[1、下载MariaDB 10.2.6稳定版（免费），选择版本时选择MAC .pkg版本：


https://downloads.mariadb.org/mariadb/10.2.6/

2、官网安装说明：


https://mariadb.com/kb/en/mariadb/installing-mariadb-server-pkg-packages-on-macos/

3、安装完后，默认的用户名是root，密码为空，但是用远程工具（譬如Navicat）远程连接时不能用root用户连接，必须新建用户；]]></description><category></category></item><item><title><![CDATA[ES批量提交-RestHighLevelClient]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/118092016</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/118092016</guid><author>weixin_36524613</author><pubDate>Mon, 21 Jun 2021 18:11:03 +0800</pubDate><description><![CDATA[引包：


            &lt;dependency&gt;
                &lt;groupId&gt;org.elasticsearch.client&lt;/groupId&gt;
                &lt;artifactId&gt;elasticsearch-rest-high-level-client&lt;/artifactId&gt;
                &lt;version&gt;6.8.13&lt;/version&gt;
   ]]></description><category></category></item><item><title><![CDATA[java异步执行任务]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/118083997</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/118083997</guid><author>weixin_36524613</author><pubDate>Mon, 21 Jun 2021 12:16:32 +0800</pubDate><description><![CDATA[java异步执行可以使用线程，或者第三方消息中间件，如mq；

线程池的使用：


ThreadPoolExecutor es = new ThreadPoolExecutor(50, 50, 0L, TimeUnit.SECONDS, new LinkedBlockingQueue&lt;Runnable&gt;(), new ThreadFactory() {
            @Override
            public Thread newThread(Runnable r) {
]]></description><category></category></item><item><title><![CDATA[Ehcache存储策略总结]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/118068542</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/118068542</guid><author>weixin_36524613</author><pubDate>Sun, 20 Jun 2021 13:02:14 +0800</pubDate><description><![CDATA[如何使用


]]></description><category></category></item><item><title><![CDATA[es创建索引库，无法使用InetSocketTransportAddress]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/118030812</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/118030812</guid><author>weixin_36524613</author><pubDate>Fri, 18 Jun 2021 17:35:09 +0800</pubDate><description><![CDATA[6.8版本以上不在支持InetSocketTransportAddress，huan cheng


]]></description><category></category></item><item><title><![CDATA[Mac中Idea 切换不同项目快捷键]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/116998022</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/116998022</guid><author>weixin_36524613</author><pubDate>Tue, 18 May 2021 18:20:17 +0800</pubDate><description><![CDATA[command + `



这个快捷键可以快速切换同一个软件中不同的窗口，比鼠标操作更快，比如

Chrome 浏览器，每个用户都有自己的窗口，按 command + ` 能就能快速切换。
Idea / Pycharm / PHPStorm / Android studio 等，每个项目都有一个独立的窗口，用 command + ` 同样能快速切换。




...]]></description><category></category></item><item><title><![CDATA[python3安装步骤]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/111319285</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/111319285</guid><author>weixin_36524613</author><pubDate>Thu, 17 Dec 2020 16:48:49 +0800</pubDate><description><![CDATA[1. 安装依赖环境
# yum -y install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gdbm-devel db4-devel libpcap-devel xz-devel

2.下载Python3
https://www.python.org/downloads/
# wget https://www.python.org/ftp/python/3.6.1/Pyt]]></description><category></category></item><item><title><![CDATA[redis安装步骤]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/111224070</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/111224070</guid><author>weixin_36524613</author><pubDate>Tue, 15 Dec 2020 16:21:38 +0800</pubDate><description><![CDATA[安装redis：1、下载安装包
2、安装gcc等编译工具
yum -y install gcc gcc-c++ automake pcre pcre-devel zlib zlib-devel open openssl-devel3、解压
#tar -xvf redis-3.0.4.tar.gz

4、进入解压目录
# cd redis-3.0.4/deps

5、编译
# make hiredis lua jemalloc linenois
# make geohash-int
# cd ..
# ma.]]></description><category></category></item><item><title><![CDATA[nginx安装步骤]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/111224025</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/111224025</guid><author>weixin_36524613</author><pubDate>Tue, 15 Dec 2020 16:20:33 +0800</pubDate><description><![CDATA[Nginx 的官方下载地址为：http://nginx.org/en/download.html。
稳定版本Stable version

1、准备工作、安装工具

yum -y install gcc gcc-c++ automake pcre pcre-devel zlib zlib-devel open openssl-devel

2、解压

tar -xvf nginx-1.6.3.tar.gz
cd nginx-1.6.3

3、将当前工作路径定位到/app/nginx/nginx-1.6.3.]]></description><category></category></item><item><title><![CDATA[nacos安装步骤]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/111223984</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/111223984</guid><author>weixin_36524613</author><pubDate>Tue, 15 Dec 2020 16:19:25 +0800</pubDate><description><![CDATA[安装nacos1、下载安装包

2、解压即可

3、创建数据库，导入/nacos/conf/nacos-mysql.sql

4、修改/nacos/conf/application.properties
 可修改端口

 添加数据库信息
 spring.datasource.platform=mysql
 db.num=1
 db.url.0=jdbc:mysql://192.168.0.238:3306/nacos?characterEncoding=utf8&amp;con...]]></description><category></category></item><item><title><![CDATA[mysql5.7安装步骤]]></title><link>https://blog.youkuaiyun.com/weixin_36524613/article/details/111223288</link><guid>https://blog.youkuaiyun.com/weixin_36524613/article/details/111223288</guid><author>weixin_36524613</author><pubDate>Tue, 15 Dec 2020 16:08:17 +0800</pubDate><description><![CDATA[1、安装mysql
查看原本mysql相关包
# rpm -qa|grep mysql
# ps -ef | grep mysql
# service mysqld stop
# rpm -e mysql-libs --nodeps
# yum -y remove mysql mysql-*
安装common rpm
安装lib   rpm
安装client rpm
安装serer rpm
安装devel rpm

2、启动,第一遍启动不成功就在启动几遍，三遍不成功查看启动日志
 s...]]></description><category></category></item></channel></rss>