<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[abs9668的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/abs9668</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; abs9668]]></copyright><item><title><![CDATA[git创建与合并分支]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075164</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075164</guid><author>abs9668</author><pubDate>Sun, 26 Nov 2017 18:26:00 +0800</pubDate><description><![CDATA[首先，我们创建dev分支，然后切换到dev分支：
$ git checkout -b dev
Switched to a new branch 'dev'
git checkout命令加上-b参数表示创建并切换，相当于以下两条命令：
$ git branch dev
$ git checkout dev
Switched to branch 'dev'
然后，用git ...]]></description><category></category></item><item><title><![CDATA[把CentOS启动进度条替换为详细信息]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075167</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075167</guid><author>abs9668</author><pubDate>Fri, 18 Aug 2017 14:23:00 +0800</pubDate><description><![CDATA[CentOS 6 启动的时候，是一个进度条。
 
打开 /boot/grub/grub.conf，搜索找到rhgb这个关键词，把它去掉即可。加上它后，就会显示进度条。
rhgb 是 "redhat graphics boot" 的缩写。
另外如果有quiet，也需要把这个删除掉。




转载于:https://www.cnblogs.com/qingchen-2...]]></description><category></category></item><item><title><![CDATA[mysql双1设置]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075165</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075165</guid><author>abs9668</author><pubDate>Thu, 17 Aug 2017 20:18:00 +0800</pubDate><description><![CDATA[innodb_flush_log_at_trx_commit和sync_binlog 两个参数是控制MySQL磁盘写入策略以及数据安全性的关键参数。如果innodb_flush_log_at_trx_commit设置为0，log buffer将每秒一次地写入log file中，并且log file的flush(刷到磁盘)操作同时进行.该模式下，在事务提交的时候，不会主动触发写入磁盘的...]]></description><category></category></item><item><title><![CDATA[Nginx做web服务器linux内核参数优化]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075162</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075162</guid><author>abs9668</author><pubDate>Wed, 16 Aug 2017 15:53:00 +0800</pubDate><description><![CDATA[关于Linux内核参数的优化：

net.ipv4.tcp_max_tw_buckets = 6000

timewait的数量，默认是180000。

net.ipv4.ip_local_port_range = 1024 65000

允许系统打开的端口范围。

net.ipv4.tcp_tw_recycle = 1

启用timewait快速回收。
...]]></description><category></category></item><item><title><![CDATA[gitlab更改仓库存储位置]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075163</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075163</guid><author>abs9668</author><pubDate>Tue, 15 Aug 2017 16:31:00 +0800</pubDate><description><![CDATA[默认时GitLab的仓库存储位置在“/var/opt/gitlab/git-data/repositories”，在实际生产环境中我们一般都会划分一个独立的分区来存储仓库的数据，这里把数据存放在“/data/git-data”目录下。
# mkdir -pv /data/git-data
mkdir: 已创建目录 "/data"
mkdir: 已创建目录 "/data/git-...]]></description><category></category></item><item><title><![CDATA[gitlab卸载]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075147</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075147</guid><author>abs9668</author><pubDate>Tue, 15 Aug 2017 16:27:00 +0800</pubDate><description><![CDATA[卸载方法
在/opt/gitlab*中找不到uninstall文件，无法通过该方法卸载gitlab 
经过摸索，可通过以下方法彻底卸载gitlab
sudo gitlab-ctl stop
sudo gitlab-ctl uninstall
sudo gitlab-ctl cleanse
sudo rm -rf /opt/gitlab可通过sudo gitlab-ctl he...]]></description><category></category></item><item><title><![CDATA[MySQL权限分配]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075143</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075143</guid><author>abs9668</author><pubDate>Fri, 11 Aug 2017 10:16:00 +0800</pubDate><description><![CDATA[1、给一个数据库分配只读账号


GRANT SElECT ON `bstic`.* TO 'readonly'@'%' IDENTIFIED BY "123456";
or
GRANT SElECT ON bstic.* TO 'readonly'@'%' IDENTIFIED BY "123456";


2、多个数据库分配只读权限（只能单独一个一个的分配）...]]></description><category></category></item><item><title><![CDATA[通过shell脚本实现MySQL备份并恢复，for in流程控制]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075140</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075140</guid><author>abs9668</author><pubDate>Thu, 03 Aug 2017 17:58:00 +0800</pubDate><description><![CDATA[从3306备份数据库，还原到3307数据库上，通过shell脚本的for in流程控制实现


#!/bin/bash

my_date=`date +%Y%m%d`
my_time=`date +%H%M`
my_date_yesterday=`date +%Y%m%d --date='1 days ago'`

echo "------------------...]]></description><category></category></item><item><title><![CDATA[后台窗口运行任务screen]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075144</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075144</guid><author>abs9668</author><pubDate>Wed, 02 Aug 2017 11:16:00 +0800</pubDate><description><![CDATA[安装screen:


#yum install screen


创建新窗口：


#screen -S mysql


查看后台窗口：


#screen -ls


回到MySQL窗口：


#screen -r mysql


退出快捷键：
Ctrl+A+D

退出创建的窗口：
exit

转载于:http...]]></description><category></category></item><item><title><![CDATA[压缩目录下的文件]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075161</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075161</guid><author>abs9668</author><pubDate>Tue, 01 Aug 2017 20:44:00 +0800</pubDate><description><![CDATA[cd /data/cdt_api/logs/ &amp;&amp; gzip *.log.`date +%F -d 'yesterday'`error.log.2017-07-28.gzerror.log.2017-07-29.gzerror.log.2017-07-30.gz



转载于:https://www.cnblogs.com/qingchen-24K/p/7270...]]></description><category></category></item><item><title><![CDATA[随机密码生成---mkpasswd]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075160</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075160</guid><author>abs9668</author><pubDate>Tue, 01 Aug 2017 20:16:00 +0800</pubDate><description><![CDATA[1、安装mkpasswd


# yum install expect


2、用mkpasswd命令生成随机密码
参数：
-l 定义密码的长度，默认是9
-d 数字个数，默认是2
-c 小写字符个数，默认是2
-C 大写字符个数，默认是2
-s 特殊字符个数，默认是1



#man mkpasswd

FLAGS
       The -...]]></description><category></category></item><item><title><![CDATA[mysql存储过程]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075146</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075146</guid><author>abs9668</author><pubDate>Tue, 01 Aug 2017 14:11:00 +0800</pubDate><description><![CDATA[备份数据库时没有备份存储过程，备份存储过程需要加-R参数，然后再通过备份做master-slave模式
导出数据+表结构+存储过程+函数


#mysqldump -uroot -p -R abc &gt; abc.sql


-R (--routines:导出存储过程以及自定义函数)

然后做主从时，如果在master上删除存储过程，但是从上又没有该存储过程，那...]]></description><category></category></item><item><title><![CDATA[win10下VirtualBox虚拟机开机后台自启动]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075156</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075156</guid><author>abs9668</author><pubDate>Mon, 31 Jul 2017 11:18:00 +0800</pubDate><description><![CDATA[每次使用linux的时候，都是打开virtualBox--&gt;启动安装的linux系统--&gt;再用远程桌面（SSH等）连接，每次手动打开比较麻烦，而且linux虚拟机也有窗口，比较冗杂。如果能开机自启，并且后台运行linux虚拟机（没有可见窗口），那就开心了。
找到VirtualBox的安装目录      　　　　　　
我的virtualbox安装在 D:\v...]]></description><category></category></item><item><title><![CDATA[tcp状态统计脚本]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075157</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075157</guid><author>abs9668</author><pubDate>Mon, 31 Jul 2017 11:14:00 +0800</pubDate><description><![CDATA[tcp_status_ss.sh

#!/bin/bash 
#scripts for tcp status 
function SYNRECV { 
    n=`/usr/sbin/ss -ant | awk '{++s[$1]} END {for(k in s) print k,s[k]}' | grep 'SYN-RECV' | awk '{print $2}'`...]]></description><category></category></item><item><title><![CDATA[监控进程的io]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075155</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075155</guid><author>abs9668</author><pubDate>Fri, 28 Jul 2017 10:47:00 +0800</pubDate><description><![CDATA[#dstat --time --cpu --load --net --sys --disk --proc --top-cpu --top-mem --top-io --top-bio 10
mysqld   37.0M|init    40k 9105B|mysqld   0.1
mysqld   37.0M|sshd: root@ 388B...]]></description><category></category></item><item><title><![CDATA[mysql主从一致性校验]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075158</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075158</guid><author>abs9668</author><pubDate>Wed, 26 Jul 2017 16:25:00 +0800</pubDate><description><![CDATA[pt-table-checksum是查看主从一致性的工具， 网上很多人说 pt-table-checksum 要在主库上执行，其实不是的，我的mysql实例比较多，只需在某一台服务器上安装percona-toolkit，这台服务能够同时访问主库和从库就行了。
工具安装：
1.软件下载：


# wget https://www.percona.com/downloads/pe...]]></description><category></category></item><item><title><![CDATA[MySQL加密工具mysql_config_editor]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075154</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075154</guid><author>abs9668</author><pubDate>Tue, 25 Jul 2017 10:19:00 +0800</pubDate><description><![CDATA[从mysql5.6开始，mysql推出了加密工具mysql_config_editor。在此之前我们通过将账号和密码明文放入my.cnf，从而使用mysql客户端登录时，无需指定账号密码就可以登录数据库。而有了mysql_config_editor工具之后，我们将加密后的账号密码放入二进制文件。在登录时，客户端通过解密该文件来登录数据库。由于加密解密都在内存中进行，所以无法明文的显示文件...]]></description><category></category></item><item><title><![CDATA[RPM方式安装MySQL5.6]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075153</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075153</guid><author>abs9668</author><pubDate>Mon, 24 Jul 2017 20:14:00 +0800</pubDate><description><![CDATA[1、检查MySQL及相关RPM包，是否安装，如果有安装，则移除（rpm –e 名称）


# rpm -qa | grep -i mysql
mysql-libs-5.1.66-2.el6_3.x86_64
# yum -y remove mysql-libs*


2、下载对应的RPM包：


# ll
-rw-r--r-- 1 root root 184...]]></description><category></category></item><item><title><![CDATA[mysql之 percona-xtrabackup 2.4.7安装（热备工具）]]></title><link>https://blog.youkuaiyun.com/abs9668/article/details/102075145</link><guid>https://blog.youkuaiyun.com/abs9668/article/details/102075145</guid><author>abs9668</author><pubDate>Mon, 24 Jul 2017 20:09:00 +0800</pubDate><description><![CDATA[1.安装依赖包


#yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL

2. 安装percona-xtrabackup工具


# rpm -ivh percona-xtrabackup-24-2.4.7-1.el5.x86_64.rpm

提示缺少...]]></description><category></category></item></channel></rss>