- 博客(369)
- 资源 (32)
- 收藏
- 关注
RSS订阅原创 The total number of locks exceeds the lock table size问题处理
The total number of locks exceeds the lock table size
2025-02-17 15:42:31
253
原创 SQL Server 插入数据出现异常 com.microsoft.sqlserver.jdbc.SQLServerException: 必须执行该语句才能获得结果
设置为ON时，不会返回受影响的行数信息，这可以减少网络流量和提升性能，尤其是在执行大量不返回实际数据的操作时。原因：表log有触发器，修改触发器才能解决。中的一个设置命令，用于控制是否在执行。语句时返回受影响的行数信息。
2024-12-23 18:00:12
287
原创 MySQL删除重复数据只保留最早的一条
DELETE FROM app_charg WHERE id NOT IN (select id from (SELECT MIN(id) as id FROM app_charg GROUP BY phone, tenant_id) a );
2024-03-11 11:12:39
625
原创 ElasticSearch报错blocked by: [FORBIDDEN/12/index read-only / allow delete (api)]
ElasticSearch索引只有只读和删除权限的问题
2022-09-09 18:49:49
3565
1
原创 CentOS 7 firewall防火墙命令
1：运行状态[root@iZwz9ecyyd9aqswfdpvkvtZ ~]# firewall-cmd --staterunning2：新增端口[root@iZwz9ecyyd9aqswfdpvkvtZ ~]# firewall-cmd --zone=public --add-port=8066/tcp --permanentsuccess[root@iZwz9ecyyd9aqswfdpvkvtZ ~]# firewall-cmd --zone=public --add-port=
2022-03-01 11:24:56
2602
原创 elasticsearch 通过curl的操作
1：curlcurl -h来查看请求参数的含义-v 显示请求的信息-X 选项指定其它协议get: curl -v 127.0.0.1:8080/users/age/18 post: curl -v 127.0.0.1:8080/users -d 'age=14&cupSize=C' curl -v -X POST 127.0.0.1:8080/users -d 'age=14&cupSize=C' put: curl -v -X...
2021-10-16 16:22:19
390
原创 MISCONF Redis is configured to save RDB snapshots, but is currently not able to persist on disk.
org.springframework.data.redis.RedisSystemException: Error in execution; nested exception is io.lettuce.core.RedisCommandExecutionException: MISCONF Redis is configured to save RDB snapshots, but is currently not able to persist on disk. Commands that may
2021-09-09 11:24:42
1840
原创 rocketmq安装
1：解压[root@iZwz94zhiwnwqzf7b66yxqZ middle]# unzip rocketmq-all-4.9.0-bin-release.zipArchive: rocketmq-all-4.9.0-bin-release.zip2：运行[root@iZwz94zhiwnwqzf7b66yxqZ bin]# ./mqnamesrv &[1] 61659[root@iZwz94zhiwnwqzf7b66yxqZ bin]# Java HotSpot(TM) ..
2021-09-08 17:22:53
217
原创 elasticsearch-7.3安装
1：Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release[root@iZwz94zhiwnwqzf7b66yxqZ bin]# OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be remo
2021-09-08 17:20:52
266
原创 centos8安装mongodb5
1:下载服务端：https://repo.mongodb.org/yum/redhat/8/mongodb-org/5.0/x86_64/RPMS/mongodb-org-server-5.0.2-1.el8.x86_64.rpmShell工具：https://repo.mongodb.org/yum/redhat/8/mongodb-org/5.0/x86_64/RPMS/mongodb-org-shell-5.0.2-1.el8.x86_64.rpm数据导入导出工具：https://repo
2021-09-07 22:42:24
828
原创 mongodb创建用户
1:创建管理员D:\mongodb\bin\mongo --port 27017MongoDB shell version v4.2.15connecting to: mongodb://127.0.0.1:27017/?compressors=disabled&gssapiServiceName=mongodbImplicit session: session { "id" : UUID("df917c43-c160-41af-8f13-ad42e0a31abe") }MongoDB
2021-09-07 14:44:01
311
原创 centos8中一键安装Nginx
1：检查是否安装[root@aa ~]# nginx -v-bash: nginx: command not found2：一键安装yum install -y nginx[root@aa ~]# yum install -y nginxLast metadata expiration check: 0:43:45 ago on Sun 29 Aug 2021 09:40:34 AM CST.Dependencies resolved.=======================
2021-08-29 10:37:36
827
1
原创 Ubuntu修改root密码以及允许证书和密码登陆
1：修改sshd_configroot@micro-node3:~# cd /etc/ssh/root@micro-node3:/etc/ssh# cat sshd_config# Package generated configuration file# See the sshd_config(5) manpage for details# What ports, IPs and protocols we listen forPort 22# Use these options ..
2021-08-27 18:59:06
718
原创 CentOS8 安装Docker
# cat /proc/versionLinux version 4.18.0-193.28.1.el8_2.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 8.3.1 20191121 (Red Hat 8.3.1-5) (GCC)) #1 SMP Thu Oct 22 00:20:22 UTC 20201:# sudo dnf config-manager --add-repo=https://download.docke..
2021-08-26 19:12:47
721
原创 mysql5.7优化
1：查询显示当前的隔离级别mysql> show global variables like '%isolation%';+-----------------------+----------------+| Variable_name | Value |+-----------------------+----------------+| t...
2020-01-03 19:51:36
491
原创 nacos client 请求过程
1：获取配置信息127.0.0.1 - - [10/Nov/2019:17:15:02 +0800] "POST /nacos/v1/cs/configs/listener HTTP/1.1" 499 0 "-" "Java/1.8.0_65"127.0.0.1 - - [10/Nov/2019:17:15:10 +0800] "GET /nacos/v1/cs/configs?dataId...
2019-11-10 17:21:41
4110
原创 mysql数据库统计
SELECT TABLE_SCHEMA,concat(round((sum(DATA_LENGTH)+sum(INDEX_LENGTH))/1024/1024,2),'MB') as size FROMinformation_schema.TABLES group by TABLE_SCHEMA;SELECT table_name,table_rows,DATA_LENGTH ,IND...
2019-11-02 10:31:36
647
原创 mysql5.6 error
1:[Err] 1071 - Specified key was too long; max key length is 767 bytes2：[Err] 1709 - Index column size too large. The maximum column size is 767 bytes.3.[Err] 1215 - Cannot add foreign key constr...
2019-05-25 15:03:51
403
原创 mysql
1:select Host,User,max_questions,max_updates,max_connections,authentication_string,password_expired,password_last_changed,account_locked from user;update user set account_locked='Y' where Host='%'...
2019-04-19 20:09:59
227
原创 MYSQL [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
1:重启[root@iZuf63x5aylgn2n11k2sllZ etc]# systemctl restart mysqlJob for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl...
2019-04-16 18:06:01
5359
原创 mysql5.7主从
1：主mysql,创建复制用户mysql> create user 'repl'@'172.xx.xx.%' identified by 'xxxx';Query OK, 0 rows affected (0.01 sec)mysql> grant replication slave on *.* to 'repl'@'172.xx.xx.%' identified by ...
2019-04-08 15:48:44
269
原创 Mac 安装rabbitmq
brew install rabbitmqsoftdeMacBook-Pro:~ softsun$ brew install rabbitmq==> Installing dependencies for rabbitmq: xz, openssl, jpeg, libpng, libt==> Installing rabbitmq dependency: xz==> Do...
2018-06-05 18:29:36
772
原创 docker0: iptables: No chain/target/match by that name
[root@iZuf6boi8ejfovwda7q1ynZ ~]# docker start some-piwikError response from daemon: driver failed programming external connectivity on endpoint some-piwik (2ef09f672f43162e281d97f30a21dd392c56c2bb72...
2018-04-02 22:02:00
1309
2
原创 docker piwik
1: docker search piwik docker pull docker.io/piwik2: 运行docker run --name some-piwik -d piwik3：检查参数 docker inspect some-piwik4:删除docker stop some-piwik docker rm some-piwik5：docker run --name some-piw...
2018-04-01 20:22:39
495
原创 日志 查看匹配内容的前后几行
cat -n /opt/tomcat/logs/catalina.out |grep "property.cooperationResident.savebindCustomerHouse" |more tail -f /opt/tomcat/logs/catalina.out | grep "com.agile.base.push" -i匹配的字符串显示grep -2
2018-02-04 13:43:23
6293
原创 ngrok编译和安装
1：安装git[root@iZuf6h59snssqyqa3ka87eZ home]# yum install git[root@iZuf6h59snssqyqa3ka87eZ home]# yum install gitLoaded plugins: fastestmirror
2018-01-09 18:33:32
2826
原创 docker svn
1 安装docker pull paulovsm/svn-server2 运行docker run --name svn -p 8082:80 -v /home/svn:/home/svn -d paulovsm/svn-server3 访问：svn: http://xxx:8082/svnadminsvnadmin: http://xxx:8082/sv
2017-12-30 19:00:10
3941
原创 Docker 安装jenkins
[root@iZuf6h59snssqyqa3ka87eZ ~]# docker search jenkinsINDEX NAME DESCRIPTION STARS OFFICIAL AUTOMAT
2017-12-27 18:49:20
1757
原创 Docker 安装mysql5.7
[root@iZuf6boi8ejfovwda7q1ynZ ~]# docker pull docker.io/mysqlUsing default tag: latestTrying to pull repository docker.io/library/mysql ... latest: Pulling from docker.io/library/mysqlf49cf87b
2017-12-27 00:35:14
8261
1
原创 Docker常用命令
镜像管理docker images：列出本地所有镜像docker search ：查找imagedocker pull ：下载imagedocker push ：上传imagedocker rmi ：删除image容器管理docker run -i -t /bin/bash：-i：标准输入给容器
2017-12-26 23:48:15
284
hadoop native
2014-08-03
openerp-7.0
2014-07-30
postgresql-9.1.14-1-1
2014-07-30
ImageMagick
2014-02-17
redmine-2.4.3
2014-02-14
subclipse-1.8.22
2013-09-04
hadoop-1.1.2 源代码
2013-07-03
hadoop-1.1.2.tar
2013-07-03
druid-0.2.20
2013-06-29
ActivePerl-5.6.1.635-MSWin32-x86.msi
2010-01-19
用Socket 打造跨语言跨操作系统的网络MORPG游戏
2008-08-03
FLEX+Delphi,FLEX+Java，FLEX+C# 的聊天室
2008-07-18
FLEX+Delphi,FLEX+Java 的聊天室
2008-07-18
中国诗词风
2006-03-16
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人