echo |openssl s_client -connect ***.****.com:443 2>&1 |sed -ne ‘/-BEGIN CERTIFICATE-/,/-END CERTIFICATE-/p’
配置mysql参数使数据库表字段支持存储表情符号
2018-09-15 by Jinyang | 2 Comments | Filed in Other看了下基本这篇写的已经够完整了,虽然不是安装这篇做的,也还是不重复写了。-> : http://blog.51cto.com/312461613/1718999
1 解决方案:将Mysql的编码从utf8转换成utf8mb4。
需要 >= MySQL 5.5.3版本、从库也必须是5.5的了、低版本不支持这个字符集、复制报错
2 my.cnf 文件添加
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect=’SET NAMES utf8mb4′
3修改需要添加库 表 字段的字符集
修改数据库字符集:
ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
修改表的字符集:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
修改字段的字符集:
ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
如果只是某个字段需要 只需要修改那个字段的字符集就可以了
4 如果修改以上都不行请查询sql
mysql> show variables like ‘%sql_mode%’;
+—————+——————————————–+
| Variable_name | Value |
+—————+——————————————–+
| sql_mode | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+—————+——————————————–+
1 row in set (0.00 sec)
如果是以上结果恭喜你是存储不了的
去设置这个sql_mod 模式(注意这里修改看之后要退出控制台要不然还是看不到效果的,而
且这个配置写my.cnf 重启服务器是不生效的,如果要问为什么请去mysql顾问群)
mysql> set global sql_mode = ‘NO_ENGINE_SUBSTITUTION’;
mysql> show variables like ‘%sql_mode%’;
+—————+————————+
| Variable_name | Value |
+—————+————————+
| sql_mode | NO_ENGINE_SUBSTITUTION |
+—————+————————+
1 row in set (0.00 sec)
6 做完这些就完成了
windows平台的web压力测试小工具
2018-09-06 by Jinyang | No Comments | Filed in 技术相关http_load -p 10 -s 60 -r 3 -f 100 c:\urls.txt
参数的含义:
-parallel 简写-p :并发的用户进程数
-fetches 简写-f :总计的访问请求次数
-rate 简写-r :每秒的访问频率
-seconds简写-s :总计的访问时间
准备URL文件:urls.txt,文件格式是每行一个URL
排除DeadlockLoserDataAccessException异常
2018-09-05 by Jinyang | No Comments | Filed in 技术相关某高并发场景的应用使用数据库的insert select 方式做了业务的逻辑判断限制,以实现预期的数据控制(不超出业务允许的范围),实际使用中的确是不会出现绕过业务规则的业务发生,但是正常的请求因为并发锁表导致相互等待 死锁 使得业务无法正常进行。
1. 分析sql语句 使所有sql子查询语句都走唯一索引、索引等 不要全表扫描导致产生表级别的锁
执行explain sql语句 ,把ALL类型的全表扫描的执行sql都优化成走索引执行
2. 降低事务等级为 ISOLATION_READ_COMMITTED ,缩小事务 及时commit
READ_COMMITTED 不会锁表,是Oracle的默认事务等级,MySql默认使用的REPEATABLE READ ,READ UNCOMMITTED更快 更不易锁表。
3. 分解service impl中的方法中作为整体事务的容易出错的代码,单独进行异常的捕获,防止其出现IP错误等导致数据库回滚
4. 其他业务语句涉及到同一张表的 要使用索引 避免全表扫描的update 。
小计一次调优
2018-08-20 by Jinyang | 1 Comment | Filed in 技术相关系统的ulimit 参数调整
Nginx的open file参数调整: worker_rlimit_nofile (理论上的最大并发连接: max_clients = worker_processes * worker_connections)
多节点 IPHASH 权重
Jboss sessionid生成机制和Redis键值冲突的bug修复
Jboss 内存扩大
Jboss 并发数提高
业务(程序)并发点从数据库迁移至redis
使用redis的原子计数器来实现一个高效、高并发安全的计数策略(类似数据库的sequence)
共享存储,从无到SAN再到NAS
SAN存在并发读写时存在异常的问题,会引发web容器启动时文件扫描错误(直接把静态的、需要共享的文件夹从war代码包里剥离出去是一个更好的办法,让jboss启动的更快)
NAS需要在NAS管理端界面配置好客户端的访问IP才可以正常挂载
全部静态文件移交给Nginx
把所有静态文件目录的解析全部直接由nginx完成,程序在初期就规划好所有的静态文件在一个static目录下
Nginx 5** 错误页面定制
error_page 500 502 503 504 /500.html;
location = /500.html {
root /文件目录;
internal;
}为了降低服务器压力,错误页面使用的图片直接用了新浪微博的图床。
结论:
应该支持上万人的秒杀不会卡顿了,实际观察后再补充。
Cunchao.com Bid History(7 Bidders:, 26 Bids)
2018-08-17 by Jinyang | No Comments | Filed in 域名| Bidder | Bid | Date | Time |
|---|---|---|---|
| first1
High Bid
|
$304.00 | Aug 16 | 12:52:55 |
| ckrgksanrndghk | $284.00 | Aug 16 | 12:52:40 |
| first1 | $264.00 | Aug 16 | 12:22:54 |
| Alibackorders | $244.00 | Aug 16 | 12:22:30 |
| first1 | $224.00 | Aug 16 | 12:19:53 |
| Alibackorders | $204.00 | Aug 16 | 12:19:50 |
| first1 | $194.00 | Aug 16 | 12:14:54 |
| nameword | $184.00 | Aug 16 | 12:14:26 |
| first1 | $174.00 | Aug 16 | 11:59:24 |
| nameword | $164.00 | Aug 16 | 08:58:21 |
| first1 | $154.00 | Aug 16 | 07:19:06 |
| Alibackorders
P
|
$150.00 | Aug 16 | 07:19:06 |
| Alibackorders
P
|
$144.00 | Aug 16 | 07:16:42 |
| first1 | $134.00 | Aug 16 | 07:16:42 |
| Alibackorders
P
|
$124.00 | Aug 16 | 07:07:48 |
| first1 | $114.00 | Aug 16 | 07:07:48 |
| Alibackorders | $104.00 | Aug 15 | 23:52:02 |
| DefendOr6
P
|
$99.00 | Aug 15 | 23:52:03 |
| DefendOr6 | $74.00 | Aug 15 | 21:40:45 |
| bosskk | $69.00 | Aug 15 | 15:02:46 |
| first1 | $64.00 | Aug 14 | 04:08:54 |
| Alibackorders | $59.00 | Aug 13 | 12:49:31 |
| first1 | $59.00 | Aug 13 | 12:49:31 |
| jiuzhe | $59.00 | Aug 13 | 12:49:31 |
| nameword | $59.00 | Aug 13 | 12:49:31 |
| DefendOr6 | $59.00 | Aug 13 | 12:49:31 |
telnet 到 redis 6379 后退出
2018-08-16 by Jinyang | No Comments | Filed in 技术相关1. 输入 ctrl+]
2. 输入 quit
即可
Shoula.com Bid History(26 Bidders:, 86 Bids)
2018-08-15 by Jinyang | No Comments | Filed in 技术相关| Bidder | Bid | Date | Time |
|---|---|---|---|
| CNname
High Bid
P
|
$2,464.00 | Aug 13 | 11:24:53 |
| Doomain | $2,414.00 | Aug 13 | 11:24:53 |
| CNname
P
|
$2,351.00 | Aug 13 | 11:23:25 |
| Doomain | $2,301.00 | Aug 13 | 11:23:25 |
| CNname
P
|
$2,251.00 | Aug 13 | 11:23:11 |
| Doomain | $2,201.00 | Aug 13 | 11:23:11 |
| CNname
P
|
$2,151.00 | Aug 13 | 11:23:04 |
| Doomain | $2,101.00 | Aug 13 | 11:23:04 |
| CNname | $2,051.00 | Aug 13 | 11:12:24 |
| pengge | $2,001.00 | Aug 13 | 05:52:47 |
| CNname
P
|
$2,000.00 | Aug 13 | 05:52:47 |
| CNname
P
|
$1,901.00 | Aug 13 | 05:52:38 |
| pengge | $1,851.00 | Aug 13 | 05:52:38 |
| CNname
P
|
$1,801.00 | Aug 13 | 05:52:31 |
| pengge | $1,751.00 | Aug 13 | 05:52:31 |
| CNname
P
|
$1,551.00 | Aug 13 | 05:52:05 |
| pengge | $1,501.00 | Aug 13 | 05:52:05 |
| CNname
P
|
$1,451.00 | Aug 13 | 05:51:57 |
| pengge | $1,401.00 | Aug 13 | 05:51:57 |
| CNname
P
|
$1,351.00 | Aug 13 | 03:57:01 |
| Doomain | $1,301.00 | Aug 13 | 03:57:01 |
| CNname
P
|
$1,251.00 | Aug 12 | 22:12:13 |
| Doomain | $1,201.00 | Aug 12 | 22:12:13 |
| CNname | $1,151.00 | Aug 12 | 20:50:22 |
| pengge | $1,101.00 | Aug 12 | 17:27:31 |
| CNname
P
|
$1,052.00 | Aug 12 | 17:27:31 |
| CNname | $1,051.00 | Aug 12 | 08:36:30 |
| pengge | $1,001.00 | Aug 12 | 07:14:42 |
| CNname
P
|
$1,000.00 | Aug 12 | 07:14:42 |
| CNname
P
|
$850.00 | Aug 12 | 07:14:14 |
| pengge | $800.00 | Aug 12 | 07:14:14 |
| CNname
P
|
$750.00 | Aug 12 | 07:13:34 |
| pengge | $700.00 | Aug 12 | 07:13:34 |
| CNname
P
|
$650.00 | Aug 12 | 07:10:14 |
| pengge | $600.00 | Aug 12 | 07:10:14 |
| CNname | $550.00 | Aug 12 | 06:40:22 |
| pengge
P
|
$500.00 | Aug 12 | 06:40:22 |
| pengge
P
|
$421.00 | Aug 12 | 06:40:14 |
| CNname | $401.00 | Aug 12 | 06:40:14 |
| pengge | $381.00 | Aug 12 | 06:19:56 |
| wisely
P
|
$361.00 | Aug 12 | 06:19:57 |
| wisely
P
|
$264.00 | Aug 12 | 06:19:06 |
| pengge | $244.00 | Aug 12 | 06:19:06 |
| wisely
P
|
$224.00 | Aug 12 | 03:50:35 |
| Doomain | $204.00 | Aug 12 | 03:50:35 |
| wisely
P
|
$194.00 | Aug 11 | 10:34:13 |
| Affiliate | $184.00 | Aug 11 | 10:34:13 |
| wisely
P
|
$174.00 | Aug 11 | 10:34:08 |
| Affiliate | $164.00 | Aug 11 | 10:34:08 |
| wisely
P
|
$154.00 | Aug 11 | 10:34:03 |
| Affiliate | $144.00 | Aug 11 | 10:34:03 |
| wisely
P
|
$134.00 | Aug 11 | 10:33:55 |
| Affiliate | $124.00 | Aug 11 | 10:33:55 |
| wisely
P
|
$114.00 | Aug 11 | 10:33:19 |
| Affiliate | $104.00 | Aug 11 | 10:33:19 |
| wisely
P
|
$99.00 | Aug 11 | 10:33:13 |
| Affiliate | $94.00 | Aug 11 | 10:33:13 |
| wisely
P
|
$89.00 | Aug 11 | 10:27:13 |
| Affiliate | $84.00 | Aug 11 | 10:27:13 |
| wisely | $79.00 | Aug 11 | 04:00:48 |
| hubaba | $74.00 | Aug 11 | 02:31:48 |
| bosskk | $69.00 | Aug 10 | 14:38:50 |
| luxtea | $64.00 | Aug 10 | 11:35:39 |
| Alibackorders | $59.00 | Aug 10 | 09:04:10 |
| wisely | $59.00 | Aug 10 | 09:04:10 |
| plOms8 | $59.00 | Aug 10 | 09:04:10 |
| WithoutAlias | $59.00 | Aug 10 | 09:04:10 |
| jiuzhe | $59.00 | Aug 10 | 09:04:10 |
| Doomain | $59.00 | Aug 10 | 09:04:10 |
| first1 | $59.00 | Aug 10 | 09:04:10 |
| szdomains | $59.00 | Aug 10 | 09:04:10 |
| Sherrys | $59.00 | Aug 10 | 09:04:10 |
| yijiebackorder | $59.00 | Aug 10 | 09:04:10 |
| nameword | $59.00 | Aug 10 | 09:04:10 |
| mikucn | $59.00 | Aug 10 | 09:04:10 |
| DefendOr6 | $59.00 | Aug 10 | 09:04:10 |
| Jokers | $59.00 | Aug 10 | 09:04:10 |
| somealias | $59.00 | Aug 10 | 09:04:10 |
| ckrgksanrndghk | $59.00 | Aug 10 | 09:04:10 |
| wnnrscrs | $59.00 | Aug 10 | 09:04:10 |
| hubaba | $59.00 | Aug 10 | 09:04:10 |
| everfirst | $59.00 | Aug 10 | 09:04:10 |
| lueecer | $59.00 | Aug 10 | 09:04:10 |
| Affiliate | $59.00 | Aug 10 | 09:04:10 |
| junqingfu | $59.00 | Aug 10 | 09:04:10 |
| CNname | $59.00 | Aug 10 | 09:04:10 |
Nginx转发请求时重置url
2018-08-13 by Jinyang | No Comments | Filed in 技术相关真实服务器 A上的项目端口在 nnnn ,Nginx 请 【域名/项目名】 的路径转发到后端的tomcat。
但是项目实际是没有项目名的 直接在/ 下运行的,因为直接转发过去就会报错
调整nginx配置,完美的支持需求:
location /项目名 {
return 302 /项目名/;
}
location /项目名/ {
add_header Via “项目名_testserver” always;
proxy_set_header Host $Host;
proxy_set_header X_Real_Ip $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
#proxy_redirect /项目名/ /;
proxy_pass http://网址:端口/;
}
重点在于 proxy_pass http://网址:端口/; 的最后的一个斜杠,这个是严格匹配的,所以可以转成任何需要的路径 。
svn保留变更记录迁移到git
2018-08-12 by Jinyang | No Comments | Filed in 技术相关git svn clone -A user.txt https://jsly.haojiawu.com:18443/svn/mobile/trunk/mobile/trunk njzone
git remote add origin http://vcs.eboa.cn:666/lijy/njzone.git
git push -u origin master
hg转移更方便: hg push git+http://vcs.eboa.cn:666/lijy/nczone.git
