<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[fsstyle的专栏]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/fsstyle</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; fsstyle]]></copyright><item><title><![CDATA[word小工具，根据列名删除word中所有表格对应匹配的列]]></title><link>https://blog.csdn.net/fsstyle/article/details/144586672</link><guid>https://blog.csdn.net/fsstyle/article/details/144586672</guid><author>fsstyle</author><pubDate>Thu, 19 Dec 2024 15:11:19 +0800</pubDate><description><![CDATA[alt+F11，打开VB。]]></description><category></category></item><item><title><![CDATA[word小工具，替换标题数字开头空格结尾部分为空]]></title><link>https://blog.csdn.net/fsstyle/article/details/144580133</link><guid>https://blog.csdn.net/fsstyle/article/details/144580133</guid><author>fsstyle</author><pubDate>Thu, 19 Dec 2024 10:59:01 +0800</pubDate><description><![CDATA[Pattern = "1[^ ]* " ' 匹配以1开头，直到第一个空格的部分。oRange.Text = " " ' 替换为空格。MsgBox "完成替换以1开头直到第一个空格的字符串，同时保留格式。If oPara.Style = "标题 2" Then。.IgnoreCase = False ' 区分大小写。' 使用正则表达式在标题中查找匹配的字符串。' 替换第一个匹配的字符串。.Global = True ' 替换所有匹配项。.MultiLine = True ' 多行匹配。]]></description><category></category></item><item><title><![CDATA[达梦数据库运维相关查询命令]]></title><link>https://blog.csdn.net/fsstyle/article/details/142097339</link><guid>https://blog.csdn.net/fsstyle/article/details/142097339</guid><author>fsstyle</author><pubDate>Tue, 10 Sep 2024 14:03:16 +0800</pubDate><description><![CDATA[-每个主机开启的连接数。--查询正在使用的连接。--查询出执行时间超过3s的sql;--根据sql的调用次数降序排列。--每个链接对应的会话。-- 查询系统访问用户是否过多。-- 历史大于10s的sql。]]></description><category></category></item><item><title><![CDATA[DM达梦数据库快速生成1000w数据]]></title><link>https://blog.csdn.net/fsstyle/article/details/141960380</link><guid>https://blog.csdn.net/fsstyle/article/details/141960380</guid><author>fsstyle</author><pubDate>Fri, 06 Sep 2024 15:10:06 +0800</pubDate><description><![CDATA[select rownum as id, dbms_random.string('x', 10) || '大方扣扣的妈妈网' || dbms_random.string('x', 10) random_string,]]></description><category></category></item><item><title><![CDATA[DM达梦正在执行的慢SQL以及kill]]></title><link>https://blog.csdn.net/fsstyle/article/details/141958613</link><guid>https://blog.csdn.net/fsstyle/article/details/141958613</guid><author>fsstyle</author><pubDate>Fri, 06 Sep 2024 14:15:00 +0800</pubDate><description><![CDATA[-把你想干掉的那条SQL 的sess_id 填入。-- 正在执行的sql且时间大于2秒。]]></description><category></category></item><item><title><![CDATA[mybatisplus 拦截器，切面监听实体表的新增和批量新增代替埋点]]></title><link>https://blog.csdn.net/fsstyle/article/details/140160772</link><guid>https://blog.csdn.net/fsstyle/article/details/140160772</guid><author>fsstyle</author><pubDate>Wed, 03 Jul 2024 19:37:20 +0800</pubDate><description><![CDATA[mybatisplus，通过拦截器监听实体表的批量新增和单记录新增。实现InnerInterceptor接口的beforeGetBoundSql方法和beforePrepare方法。一个是批量，一个是单条。注意：批量的话，两个接口都会执行。]]></description><category></category></item><item><title><![CDATA[DM达梦数据库设置字段类型为一个中文一个字符]]></title><link>https://blog.csdn.net/fsstyle/article/details/129809220</link><guid>https://blog.csdn.net/fsstyle/article/details/129809220</guid><author>fsstyle</author><pubDate>Tue, 28 Mar 2023 09:26:26 +0800</pubDate><description><![CDATA[【代码】DM达梦数据库设置字段类型为一个中文一个字符。]]></description><category></category></item><item><title><![CDATA[MYSQL 右模糊查询bug解决方案]]></title><link>https://blog.csdn.net/fsstyle/article/details/128283902</link><guid>https://blog.csdn.net/fsstyle/article/details/128283902</guid><author>fsstyle</author><pubDate>Mon, 12 Dec 2022 10:56:44 +0800</pubDate><description><![CDATA[MYSQL，not like 单字符开头+下划线查不出正确结果解决方案。]]></description><category></category></item><item><title><![CDATA[Elasticsearch 删字段及修改字段处理办法]]></title><link>https://blog.csdn.net/fsstyle/article/details/126400251</link><guid>https://blog.csdn.net/fsstyle/article/details/126400251</guid><author>fsstyle</author><pubDate>Thu, 18 Aug 2022 10:15:45 +0800</pubDate><description><![CDATA[elasticsearch]]></description><category></category></item><item><title><![CDATA[Skywalikng+springboot demo整合logback日志采集]]></title><link>https://blog.csdn.net/fsstyle/article/details/125663341</link><guid>https://blog.csdn.net/fsstyle/article/details/125663341</guid><author>fsstyle</author><pubDate>Thu, 07 Jul 2022 17:21:03 +0800</pubDate><description><![CDATA[Skywalking]]></description><category></category></item><item><title><![CDATA[JAVA百万抢购活动实现简易时序图]]></title><link>https://blog.csdn.net/fsstyle/article/details/123686877</link><guid>https://blog.csdn.net/fsstyle/article/details/123686877</guid><author>fsstyle</author><pubDate>Wed, 23 Mar 2022 15:21:31 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[动态列MongoDB、ES、MySql、TiDB对比]]></title><link>https://blog.csdn.net/fsstyle/article/details/117077505</link><guid>https://blog.csdn.net/fsstyle/article/details/117077505</guid><author>fsstyle</author><pubDate>Thu, 20 May 2021 15:10:31 +0800</pubDate><description><![CDATA[框架SpringBoot，spring-data-elasticsearch，spring-data-jpa，spring-data-mongodb，数据库MySQL。





]]></description><category></category></item><item><title><![CDATA[tidb一些瓶颈]]></title><link>https://blog.csdn.net/fsstyle/article/details/116941379</link><guid>https://blog.csdn.net/fsstyle/article/details/116941379</guid><author>fsstyle</author><pubDate>Mon, 17 May 2021 17:37:49 +0800</pubDate><description><![CDATA[1、对硬盘要求很高，没上SSD硬盘的不建议使用

