小韦's blog - 第8页共22页 - 小韦's blog

NGINX并发量优化

修改nginx进行配置客户端最大连接数优化，这个值默认为1024，这也是ab -c 2000 -n 2000 http://192.168.0.201/报错的原因。修改为65535，一个不可能达到的值。　修改系统限制…

2020年11月30日 0条评论 171次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql操作集合 json篇

一维数组查询方式: 二维数组查询方式: 查询json 搜索和修改JSON值

2020年11月23日 0条评论 124次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql操作集合连接篇

连接与查询登录创建一个储存过程, 入参

2020年11月23日 0条评论 114次阅读 1人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql操作集合内置函数

内置函数服务器字符集优化-慢查询密码丢失

2020年11月23日 0条评论 118次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql操作集合分区篇

创建分区

2020年11月23日 0条评论 178次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql操作集合 binlog篇

binlog 复制实现级别 Statement Level、Row Level、Mixed Level 记一次-表结构损坏出现不停重启的现像当mysqld服务进程访问损坏的表时，数据库会直接崩溃退出。通过:show g…

2020年11月23日 0条评论 167次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql操作集合常用篇

增删改查如果存在则更新，不存在则插入新数据批量更新一个表库

2020年11月23日 0条评论 130次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql 错误：Table is marked as crashed and should be repaired 解决办法

遇到这个问题敲几个命令轻松搞定

2020年11月22日 0条评论 139次阅读 0人点赞阅读全文

记一次谷歌浏览器 ERR_HTTP2_PROTOCOL_ERROR 错误处理总结

博主的情况如下：使用cloudflare的cdn功能，在tengine上是使用反向代理的，但问题就来了，在使用谷歌浏览器的情况下会出现ERR_HTTP2_PROTOCOL_ERROR ，但在使用火狐浏览器的情况下…

2020年11月21日 0条评论 624次阅读 1人点赞阅读全文

centos

服务器403,500,502,503，504等错误问题总结

403错误（禁止访问） 404错误（文件不存在） 500错误（执行错误） 502错误 (服务器无响应) 503错误（请求过于频繁） 504错误（等待超时）

2020年11月7日 0条评论 262次阅读 0人点赞阅读全文

«
<
6
7
8
9
10
>
»