<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Iris_33的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Iris_33</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Iris_33]]></copyright><item><title><![CDATA[离职前夕的随笔]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/126029655</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/126029655</guid><author>Iris_33</author><pubDate>Thu, 28 Jul 2022 10:47:13 +0800</pubDate><description><![CDATA[离职的心情]]></description><category></category></item><item><title><![CDATA[慢查询问题分析，优化索引]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/122941816</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/122941816</guid><author>Iris_33</author><pubDate>Tue, 15 Feb 2022 12:21:54 +0800</pubDate><description><![CDATA[问题：收到短信，数据库CPU利用率 &gt;=99%



分析流程：

1.查看mysql 7日监控图形，发现每日均有几个时间点告警：





2.查看操作日志，查看4/27 8:40附近的慢日志





发现此时数据库慢日志较多，执行时长平均100-300ms，得到慢查询的SQL



解决思路：

优化慢查询sql语句

优化索引



3.将得到的慢查询的SQL自己放到数据库里执行，查看时长，为0.221178s



使用explain执行，查看此语句走了什么索引



查看此表索引

发..]]></description><category></category></item><item><title><![CDATA[jmeter计数器与循环实现参数的遍历-优化1]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/122941662</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/122941662</guid><author>Iris_33</author><pubDate>Tue, 15 Feb 2022 12:11:24 +0800</pubDate><description><![CDATA[问题背景：

此接口两个日期只能间隔一天，如果间隔多天有性能问题，研发还没处理

需要补前半年的数据，如果手动填参数，会相当慢

优化1：用计数器加循环实现遍历，但是只能每月执行

优化2：日期先输入到csv中，从csv中读取日期参数，进行执行



1.线程组设置循环次数，每循环一次，计数器那边加一





设置计数器，初始值20220201，每次递增1





使用计数器${c_fromDate}引用





运行结果：

fromDate=20220201&amp;toDate=20220202]]></description><category></category></item><item><title><![CDATA[优化网页打开慢的问题，nginx，tomcat，java打开gzip压缩传输配置的方法]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/120910370</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/120910370</guid><author>Iris_33</author><pubDate>Fri, 22 Oct 2021 18:22:24 +0800</pubDate><description><![CDATA[本文描述内容

1.Nginx开启Gzip压缩大幅提高页面加载速度的方法

2.tomcat配置gizp压缩传输的方式

3.java服务在application里配置

4.确认服务是否打开gzip压缩传输



Nginx开启Gzip压缩大幅提高页面加载速度的方法：

1.找到nginx的配置文件./nginx/conf/nginx.conf

2.修改代码段：







    gzip  on;
    gzip_min_length 1k;
    gzip_buffers 4 16k;
  ]]></description><category></category></item><item><title><![CDATA[mysql 查看当前数据库哪张表最占用空间]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/117063937</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/117063937</guid><author>Iris_33</author><pubDate>Thu, 20 May 2021 09:51:41 +0800</pubDate><description><![CDATA[SELECT

TABLE_NAME,
concat(TRUNCATE (data_length / 1024 / 1024, 2),' MB') AS data_size,
concat(TRUNCATE (index_length / 1024 / 1024, 2),' MB') AS index_size,
concat(TRUNCATE (DATA_FREE / 1024 / 1024, 2),' MB') AS free_size
FROM
information_schema.TABLES
W.]]></description><category></category></item><item><title><![CDATA[mysql存储过程定时授权日表语句]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/117063892</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/117063892</guid><author>Iris_33</author><pubDate>Thu, 20 May 2021 09:48:46 +0800</pubDate><description><![CDATA[SET @sqlstr=CONCAT("GRANT SELECT,INSERT,UPDATE,DELETE ON `adzone_", @lastDateTime, "` TO bdm@'%';");

 INSERT INTO trans_sql_log(txt, create_date) VALUES(@sqlstr, NOW()); 

 PREPARE stmt FROM @sqlstr;

 EXECUTE stmt;

 DEALLOCATE PREPARE stmt;
...]]></description><category></category></item><item><title><![CDATA[查看当前mysql查询用户和连接 show processlist]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/117063843</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/117063843</guid><author>Iris_33</author><pubDate>Thu, 20 May 2021 09:47:48 +0800</pubDate><description><![CDATA[查看当前mysql查询用户和连接

show processlist


]]></description><category></category></item><item><title><![CDATA[mysql创建分区，查看分区]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/117063804</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/117063804</guid><author>Iris_33</author><pubDate>Thu, 20 May 2021 09:46:55 +0800</pubDate><description><![CDATA[ALTER TABLE chnl_income ADD PARTITION (PARTITION plat_income_202104 VALUES IN (202104))



SELECT

 PARTITION_NAME,

 TABLE_ROWS,

 PARTITION_EXPRESSION,

 PARTITION_DESCRIPTION

FROM

 INFORMATION_SCHEMA.PARTITIONS

WHERE TABLE_NAME = 'chnl_incom...]]></description><category></category></item><item><title><![CDATA[重命名表]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/117063765</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/117063765</guid><author>Iris_33</author><pubDate>Thu, 20 May 2021 09:46:19 +0800</pubDate><description><![CDATA[altertablet1rename to t2;
]]></description><category></category></item><item><title><![CDATA[java，tomcat，ngnix配置压缩返回报文，减少带宽，加快页面刷新速度，响应时间]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/117063453</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/117063453</guid><author>Iris_33</author><pubDate>Thu, 20 May 2021 09:45:00 +0800</pubDate><description><![CDATA[java服务：

要在application.properties里面配置：

server.compression.enabled=true

server.compression.minResponseSize=512

server.compression.mime-types=application/json,application/xml,text/html,text/xml,text/plain



tomcat：

如果tomcat返回的相应中含有大量文本数据，我们可以考虑开启tomat的.]]></description><category></category></item><item><title><![CDATA[ClearLog.bat]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/117062386</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/117062386</guid><author>Iris_33</author><pubDate>Thu, 20 May 2021 09:16:49 +0800</pubDate><description><![CDATA[forfiles /p D:\adsstat\adsstat1\logs\ /s /m *.log /d -7 /c "cmd /c del @path"

forfiles /p D:\adsstat\adsstat1_b\logs\ /s /m *.log /d -7 /c "cmd /c del @path"

forfiles /p D:\adsstat\adsstat2\logs\ /s /m *.log /d -7 /c "cmd /c del @path"

forfiles /p D:\ad]]></description><category></category></item><item><title><![CDATA[问题记录：tomcat提示错误1067意外终止程序]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/116980319</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/116980319</guid><author>Iris_33</author><pubDate>Tue, 18 May 2021 11:03:49 +0800</pubDate><description><![CDATA[问题现象：





解决方式：修正toncat7w里的java virtual machine路径

原先：C:\Program Files\Java\jdk1.8.0_151\jre\bin\server\jvm.dll

修改为：C:\Program Files\Java\jre1.8.0_151\bin\server\jvm.dll




]]></description><category></category></item><item><title><![CDATA[内存问题OOM和GC，用PrintGCDetails HeapDumpOnOutOfMemoryError输出相关信息]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/108090231</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/108090231</guid><author>Iris_33</author><pubDate>Tue, 18 Aug 2020 23:29:51 +0800</pubDate><description><![CDATA[OOM和GC可以添加JVM参数HeapDumpOnOutOfMemoryError，PrintGCDetails来查看相关信息。
参数需要放在java和-jar中间
举例：
java -Xms64M -Xmx256M -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/root/EventUpUserTimeStat -XX:+PrintGCDetails -Xloggc:/root/EventUpUserTimeStat/logs/gclog.log -ja]]></description><category></category></item><item><title><![CDATA[shell命令行获取kafka消费情况]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/108090180</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/108090180</guid><author>Iris_33</author><pubDate>Tue, 18 Aug 2020 23:26:03 +0800</pubDate><description><![CDATA[原先是用kafkaManager查看kafka消费积压情况，后面基于平衡几台服务器内存，把kafkaManger关了，需要使用kafka自带的sh查看消费情况

常用命令：

获取topic列表/usr/local/kafka/bin/kafka-topics.sh --list --zookeeper kafka1:2181/
topic group
allEvents groupIdEv1
allEvents2 groupIdEv2
allEvents3 groupIdEv3
allNewEvent s]]></description><category></category></item><item><title><![CDATA[设置服务开机自启动]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/108090118</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/108090118</guid><author>Iris_33</author><pubDate>Tue, 18 Aug 2020 23:20:11 +0800</pubDate><description><![CDATA[编辑/etc/rc.d/下的rc.local文件


1.如果还没有给与rc.local文件可执行权限,则先执行命令赋予rc.local可执行权限chmod +x /etc/rc.d/rc.local


2.然后vi rc.local文件,以在/mnt/why文件夹下执行脚本为例，加上开机执行的动作:
touch /var/lock/subsys/local
cd /mnt/why
./monitor.sh &gt;&gt; logfile.log 2&gt;&amp;1

systemctl resta]]></description><category></category></item><item><title><![CDATA[2020-08-18 工作问题：linux的mongo库磁盘占用95%，需要写js脚本定时清除1个月以前的数据]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/108090023</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/108090023</guid><author>Iris_33</author><pubDate>Tue, 18 Aug 2020 23:15:30 +0800</pubDate><description><![CDATA[var saveDay=30;//保留30天数据
var months = ['01','02','03','04','05','06','07','08','09','10','11','12'];
var days = ['01','02','03','04','05','06','07','08','09'];//解决缺0的问题

var i;//删除前30-前40天的日表
for (i = 10; i &gt; 0; i--) {
    var currentTimeMill=(new Date.]]></description><category></category></item><item><title><![CDATA[let's encrypt ssl证书续期]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/104916697</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/104916697</guid><author>Iris_33</author><pubDate>Tue, 17 Mar 2020 10:59:46 +0800</pubDate><description><![CDATA[证书有效期为三个月，每三个月需要重新生成一次，在此记录：

1.收到证书到期邮件

2.登录网站https://www.sslforfree.com/certificates



3.点击续订/Renew





4.点击手动验证域



5.根据提示，去DNS域名解析的地方，添加DNS TXT记录，点击验证



6.验证的txt匹配，点击下载，得到三个文件



7.登录服务器，更新证书...]]></description><category></category></item><item><title><![CDATA[adb常用命令]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/69367402</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/69367402</guid><author>Iris_33</author><pubDate>Wed, 05 Apr 2017 23:17:50 +0800</pubDate><description><![CDATA[问题：不关机的情况下结束自动化测试monkey的进程


查看后台进程adb shell ps
显示：com.android.commands.monkey 进程PID
结束进程：adb shell kill pid]]></description><category></category></item><item><title><![CDATA[自动push apk的批处理文件]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/69367340</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/69367340</guid><author>Iris_33</author><pubDate>Wed, 05 Apr 2017 23:07:41 +0800</pubDate><description><![CDATA[问题环境： 
每天做自动化测试时，跑monkey，有时需要更新某一个apk，每次敲5条命令很麻烦。 
更新apk给其他人，有人敲push路径错误解决： 
写一个bat脚本，双击则自动安装apk至手机手动安装命令apk
  adb root 
  adb remount 
  adb push xxx.apk xxx 
  adb shell sync 
  adb shell reboot
脚本自动]]></description><category></category></item><item><title><![CDATA[版本控制软件 perforce 与 git]]></title><link>https://blog.youkuaiyun.com/Iris_33/article/details/69367220</link><guid>https://blog.youkuaiyun.com/Iris_33/article/details/69367220</guid><author>Iris_33</author><pubDate>Wed, 05 Apr 2017 22:52:48 +0800</pubDate><description><![CDATA[毕业一年 开经验总结帖
  版本控制软件提供完备的版本管理功能，用于存储、追踪目录(文件夹)和文件的修改历史，是软件开发者的必备工具，是软件公司的基础设施。版本控制软件的最高目标，是支持软件公司的配置管理活动，追踪多个版本的开发和维护活动，及时发布软件。
初入公司使用perforce进行版本控制 
后公司为节约成本改用免费的git开始用git的时候，还是觉得p4好用，分支管理，目录结构可视化等等。]]></description><category></category></item></channel></rss>