<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[aiyi5316的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/aiyi5316</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; aiyi5316]]></copyright><item><title><![CDATA[nginx负载均衡转发https]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330956</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330956</guid><author>aiyi5316</author><pubDate>Mon, 23 Sep 2019 17:33:00 +0800</pubDate><description><![CDATA[A服务器做负载转发到 B，C两台服务器 ；
这时候要添加https域名，则以下是A服务器的nginx配置

upstream backend {    server ip;    server ip2;}

server {    listen 80;    listen 443 ssl;    server_name localhost;
#这个注释掉才能访问http...]]></description><category></category></item><item><title><![CDATA[redis-cli 客户端操作]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330961</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330961</guid><author>aiyi5316</author><pubDate>Wed, 11 Sep 2019 11:02:00 +0800</pubDate><description><![CDATA[进入redis-cli 客户端
1.Redis服务器的各种信息和统计数值
&gt;info [指定类型:keyspace]
memory内存使用量
Keyspace每个表对应的key数量

2.查看当前key的占用空间
&gt; debug objectkey名
返回值： Value at:0x7f088e621d80 refcount:1 encoding:...]]></description><category></category></item><item><title><![CDATA[ubuntu源码安装supervisor]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330954</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330954</guid><author>aiyi5316</author><pubDate>Tue, 27 Aug 2019 16:08:00 +0800</pubDate><description><![CDATA[百度上很多教程都是用apt-get install supervisor这种命令一键安装的，但是我的需求是下载一个源码包，然后拷贝到U盘里面，在拿到机房里面进行部署。（由于业务需要，机房是无法连通外网的 ，仅供局域网的机器使用）
好了，废话少说，撸起袖子干。
1.下载supervisor源码包
https://files.cnblogs.com/files/cyq63269...]]></description><category></category></item><item><title><![CDATA[docker address already in use]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330959</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330959</guid><author>aiyi5316</author><pubDate>Tue, 20 Aug 2019 10:14:00 +0800</pubDate><description><![CDATA[一般这种情况属于docker-compose.yml文件里面存在相同的ip地址，导致分配的ip已经被占用从而无法启动容器；

例子：我这边是mysql的一个容器无法启动，所抛出来的异常；
解决方案：
&gt;查看mysql在yml配置文件里对应的Ip地址 172.0.0.3，network是lnmp；
&gt; docker network inspect lnmp //...]]></description><category></category></item><item><title><![CDATA[运维管理笔记]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330952</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330952</guid><author>aiyi5316</author><pubDate>Wed, 14 Aug 2019 14:33:00 +0800</pubDate><description><![CDATA[1. &gt; strace -p pid //可以调试正在运行的进程状态
2.
&gt;ps aux|grep $进程名称
&gt; ps -eo pid,tty,user,comm,lstart,etime | grep $进程名称
参数说明：
pid：进程ID
tty：终端 user：
用户 comm：进程名
lstart：开始时间
etime：运行时间
...]]></description><category></category></item><item><title><![CDATA[Nginx报502 php-fpm重启问题]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330958</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330958</guid><author>aiyi5316</author><pubDate>Fri, 02 Aug 2019 11:46:00 +0800</pubDate><description><![CDATA[//linux系统 strace命令 常用来跟踪进程执行时的系统调用和所接收的信号
php-fpm经常无法正常运行，导致nginx会报502BadGateway网关错误，这个时候服务器重启下
service php7.1-fpm restart 
又可以继续使用了，问题跟踪↓↓↓↓↓↓↓↓
开始：
1.尝试下根据 strace -p {php-fpm进程号} 查看ph...]]></description><category></category></item><item><title><![CDATA[php根据二维数组排序]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330950</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330950</guid><author>aiyi5316</author><pubDate>Mon, 29 Jul 2019 15:45:00 +0800</pubDate><description><![CDATA[&lt;?php
$data = array(
  array(
    'id' =&gt; 5698,
    'first_name' =&gt; 'Bill',
    'last_name' =&gt; 'Gates',
  ),
  array(
    'id' =&gt; 4767,
    'first_name' =&gt; 'Steve',
  ...]]></description><category></category></item><item><title><![CDATA[关停所有匹配到的进程]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330957</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330957</guid><author>aiyi5316</author><pubDate>Thu, 25 Jul 2019 10:00:00 +0800</pubDate><description><![CDATA[kill -9 `ps -ef|grep '进程名称'| awk '{print $2}'  //这里的print $2 代表只输出进程Pid ，然后用``反引号括起来， kill -9 `里面的所有进程`





转载于:https://www.cnblogs.com/cyq632694540/p/11242434.html...]]></description><category></category></item><item><title><![CDATA[docker 安装ClickHouse 和 使用]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330949</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330949</guid><author>aiyi5316</author><pubDate>Mon, 17 Jun 2019 18:47:00 +0800</pubDate><description><![CDATA[下载docker clickhouse包
&gt; sudo docker pull yandex/clickhouse-client
&gt; sudo docker pull yandex/clickhouse-server

运行clickhouse-server容器
&gt; sudo docker run --network=lnmp_lnmp--ulimi...]]></description><category></category></item><item><title><![CDATA[内网服务器 docker部署Lnmp项目]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330899</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330899</guid><author>aiyi5316</author><pubDate>Fri, 17 May 2019 11:12:00 +0800</pubDate><description><![CDATA[常用命令
镜像的导出导入和命名；这一步导出可以保存tar文件，作为离网的环境安装docker-compose
docker save镜像id &gt;文件名.tar
docker load &lt;文件名.tar
docker tag镜像id镜像名称:tag
---docker run -it --network lnmp_lnmp --rm容器id mysq...]]></description><category></category></item><item><title><![CDATA[golang 安装tensorflow]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330948</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330948</guid><author>aiyi5316</author><pubDate>Mon, 22 Apr 2019 15:57:00 +0800</pubDate><description><![CDATA[TF_TYPE="cpu" # Change to "gpu" for GPU support //设置环境变量

TARGET_DIRECTORY='/usr/local'//设置环境变量

wgethttps://storage.googleapis.com/tensorflow/libtensorflow/libtensorflow-${TF_TYPE}-$(go ...]]></description><category></category></item><item><title><![CDATA[docker-compose使用]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330955</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330955</guid><author>aiyi5316</author><pubDate>Wed, 10 Apr 2019 12:08:00 +0800</pubDate><description><![CDATA[1.创建app.py项目文件，执行以下代码
import time

import redis
from flask import Flask


app = Flask(__name__)
cache = redis.Redis(host='redis', port=6379)


def get_hit_count():
    retries = 5...]]></description><category></category></item><item><title><![CDATA[ubuntu16.04安装Navicate]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330946</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330946</guid><author>aiyi5316</author><pubDate>Tue, 09 Apr 2019 15:07:00 +0800</pubDate><description><![CDATA[1. http://download2.navicat.com/download/navicat100_mysql_en.tar.gz
2. tar -zxvf /home/rain/download/navicat8_mysql_en.tar.gz
3../start_navicat


连接上数据库后里面的中文数据是乱码,把Ubuntu的字符集修改...]]></description><category></category></item><item><title><![CDATA[docker mysql 主主同步]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330953</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330953</guid><author>aiyi5316</author><pubDate>Tue, 26 Mar 2019 10:08:00 +0800</pubDate><description><![CDATA[转发自：https://blog.youkuaiyun.com/money9sun/article/details/85099134

第一步：安装docker https://www.cnblogs.com/cyq632694540/p/10596276.html

第二步：检查mysql的镜像，并下载
# docker search mysql:5.7
# docker pu...]]></description><category></category></item><item><title><![CDATA[MySQL索引原理以及查询优化]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330951</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330951</guid><author>aiyi5316</author><pubDate>Wed, 20 Feb 2019 16:28:00 +0800</pubDate><description><![CDATA[转载自：https://www.cnblogs.com/bypp/p/7755307.html
MySQL索引原理以及查询优化

一、介绍
1.什么是索引？
一般的应用系统，读写比例在10:1左右，而且插入操作和一般的更新操作很少出现性能问题，在生产环境中，我们遇到最多的，也是最容易出问题的，还是一些复杂的查询操作，因此对查询语句的优化显然是重中之重。说起加速查询，就不得不提到...]]></description><category></category></item><item><title><![CDATA[七牛存储qshell工具]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330947</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330947</guid><author>aiyi5316</author><pubDate>Mon, 07 Jan 2019 11:13:00 +0800</pubDate><description><![CDATA[---恢复内容开始---
工具地址：https://developer.qiniu.com/kodo/tools/1302/qshell
下载完成后：根据自己的系统选择需要的可执行文件，支持linux,windows,mac
拿我的系统为例(Win10 x64位)

1.解压需要的可执行文件，重命名为qshell.exe

2.配置环境变量
3.然后就可以开始使用qsh...]]></description><category></category></item><item><title><![CDATA[golang学习笔记]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330896</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330896</guid><author>aiyi5316</author><pubDate>Sun, 28 Oct 2018 22:38:00 +0800</pubDate><description><![CDATA[1.Golang协程
https://studygolang.com/articles/14384

转载于:https://www.cnblogs.com/cyq632694540/p/9867736.html]]></description><category></category></item><item><title><![CDATA[Mysql 函数]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330900</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330900</guid><author>aiyi5316</author><pubDate>Wed, 26 Sep 2018 20:50:00 +0800</pubDate><description><![CDATA[select UNIX_TIMESTAMP("1990-09-01 00:00:00");//转换为时间戳格式select FROM_UNIXTIME(652114800,"%Y-%m-%d %H:%i:%s");//时间戳格式化为时间格式 yyyy-mm-dd hh:mm:ss

转载于:https://www.cnblogs.com/cyq632694540/p/9709596.h...]]></description><category></category></item><item><title><![CDATA[phpstudy 配置端口 和 虚拟域名访问]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330895</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330895</guid><author>aiyi5316</author><pubDate>Wed, 26 Sep 2018 20:34:00 +0800</pubDate><description><![CDATA[打开phpstudy窗口
选择-&gt;其他选项菜单-&gt;打开配置文件-&gt;httpd.conf添加一个 Listen 8081(端口号)
查看到  Include conf/vhosts.conf （这里的意思是包含其他配置文件信息）
选择-&gt;其他选项菜单-&gt;打开配置文件-&gt;vhost.conf添加多一个以8081端口的项目

&lt;V...]]></description><category></category></item><item><title><![CDATA[Mysql 提升大数据表的拷贝效率]]></title><link>https://blog.youkuaiyun.com/aiyi5316/article/details/101330944</link><guid>https://blog.youkuaiyun.com/aiyi5316/article/details/101330944</guid><author>aiyi5316</author><pubDate>Tue, 11 Sep 2018 11:50:00 +0800</pubDate><description><![CDATA[工作上会经常遇到量级比较大的数据表 ；场景: 该数据表需要进行alter操作 比如增加一个字段,减少一个字段. 这个在一个几万级别数据量的数据表可以直接进行alter表操作,但是要在一个接近1000W的数据表进行操作,不是一件容易的事；可能情况:1.导致数据库崩溃或者卡死 2.导致其他进程 进行数据库读写I/O变慢 3.还有一个可能就是数据格式不一致 导致数据无法写入(比如...]]></description><category></category></item></channel></rss>