golang mysql大量连接_go连接mysql产生大量连接

一直是这个问题困扰着哦我，为什么越来越多连接，到爆掉，换作postgresql驱动也是，还是我理解go语言并发有错呢

package main

import (

"database/sql"

"fmt"

_ "github.com/go-sql-driver/mysql"

"strconv"

"time"

)

var xiancheng = 10

var over = make(chan bool)

var sem = make(chan int, xiancheng)

func checkErr(err error, hh int) {

if err != nil {

fmt.Printf("error "+strconv.Itoa(hh)+"\n", err)

panic(err)

}

}

func getMySQL2() *sql.DB {

db, err := sql.Open("mysql", "root:123456789@tcp(127.0.0.1:3306)/getbbs?charset=utf8")

checkErr(err, 999)

return db

}

func work(aa int) string {

sem

dbx := getMySQL2()

defer dbx.C