<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ylqmf的专栏]]></title><description><![CDATA[擅长写诗和绘画，精通十以内加减法]]></description><link>https://blog.youkuaiyun.com/ylqmf</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ylqmf]]></copyright><item><title><![CDATA[postgresql 定时vacuum脚本]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/76596114</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/76596114</guid><author>ylqmf</author><pubDate>Wed, 02 Aug 2017 20:30:39 +0800</pubDate><description><![CDATA[# -*- coding: utf-8 -*-

import pg,multiprocessing

lst=[
{"dbname":"postgres","host":"127.0.01","port":5432,"user":"postgres","passwd":"123456"},
]

def exe_job(item):
    try:
        db = pg.DB(dbn]]></description><category></category></item><item><title><![CDATA[supervisord 启动后 ulimit 参数未生效]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/56841211</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/56841211</guid><author>ylqmf</author><pubDate>Fri, 24 Feb 2017 15:26:44 +0800</pubDate><description><![CDATA[#!/bin/bash
#
# supervisord   This scripts turns supervisord on
#
# Author:       Mike McGrath  (based off yumupdatesd)
#
# chkconfig:    - 95 04
#
# description:  supervisor is a process control util]]></description><category></category></item><item><title><![CDATA[PostgreSQL basebackup备份]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/53411459</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/53411459</guid><author>ylqmf</author><pubDate>Wed, 30 Nov 2016 18:07:40 +0800</pubDate><description><![CDATA[#!/bin/sh

lst=(
127.0.0.1:5432:xm_rep:123456
127.0.0.1:5432:xm_rep:123456
)

for item in ${lst[@]}
do
        host=$(echo ${item} | awk -F':' '{print $1}')
        port=$(echo ${item} | awk -F':' '{p]]></description><category></category></item><item><title><![CDATA[golang context.WithTimeout 超时处理]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/52245892</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/52245892</guid><author>ylqmf</author><pubDate>Thu, 18 Aug 2016 23:27:07 +0800</pubDate><description><![CDATA[package main

import (
    "golang.org/x/net/context"
    "log"
    "math/rand"
    "time"
)

func test(is_first *bool, prev_map *map[string]string) {
    rand.Seed(int64(time.Now().Nanosecond()))]]></description><category></category></item><item><title><![CDATA[mysql checksum table golang]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/51803136</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/51803136</guid><author>ylqmf</author><pubDate>Fri, 01 Jul 2016 17:15:00 +0800</pubDate><description><![CDATA[package main

import (
	"bytes"
	"database/sql"
	"fmt"
	_ "github.com/go-sql-driver/mysql"
	"io/ioutil"
	"regexp"
	"strconv"
	"strings"
	"sync"
)

var wg sync.WaitGroup

type DBinfo struct {
	user    ]]></description><category></category></item><item><title><![CDATA[暗黑破坏神 2 私服 sf 114.215.178.67]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/50835034</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/50835034</guid><author>ylqmf</author><pubDate>Wed, 09 Mar 2016 14:22:55 +0800</pubDate><description><![CDATA[注册表
REGEDIT4
[HKEY_CURRENT_USER\Software\Blizzard Entertainment\Diablo II]
"BNETIP"="114.215.178.67"




1.11b 原版]]></description><category></category></item><item><title><![CDATA[源码编译aerospike-server-3.6.4]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/50359676</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/50359676</guid><author>ylqmf</author><pubDate>Sat, 19 Dec 2015 21:17:57 +0800</pubDate><description><![CDATA[生产环境一直使用3.5.3这个版本，和开发商量了一下，在测试环境使用3.6.4搭建集群，如果运行稳定就找机会将生产环境的集群升级。
aerospike QQ群：419183757

从github上下载源码包
wget https://github.com/aerospike/aerospike-server/archive/3.6.4.zip

编译前将依赖包安装全
yum ins]]></description><category></category></item><item><title><![CDATA[文章标题]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/50352507</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/50352507</guid><author>ylqmf</author><pubDate>Fri, 18 Dec 2015 16:18:17 +0800</pubDate><description><![CDATA[本文转自：http://blog.youkuaiyun.com/songhuiqiao/article/details/50324139aerospike QQ群：419183757Distribution(分布) 
Aerospike数据库是为24/7运行、并能可靠处理大数据的应用程序提供的组件。开发应用程序时，你不必担心数据位于哪里。客户端自动发现数据位置并确保绝大多数请求处理是单跳的。应用程序可以视为数据]]></description><category></category></item><item><title><![CDATA[aerospike init]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/50352476</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/50352476</guid><author>ylqmf</author><pubDate>Fri, 18 Dec 2015 16:13:39 +0800</pubDate><description><![CDATA[本文转自：http://blog.youkuaiyun.com/songhuiqiao/article/details/50324109aerospike QQ群：419183757aerospike init(1)              aerospike manual              aerospike init(1)NAME 
       aerospike init - initiali]]></description><category></category></item><item><title><![CDATA[aerospike参考资料]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/50352447</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/50352447</guid><author>ylqmf</author><pubDate>Fri, 18 Dec 2015 16:10:06 +0800</pubDate><description><![CDATA[本文转自：http://blog.youkuaiyun.com/songhuiqiao/article/details/50324073http://blog.youkuaiyun.com/jiashiwen/article/category/3090193如果您的企业依赖于： 
庞大的数据量（超过任何结构化数据库所能处理的数据量） 
可预见（且快速）的性能 
透明的扩展 
始终正常运行 
那么您只有一个选择，那就是 Ae]]></description><category></category></item><item><title><![CDATA[mac ox ssd 开启 trim]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/43835349</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/43835349</guid><author>ylqmf</author><pubDate>Sun, 15 Feb 2015 15:10:34 +0800</pubDate><description><![CDATA[使用clover 补丁开启]]></description><category></category></item><item><title><![CDATA[使用cgroup 限制进程的磁盘io]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/43205163</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/43205163</guid><author>ylqmf</author><pubDate>Tue, 27 Jan 2015 22:45:09 +0800</pubDate><description><![CDATA[cat /etc/cgconfig.conf 
#
#  Copyright IBM Corporation. 2007
#
#  Authors:     Balbir Singh balbir@linux.vnet.ibm.com>
#  This program is free software; you can redistribute it and/or modify it
]]></description><category></category></item><item><title><![CDATA[旅游]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/39895299</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/39895299</guid><author>ylqmf</author><pubDate>Wed, 08 Oct 2014 16:27:49 +0800</pubDate><description><![CDATA[每次出游，我们自以为]]></description><category></category></item><item><title><![CDATA[mysql 事务 rollback 失效]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/39504805</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/39504805</guid><author>ylqmf</author><pubDate>Tue, 23 Sep 2014 21:43:07 +0800</pubDate><description><![CDATA[最近支付业务发生了一件怪事，在一个事务 失败后，调用rollback，发现只rollback 了最后一条sql。
开发查了很久，发现是网络抖动，造成第一次创建链接的 begin 丢掉了，后面再重连后就变成autocommit了，这样就造成rollback的时候前面的sql 全都没有rollback。


只能是在 begin 的时候加一个变量将应用服务器的时间戳打到mysql 服务器上，后]]></description><category></category></item><item><title><![CDATA[回想当年 91d2 1588 神戒]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/39371725</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/39371725</guid><author>ylqmf</author><pubDate>Thu, 18 Sep 2014 14:30:51 +0800</pubDate><description><![CDATA[quan]]></description><category></category></item><item><title><![CDATA[docker init 起步]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/39338795</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/39338795</guid><author>ylqmf</author><pubDate>Wed, 17 Sep 2014 10:20:40 +0800</pubDate><description><![CDATA[#yum install
wget
http://fedora.mirror.nexicom.net/epel/6/x86_64/epel-release-6-8.noarch.rpm
yum -y install epel-release-6-8.noarch.rpm
yum -y install docker-io


#wget install
yum install -y ]]></description><category></category></item><item><title><![CDATA[MySQL分组排序取前N条记录以及生成自动数字序列--group by 后 limit 外加 rownumber]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/39005949</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/39005949</guid><author>ylqmf</author><pubDate>Tue, 02 Sep 2014 14:46:12 +0800</pubDate><description><![CDATA[同事提了一个需求，要求按照某列分组，然后将各组的前几条抽取出来。
表结构
CREATE TABLE `total_freq_ctrl` (
  `time` int(10) unsigned NOT NULL,
  `machine` char(64) NOT NULL,
  `module` char(32) NOT NULL,
  `total_flow` int(10) unsigned]]></description><category></category></item><item><title><![CDATA[backup mysql for xtrabackup with xbstream and lz4]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/38985463</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/38985463</guid><author>ylqmf</author><pubDate>Mon, 01 Sep 2014 20:52:25 +0800</pubDate><description><![CDATA[需要临时为mysql添加一个实例，使用xtrabackup最简单快速。


在现有数据节点上：

/home/work/app/xtrabackup-2.2.3/innobackupex --ibbackup=/home/work/app/xtrabackup-2.2.3/xtrabackup --parallel=8 --defaults-file= ${BACKUP_CNF} --s]]></description><category></category></item><item><title><![CDATA[golang tcp 2 unix socket proxy]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/38856179</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/38856179</guid><author>ylqmf</author><pubDate>Tue, 26 Aug 2014 23:14:22 +0800</pubDate><description><![CDATA[想将mysql 的TCP 封死，所有外部链接由我的proxy来控制，so 写了一个 tcp 转 unix socket 的 proxy。


package main

import (
	"os"
	"fmt"
	"net"
	"io"
	"sync"
	"time"
)

type proxy struct{
	Host string
	Port string
	Local string]]></description><category></category></item><item><title><![CDATA[dell optiplex ubuntu 14.04 安装 NVIDIA 显卡驱动]]></title><link>https://blog.youkuaiyun.com/ylqmf/article/details/38020961</link><guid>https://blog.youkuaiyun.com/ylqmf/article/details/38020961</guid><author>ylqmf</author><pubDate>Mon, 21 Jul 2014 17:31:04 +0800</pubDate><description><![CDATA[公司配置的 dell optiplex使用核显带起双屏幕，玩dota2无法特效全开。so，在京东上买了一块750Ti。安装驱动的时候需要切换到ubuntu的全命令行模式，关掉桌面系统才能安装。这时候这个坑出现了，要想安装驱动，就必须进入全命令行模式，要想进入命令行模式必须有驱动。反复尝试后，发现只能用DP口带单屏幕才能成功。在这里特别记录下。嘎嘎]]></description><category></category></item></channel></rss>