<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[java19930421的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/java19930421</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; java19930421]]></copyright><item><title><![CDATA[Windows 安装 MySQL 5.7 启动失败：Starting the server Failed、Permission denied、mysql.plugin 不存在解决记录]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/165628368</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/165628368</guid><author>java19930421</author><pubDate>Wed, 16 Sep 2026 20:42:31 +0800</pubDate><description><![CDATA[安装 MySQL Server 5.7.44↓MySQL Installer 配置数据库↓Data 目录权限异常↓NETWORK SERVICE 无法访问 Data↓↓MySQL 初始化不完整↓mysql 系统数据库缺失↓↓同时 my.ini 存在 mysqlx_port 不兼容配置↓↓↓MySQL57 Windows Service 无法启动↓↓检查 3306 端口↓↓发现 Permission denied↓takeown 获取 Data 所有权↓。]]></description><category></category></item><item><title><![CDATA[通过xtrabackup工具完成mysql大量数据迁移]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/148620025</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/148620025</guid><author>java19930421</author><pubDate>Thu, 12 Jun 2025 22:57:25 +0800</pubDate><description><![CDATA[最近，我们部署的MySQL主从复制集群出现从库同步异常问题，导致从库无法正常接收主库的binlog日志更新。由于同步中断时间较长，主从数据库已产生显著数据差异，且现有备份方案无法有效恢复数据一致性。由于主库数据量较大，采用传统的SQL文件导出再导入从库的方式容易因内存溢出导致进程中断。为规避此风险，现决定采用XtraBackup工具进行数据迁移，该方案通过物理备份方式直接复制数据文件，能有效处理海量数据场景，同时支持热备份保障业务连续性。]]></description><category></category></item><item><title><![CDATA[mysql 8.0.32 开启远程连接]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/148099923</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/148099923</guid><author>java19930421</author><pubDate>Wed, 21 May 2025 22:32:14 +0800</pubDate><description><![CDATA[MySQL 8.0服务实例已成功部署并正常运行，本地通过mysql -uroot -p命令行客户端可正常访问数据库，且基础SQL操作无异常。]]></description><category></category></item><item><title><![CDATA[ubuntu系统安装 nginx 和 keeplived 集群]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/146510916</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/146510916</guid><author>java19930421</author><pubDate>Tue, 25 Mar 2025 19:57:47 +0800</pubDate><description><![CDATA[Nginx 是一款高性能的 HTTP 和反向代理服务器，广泛应用于网站的负载均衡和静态资源服务。而 Keepalived 是一款基于 VRRP 协议实现高可用的软件。将 Nginx 与 Keepalived 结合，可以构建一个高可用的负载均衡集群，确保在服务器故障时，业务能够无缝切换，提高系统的可靠性和稳定性。]]></description><category></category></item><item><title><![CDATA[clickhouse 报错 Not enough privileges. To execute this query, it‘s necessary to have the grant]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/145038230</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/145038230</guid><author>java19930421</author><pubDate>Thu, 09 Jan 2025 17:21:38 +0800</pubDate><description><![CDATA[clickhouse执行命令时报错。]]></description><category></category></item><item><title><![CDATA[DBeaver连接clickhouse时 报错 There is no session or session context has expired.]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/145011987</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/145011987</guid><author>java19930421</author><pubDate>Wed, 08 Jan 2025 16:29:35 +0800</pubDate><description><![CDATA[设置好初始连接后，在sql编辑器中执行命令执行后报错SQL 错误 [113] [07000]: Code: 113. DB::Exception: There is no session or session context has expired. (THERE_IS_NO_SESSION) (version 22.1.3.7 (official build))]]></description><category></category></item><item><title><![CDATA[nacos下线服务节点报错 com.alibaba.nacos.consistency.exception.ConsistencyException: Could not find leader]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/145011149</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/145011149</guid><author>java19930421</author><pubDate>Wed, 08 Jan 2025 16:04:01 +0800</pubDate><description><![CDATA[这个错误表明Nacos客户端尝试获取或更新服务实例的元数据时，无法找到当前的领导者（leader）。在分布式系统中，"领导者"是指负责处理特定类型请求的节点。当集群中的一个节点被选举为领导者后，其他节点将跟随该领导者的指示。文件夹一般路径 /home/nacos/data/protocol。需要删除protocol文件夹 重新启动容器，建立新的配置。]]></description><category></category></item><item><title><![CDATA[mysql报错 this is incompatible with sql_mode=only_full_group_by]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/144970928</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/144970928</guid><author>java19930421</author><pubDate>Mon, 06 Jan 2025 20:25:36 +0800</pubDate><description><![CDATA[sql语句报错：which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ; bad SQL grammar []; nested exception is 解决方法]]></description><category></category></item><item><title><![CDATA[mysql 基础（三）- springboot项目连接mysql]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/135401960</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/135401960</guid><author>java19930421</author><pubDate>Thu, 18 Jan 2024 16:40:15 +0800</pubDate><description><![CDATA[下一步选择springWeb完成。]]></description><category></category></item><item><title><![CDATA[mysql基础（二）-数据库增、删、改、查]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/135371001</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/135371001</guid><author>java19930421</author><pubDate>Thu, 04 Jan 2024 18:09:34 +0800</pubDate><description><![CDATA[数据库增、删、改、查]]></description><category></category></item><item><title><![CDATA[mysql基础（一）新建数据库、数据表、数据导入、导出]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/135369662</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/135369662</guid><author>java19930421</author><pubDate>Wed, 03 Jan 2024 18:54:36 +0800</pubDate><description><![CDATA[数据库表、搭建]]></description><category></category></item><item><title><![CDATA[Windows因权限问题无法删除文件夹]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/135354730</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/135354730</guid><author>java19930421</author><pubDate>Wed, 03 Jan 2024 09:22:45 +0800</pubDate><description><![CDATA[1、在路径框中输入cmd命令打开cmd命令框。2、在命令框中输入命令 rd /s /q filename  filename中输入文件夹的相对路径或者绝对路径，如同。3、如果报文件目录为空则再执行一次 rd /s /q filename命令即可删除。]]></description><category></category></item><item><title><![CDATA[报错：Failure to find xx:pom:1.0.0 in was cached in http:// the local repository]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/132859358</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/132859358</guid><author>java19930421</author><pubDate>Wed, 13 Sep 2023 18:09:25 +0800</pubDate><description><![CDATA[【代码】报错：Failure to find xx:pom:1.0.0 in was cached in http:// the local repository。]]></description><category></category></item><item><title><![CDATA[安装centos7记录笔记]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/132087742</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/132087742</guid><author>java19930421</author><pubDate>Wed, 13 Sep 2023 14:34:25 +0800</pubDate><description><![CDATA[这里要注意兼容性，如果是VMware12创建的虚拟机复制到VM11、10或者更低的版本会出现一不兼容的现象。这里选择之后安装的操作系统，正确的选择会让vm tools更好的兼容。自定义安装：自定义安装可以针对性的把一些资源加强，把不需要的资源移除。典型安装：VMware会将主流的配置应用在虚拟机的操作系统上，对于新手来很友好。我的宿主机内存是8G所以我给虚拟机分配2G内存。8.网络连接类型的选择，网络连接类型一共有桥接、NAT、仅主机和不联网四种。虚拟机名称就是一个名字，在虚拟机多的时候方便自己找到。]]></description><category></category></item><item><title><![CDATA[leecode算法1-1124 表现良好的最长时间段（JAVA）]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/121280608</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/121280608</guid><author>java19930421</author><pubDate>Fri, 12 Nov 2021 08:57:51 +0800</pubDate><description><![CDATA[1、题目
给你一份工作时间表 hours，上面记录着某一位员工每天的工作小时数。
我们认为当员工一天中的工作小时数大于 8 小时的时候，那么这一天就是「劳累的一天」。
所谓「表现良好的时间段」，意味在这段时间内，「劳累的天数」是严格 大于「不劳累的天数」。
请你返回「表现良好时间段」的最大长度。
来源：力扣（LeetCode）
链接：https://leetcode-cn.com/problems/longest-well-performing-interval
著作权归领扣网络所有。商业转载请联系官方授权]]></description><category></category></item><item><title><![CDATA[left join用法]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/121220539</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/121220539</guid><author>java19930421</author><pubDate>Tue, 09 Nov 2021 08:56:56 +0800</pubDate><description><![CDATA[1、什么是left join on
left join on是数据库中的常用联表语句
2、left join on 语法介绍
"()"中的内容为说明可以去掉
select a.*(a表中的所有字段) 
from tablenameA(表格名称) a(表格命名)
left join tablenameB(表格名称)   b (表格命名)
on  a.bid = b.id (将b表中id中与a表中bid中的字段值相同的数据连接起来，并展示)
and b.status = '1'  （增加联表时的筛选条件）
le]]></description><category></category></item><item><title><![CDATA[mybatis中＜foreach＞用法及相关问题（多参数情况）]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/121115801</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/121115801</guid><author>java19930421</author><pubDate>Wed, 03 Nov 2021 11:08:39 +0800</pubDate><description><![CDATA[1、标签foreach作用
编写mybatis中的mapper.xml文件时，我们可使用&lt;foreach&gt;标签将数组或列表等数据类型动态生成适用于查找的sql语句。
例如将数据string[] ids= {'1','2','3'} 转换为 ('1','2','3')
2、标签foreach的主要属性
item：集合中元素迭代时的别名，该参数为必选。
index：在list和数组中,index是元素的序号，在map中，index是元素的key，该参数可选
open：foreach代码的开始符号，一]]></description><category></category></item><item><title><![CDATA[Bootstrap-table使用，配置，及常见问题]]></title><link>https://blog.youkuaiyun.com/java19930421/article/details/105241339</link><guid>https://blog.youkuaiyun.com/java19930421/article/details/105241339</guid><author>java19930421</author><pubDate>Wed, 01 Apr 2020 15:52:28 +0800</pubDate><description><![CDATA[1、什么是Bootstrap-Table
   Bootstrap 是基于HTML、CSS、JS的，用于快速开发web应用程序和网站的前端框架。
   在业务开发中，对表格记录的查询、分页、排序等处理是非常常见的，Bootstrap-table插件提供了非常丰富的属性设置。可以实现查询、分页、排序、复选框、设置显示列、Card view视图、主从表显示、合并列、国际化处理等处理功能。

插件可以用...]]></description><category></category></item></channel></rss>