2、不支持分区，删除数据是个大坑。

解决方案：set @@session.tidb_batch_delete=1;

3、插入数据太大也会报错

解决方案：set @@session.tidb_batch_insert=1;

4、删除表数据时不支持别名

delete from 表名 表别名where表别名.col = '1' 会报错

5、内存使用有问题，GO语言导致不知道回收机制什么时候运作。内存使用过多会导致TIDB当机（这点完全不像MY...]]></description><category></category></item><item><title><![CDATA[MongoDb Converter转化问题]]></title><link>https://blog.csdn.net/fsstyle/article/details/116755187</link><guid>https://blog.csdn.net/fsstyle/article/details/116755187</guid><author>fsstyle</author><pubDate>Thu, 13 May 2021 16:34:03 +0800</pubDate><description><![CDATA[报错：

org.bson.codecs.configuration.CodecConfigurationException: Can't find a codec for class

]]></description><category></category></item><item><title><![CDATA[通过服务器定时任务实现postgresql异库表之间的数据同步]]></title><link>https://blog.csdn.net/fsstyle/article/details/106078398</link><guid>https://blog.csdn.net/fsstyle/article/details/106078398</guid><author>fsstyle</author><pubDate>Tue, 12 May 2020 16:01:59 +0800</pubDate><description><![CDATA[postgresql10以下不支持不同实例的跨库表，可以通过psql客户端+系统定时任务实现类似功能。


