<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[willjay01的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/willjay01</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; willjay01]]></copyright><item><title><![CDATA[influxdb连续查询]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/124194900</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/124194900</guid><author>willjay01</author><pubDate>Fri, 15 Apr 2022 15:45:35 +0800</pubDate><description><![CDATA[项目场景：
InfluxDB是一个由InfluxData开发的开源时序型数据。它由Go写成，着力于高性能地查询与存储时序型数据。InfluxDB被广泛应用于存储系统的监控数据，IoT行业的实时数据等场景。

问题描述
使用influxdb做数据统计，运行一段时间之后，发现页面查询缓慢。

原因分析：
经查询发现数据存储量很大，在做聚合查询时缓慢会导致查询失败。

解决方案：
计划使用influxdb的连续查询功能，将需要聚合的数据定时聚合统计，查询数据时，直接查询聚合后的数据
官方文档：https://do]]></description><category></category></item><item><title><![CDATA[go使用记录]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/108849831</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/108849831</guid><author>willjay01</author><pubDate>Mon, 28 Sep 2020 17:07:18 +0800</pubDate><description><![CDATA[1、``反撇号 将字符串原样输出
2、%v万能占位符
3、’'字符 "“字符串
4、时间格式化必须使用时间"2006-01-02 15:04:05”
https://www.jianshu.com/p/c7f7fbb16932
5、fallthrough  穿透到下一个case语句

]]></description><category></category></item><item><title><![CDATA[php使用问题记录]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/108726409</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/108726409</guid><author>willjay01</author><pubDate>Tue, 22 Sep 2020 10:59:30 +0800</pubDate><description><![CDATA[一、获取毫秒时间戳
            list($msec, $sec) = explode(' ', microtime());
            $time = (float)sprintf('%.0f', (floatval($msec) + floatval($sec)) * 1000);

之前有使用过
            $time       = explode ( " ", microtime () );
            $time       = $time[1] ]]></description><category></category></item><item><title><![CDATA[编译安装FFMPEG]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/108626644</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/108626644</guid><author>willjay01</author><pubDate>Wed, 16 Sep 2020 17:46:51 +0800</pubDate><description><![CDATA[编译安装过程参考：
https://trac.ffmpeg.org/wiki/CompilationGuide/Centos
遇到问题：
一、
错误：“ERROR: opus not found using pkg-config”
解决：
运行
pkg-config --list-all

如果未查看到所需依赖包，运行如下命令后重新尝试
PKG_CONFIG_PATH="$HOME/ffmpeg_build/lib/pkgconfig"
export PKG_CONFIG_PATH=/usr/local/l]]></description><category></category></item><item><title><![CDATA[influxdb 使用总结]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/107469333</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/107469333</guid><author>willjay01</author><pubDate>Wed, 29 Jul 2020 16:40:56 +0800</pubDate><description><![CDATA[1、对于在WHERE子句中的tag values或string类型的field values，要用单引号括起来。如果不用引号括起来，或者使用双引号，则查询不会返回任务数据。甚至不会报错。
2、DELETE语句不能使用limit
3、name为保留名，因此需要用双引号括起来

...]]></description><category></category></item><item><title><![CDATA[Go：解决数据库中null值的问题]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/106053646</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/106053646</guid><author>willjay01</author><pubDate>Mon, 11 May 2020 14:39:46 +0800</pubDate><description><![CDATA[遇到问题：
converting NULL to string is unsupported
定义的结构体中 结构体成员类型为string，从mysql数据库中查询数据中有NULL值，go语言执行scan操作时不能转换。
查询有两种方法解决
1、定义类型为sql.NullString
共有如下类型 sql.NullString  sql.NullBool  sql.NullFloat64 sql.NullInt32 sql.NullInt64 sql.NullTime
2、使用IFNULL() 或者 COA]]></description><category></category></item><item><title><![CDATA[Golang关于MySQL 时区问题]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/105972484</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/105972484</guid><author>willjay01</author><pubDate>Thu, 07 May 2020 14:48:06 +0800</pubDate><description><![CDATA[参考:https://www.jianshu.com/p/030b880ecc5e
https://github.com/go-sql-driver/mysql
想要把 time.Time 直接存储入库，需要开启解析时间parseTime
db, err := sql.Open("mysql", "user:password@/dbname?charset=utf8mb4&amp;parseTim...]]></description><category></category></item><item><title><![CDATA[VUE项目基础-安装]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/105730498</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/105730498</guid><author>willjay01</author><pubDate>Fri, 24 Apr 2020 14:35:33 +0800</pubDate><description><![CDATA[安装
首先要安装node.js  npm
下载地址：http://nodejs.cn/download/
或
apt-get install nodejs    /  yum install -y  nodejs
选择官网版本会比较新  npm包含在node的安装包中
//设置淘宝npm镜像
npm install -g cnpm --registry=https://registry.npm.t...]]></description><category></category></item><item><title><![CDATA[drone使用之配置通知]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/103436781</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/103436781</guid><author>willjay01</author><pubDate>Thu, 05 Dec 2019 18:02:44 +0800</pubDate><description><![CDATA[一、配置邮件报警
steps:
  ......
  - name: notify
    image: drillster/drone-email
    settings:
      host: SMTPserver      //例如 smtp.qq.com  
      port: SMTPserverport   //例如QQ邮箱端口465
      username: xxxxx...]]></description><category></category></item><item><title><![CDATA[drone使用之配置Secrets]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/103313211</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/103313211</guid><author>willjay01</author><pubDate>Thu, 28 Nov 2019 14:48:49 +0800</pubDate><description><![CDATA[Repository secrets用于存储密码、秘钥、令牌等机密信息。在仓库的setting界面可以配置repository secrets
使用方式：
kind: pipeline
name: default

steps:
- name: build
  image: alpine
  environment:
    USERNAME:
      from_secret: docker_...]]></description><category></category></item><item><title><![CDATA[基于gitlab的drone的搭建和使用]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/103295730</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/103295730</guid><author>willjay01</author><pubDate>Wed, 27 Nov 2019 10:35:09 +0800</pubDate><description><![CDATA[环境：CentOS Linux release 7.6.1810gitlab服务地址：192.168.25.135drone服务地址：192.168.25.132在192.168.25.135部署gitlab服务：1、安装依赖
sudo yum install -y curl policycoreutils-python openssh-server
sudo systemctl enable s...]]></description><category></category></item><item><title><![CDATA[windows下修改文件时的换行符引起在linux运行不正常的解决]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/103240397</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/103240397</guid><author>willjay01</author><pubDate>Wed, 20 Nov 2019 12:12:45 +0800</pubDate><description><![CDATA[windows和linux下的换行符是不同的。一般操作系统上的运行库会自动决定文本文件的换行格式. 如一个程序在windows上运行就生成CR/LF换行格式的文本文件，而在linux上运行就生成LF格式换行的文本文件. 在一个平台上使用另一种换行符的文件文件可能会带来意想不到的问题, 特别是在编辑程序代码时. 有时候代码在编辑器中显示正常, 但在编辑时却会因为换行符问题而出错. 很多文本/代码编辑...]]></description><category></category></item><item><title><![CDATA[websocket简单了解]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/103154025</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/103154025</guid><author>willjay01</author><pubDate>Tue, 19 Nov 2019 15:15:39 +0800</pubDate><description><![CDATA[websocket是html5规范中的一个部分，它借鉴了socket这种思想，为web应用程序客户端和服务端之间（注意是客户端服务端）提供了一种全双工通信机制。同时，它又是一种新的应用层协议，websocket协议是为了提供web应用程序和服务端全双工通信而专门制定的一种应用层协议，通常它表示为：ws://echo.websocket.org/?encoding=text HTTP/1.1，可以看...]]></description><category></category></item><item><title><![CDATA[GO学习相关]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/103154023</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/103154023</guid><author>willjay01</author><pubDate>Tue, 19 Nov 2019 14:18:05 +0800</pubDate><description><![CDATA[GO标准库文档：https://studygolang.com/pkgdocGO基础知识：http://zengzhihai.com/study/wiki/type/Z29fc3R1ZHlfaW5mbw==/id/59b2b68aa55d5081678b456c
C语言中文网：http://c.biancheng.net/golang/
GO语言中文网： https://studygolang.c...]]></description><category></category></item><item><title><![CDATA[session_start() failed]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/103154019</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/103154019</guid><author>willjay01</author><pubDate>Tue, 19 Nov 2019 14:13:25 +0800</pubDate><description><![CDATA[初次接触php，在用memcache缓存session时出现session_start() failed，经过查询资料发现，php在使用memcache和memcached扩展的方式不同。当使用memcache保存session时：define('_SESSION_PATH', 'tcp://127.0.0.1:11213');define('_SESSION_HANDLER', 'memcach...]]></description><category></category></item><item><title><![CDATA[mysql导出数据到文件权限问题]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/103041032</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/103041032</guid><author>willjay01</author><pubDate>Tue, 12 Nov 2019 14:24:09 +0800</pubDate><description><![CDATA[问题：mysql&gt; select * from products into outfile "/dbbak/outfile.txt" Fields terminated by "|" Lines terminated by "\n";ERROR 1 (HY000): Can't create/write to file '/dbbak/outfile.txt...]]></description><category></category></item><item><title><![CDATA[GO相关-变量]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/103041031</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/103041031</guid><author>willjay01</author><pubDate>Tue, 12 Nov 2019 13:49:32 +0800</pubDate><description><![CDATA[声明变量：声明变量的一般形式是使用 var 关键字：var name type
Go语言的基本类型(type)有：boolstringint、int8、int16、int32、int64uint、uint8、uint16、uint32、uint64、uintptrbyte // uint8 的别名rune // int32 的别名 代表一个 Unicode 码float32、float64comp...]]></description><category></category></item><item><title><![CDATA[VMware设置共享物理机文件夹]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/94454211</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/94454211</guid><author>willjay01</author><pubDate>Tue, 02 Jul 2019 17:04:55 +0800</pubDate><description><![CDATA[VMware设置共享物理机上文件夹需求：安装VMware Tools:配置linux系统:
需求：
使用VMware搭建了一套lnmp环境，想在windows物理机上开发，同时应用到虚拟机环境中，因此想到将windows物理机上的项目文件夹共享到虚拟机中的网站根目录，开发时做修改直接就能生效。
安装VMware Tools:
VMware共享文件夹的功能是基于VMware Tools实现的，所以需...]]></description><category></category></item><item><title><![CDATA[删除目录及其所有子目录下的空文件和过期文件]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/118549348</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/118549348</guid><author>willjay01</author><pubDate>Mon, 21 Jan 2019 15:33:18 +0800</pubDate><description><![CDATA[```
#!/bin/sh
dir="/mnt/lelink/movies/data"
date=`date '-d 1days' +%Y%m%d`
cd $dir || exit
function isdir(){
	local lsdir=$1
	for list in `ls $lsdir`
	do	
		if [ -d $lsdir/$list ];then
			count=`ls $l...]]></description><category></category></item><item><title><![CDATA[生成随机字符串]]></title><link>https://blog.youkuaiyun.com/willjay01/article/details/118549337</link><guid>https://blog.youkuaiyun.com/willjay01/article/details/118549337</guid><author>willjay01</author><pubDate>Thu, 27 Dec 2018 17:42:51 +0800</pubDate><description><![CDATA[## **生成随机字符串**




-----



-----

### ***php：***
```
#!/usr/bin/php
]]></description><category></category></item></channel></rss>