my.cnf 配置优化
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778collation-server=utf8mb4_unicode_cicharacter-set-server=utf8mb4 # 字符集datadir=/var/lib/mysql # MySQL安装位置socket=/var/lib/mysql/mysql.sock # MySQL通讯协议文件位置,本地连接使用# 是否支持符号链接,即数据库或表可以存储在my.cnf中指定datadir之外的分区或目录,为0不开启。# 禁用symbolic-links选项、服务配置,禁用符号链接以防止各种安全风险symbolic-links=0 pid-file=/var/run/mysqld/mysqld.pid # MySQL进程位置# 网络设置 max_connections=200 # 最大连接 ...
print输出进度条
12345678910111213141516import time# 示例数组,你可以替换为实际的数组data_array = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]num = len(data_array)bar_length = 20 # 设定进度条总长度,可根据喜好调整for index, element in enumerate(data_array): i = index + 1 timeflush = 2 # 每处理2个元素刷新一次进度条,可按需调整 if i % timeflush == 0 or i == num: progress_percent = int(i / num * 100) filled_length = int(bar_length * (progress_percent / 100)) bar = "|" + "-" * filled_length + " " * (bar_length - fille ...
原生JS实现聊天窗口
弹窗页面的样式
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147<!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <meta name="viewport" content="wid ...
定时刷新图表
12345678910111213141516171819202122232425262728// 自动刷新$(document).ready(function () { let intervalId = null let intervalValue = parseInt($("#time").val() * 1000, 10); setNewInterval(intervalValue); function setNewInterval(intervalValue) { if (intervalId) { clearInterval(intervalId) } if (!isNaN(intervalValue) && intervalValue > 0) { intervalId = setInterval(function () { flashDashboardChart(); console.log(&qu ...
常用的镜像地址
npm
1npm config set registry https://registry.npmmirror.com
nvm
12node_mirror: https://npmmirror.com/mirrors/node/npm_mirror: https://npmmirror.com/mirrors/npm/
python
1pip install -i https://pypi.tuna.tsinghua.edu.cn/simple some-package
kali
1234567891011121314151617181920中科大 deb http://mirrors.ustc.edu.cn/kali kali-rolling main non-free contrib deb-src http://mirrors.ustc.edu.cn/kali kali-rolling main non-free contrib 阿里云 deb http://mirrors.aliyun.com/kali kali-rolling main non-free cont ...
最详细的MySQL部署
rpm安装MySQL先下载所需的包分别下载 MySQL5.7的common 、libs、client、server4个RPM包:
1234567wget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-community-common-5.7.33-1.el6.x86_64.rpmwget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-community-libs-5.7.33-1.el6.x86_64.rpmwget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-community-client-5.7.33-1.el6.x86_64.rpmwget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-community-server-5.7.33-1.el6.x86_64.rpm
安装4个 ...
监测本地storage的数值变化
123456window.addEventListener('storage', function(event) { if (event.key === 'curServer') { // 检查是否是关心的键发生了变化 console.log('localStorage key "curServer" changed to:', event.newValue); table.reload('var-table',{url: MODULE_PATH + '/'+ window.localStorage.getItem("curServer") +'/globalVariables'}) }});
同时在table.reload里面添加url可以刷新,因为table里面的url渲染之后就是固定的了,如果有变化需要重新赋值
给已经打好的jar包添加依赖jar包重新打包
可以这么操作
使用压缩软件,解压平台提供的yaay-app-user.jar,解压后的目录格式如下:
yaay-app-user
…BOOT-INF*
…META-INF*
…org*
在yaay-app-user\BOOT-INF\lib目录中添加mysql驱动
进入yaay-app-user目录,执行如下命令:
jar cvfm0 yaay-app-user.jar .\META-INF\MANIFEST.MF *
原文链接:https://blog.csdn.net/itwxming/article/details/104478226
获取汉字拼音首字母
添加所需的依赖
12345<dependency> <groupId>com.belerweb</groupId> <artifactId>pinyin4j</artifactId> <version>2.5.1</version></dependency>
创建一个方法来,转换拼音
1234567891011121314151617181920public static String getPinYinHeadChar(String str) { if (isNull(str)) { return ""; } String convert = ""; for (int j = 0; j < str.length(); j++) { char word = str.charAt(j); // 提取汉字的首字母 ...
MySQL字节超长
报错信息如下:
1234ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
报错的信息很简单,就是创建表的时候,所有字段的字节长度加起来超过了65535
解决的办法就是:将长的字段格式改成longtext 或者是 longblob
这两个类型的区别是:如果存放二进制文件就用longblob,如果存放长文本,就用longtext
到这里基本能解决了
!!!如果还是爆超长,则需要查看数据库的字符集类型需要注意一下字符集:
utf8与utf8mb4区别
utf8 使用1~4个字节,一种变长的编码格式,字符编码。utf8mb4 即most bytes 4,使用4个字节来表示完整的UTF-8
结论:如果数据库的字符 ...