sql1="truncate table table_app"
sql2="select wp.id as app_id, pv.id as version_id, pv.download as url, 'cc' as check_type from table_app"

echo "$(date "+%Y%m%d %H:%M") Begin sync game data from prd db ]]></description><category></category></item><item><title><![CDATA[postgreSQL 获取某时间是星期几]]></title><link>https://blog.csdn.net/fsstyle/article/details/89475434</link><guid>https://blog.csdn.net/fsstyle/article/details/89475434</guid><author>fsstyle</author><pubDate>Tue, 23 Apr 2019 16:27:28 +0800</pubDate><description><![CDATA[SELECT extract(DOW FROM cast('2019-04-23 16:25' as TIMESTAMP));

把DOW替换成DAY，可以获取是当月第几天。


]]></description><category></category></item><item><title><![CDATA[elasticsearch做统计分析接口请求数据，UTC时间导致的8小时无数据解决方案]]></title><link>https://blog.csdn.net/fsstyle/article/details/89006167</link><guid>https://blog.csdn.net/fsstyle/article/details/89006167</guid><author>fsstyle</author><pubDate>Wed, 03 Apr 2019 22:15:52 +0800</pubDate><description><![CDATA[这些天想收集下ES按每天每小时，服务器接口请求量的统计。方法凌晨0点至8点，无数据。

查了下，发现是UTC问题。折腾了大半天，发现不管怎么转换时间，0~8点的数据始终无数据。如下图：



后来发现，index索引也是按天来的。所以要取今日凌晨0点至8点，每小时数据。

则必须根据今日凌晨的时间转换成UTC时间或者时间戳，到昨日的index索引里取。

因为国内的时区是+8的，所以比UTC时间快...]]></description><category></category></item><item><title><![CDATA[记一次mvn极光netty包版本引起的NoSuchMethodError，导致redisson无法实例化]]></title><link>https://blog.csdn.net/fsstyle/article/details/88693709</link><guid>https://blog.csdn.net/fsstyle/article/details/88693709</guid><author>fsstyle</author><pubDate>Wed, 20 Mar 2019 17:08:38 +0800</pubDate><description><![CDATA[&lt;dependency&gt;
   &lt;groupId&gt;cn.jpush.api&lt;/groupId&gt;
   &lt;artifactId&gt;jpush-client&lt;/artifactId&gt;
   &lt;version&gt;3.3.3&lt;/version&gt;
   &lt;exclusions&gt;
      &lt;exclusi...]]></description><category></category></item><item><title><![CDATA[postgresql表死锁问题排查]]></title><link>https://blog.csdn.net/fsstyle/article/details/87917720</link><guid>https://blog.csdn.net/fsstyle/article/details/87917720</guid><author>fsstyle</author><pubDate>Mon, 25 Feb 2019 15:23:40 +0800</pubDate><description><![CDATA[1.查询激活的执行中的sql,查看有哪些更新update的sql。


select *
from pg_stat_activity
where state = 'active';



2. 查询表中存在的锁


select a.locktype, a.database, a.pid, a.mode, a.relation, b.relname
from pg_locks a
join pg...]]></description><category></category></item><item><title><![CDATA[Postgresql 跨库同步表，postgres_fdw的使用]]></title><link>https://blog.csdn.net/fsstyle/article/details/87697610</link><guid>https://blog.csdn.net/fsstyle/article/details/87697610</guid><author>fsstyle</author><pubDate>Tue, 19 Feb 2019 12:08:43 +0800</pubDate><description><![CDATA[
postgres_fdw模块
PostgreSQL 9.3 add postgres_fdw extension for accessing remote tables 
PostgreSQL 9.3新增了一个postgres_fdw模块, 已经整合在源码包中. 用于创建postgres外部表.

注：db_des为目标库，developer_month_orders_data为表名。意思就是从...]]></description><category></category></item></channel></rss>