mysql




select ip, active from (select * from %s where p_id = %d order by create_time desc) as tb group by ip having active = 1

一些命令：

show create teble table_name \G;

MYSQL压力测试之mysqlslap

create table user2(userid int(4) primary key not null auto_increment, id int);

测试表格

测试运行5000次查询


mysqlslap -h127.0.0.1 -uroot -pyourpassword --concurrency=1 --iterations=1 --create-schema=vimi --query='select * from vimi.user2;' --engine=innodb --number-of-queries=5000

自定义插入



mysqlslap -h127.0.0.1 -uroot -pyourpassword --concurrency=500 --iterations=1 --create-schema=vimi --query='insert into vimi.user2(id) value(1)' --engine=innodb --number-of-queries=5000

package main

import (
    "database/sql"
    "fmt"
    "time"

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

func main() {
    source := fmt.Sprintf("%s:%s@(%s:%s)/%s?parseTime=true&sql_mode=ansi",
        "root",
        "yourpassword",
        "127.0.0.1",
        "3306",
        "transaction")
    db, err := sql.Open("mysql", source)
    defer db.Close()

    fmt.Println(db, err)
    fmt.Println()
    // rows, err := db.Query("select * from user")
    // checkErr(err)
    // for rows.Next() {
    //     var userid, id int
    //     err = rows.Scan(&userid, &id)
    //     checkErr(err)
    //     fmt.Println(userid, id)
    // }
    ch := make(chan bool, 1)
    stop := false
    go func() {
        time.Sleep(time.Second)
        ch <- true
    }()
    go func() {
        stop = <-ch
    }()
    count := 0
    sql := `insert user set id = 444`
    for {
        count++
        stmt, err := db.Prepare(sql)
        checkErr(err)

        _, err = stmt.Exec()
        checkErr(err)
        if stop {
            break
        }
    }
    fmt.Println(count)
}

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

测试程序

----------------------------------------------------------最终版mysql效率测试--------------------------------------------------------------------------------------

环境：